Thread: pg_hba reload
I am attempting to load postmaster. pg_ctl reload I don't understand what is needed for [-D DATADIR]. I have tried the path to Postgresql with no luck. I've also leftoff [-s] since it doesn't appear to be needed. Help would be appreciated. Bob.
export PGDATA=/path/to/data
On Sat, Feb 14, 2009 at 3:10 PM, Bob Pawley <rjpawley@shaw.ca> wrote: > I am attempting to load postmaster. > > pg_ctl reload > > I don't understand what is needed for [-D DATADIR]. I have tried the path to > Postgresql with no luck. > > I've also leftoff [-s] since it doesn't appear to be needed. -D points to the data directory, which looks like this: base pg_clog pg_subtrans pg_twophase pg_xlog postmaster.pid server.crt global pg_multixact pg_tblspc PG_VERSION postmaster.opts root.crt server.key Is your db normally started from a startup script (like on ubuntu or redhat)? if so, then call it with the reload command. On ubuntu it looks like this: sudo /etc/init.d/postgresql-8.3 reload And that will handle the whole -D thing for you.
Hi,
The swithc -d is for the directory that is populated when running initdb, it contains logging, configuration and databases
Hope this helps
Regards,
Serge Fonville
On Sat, Feb 14, 2009 at 11:10 PM, Bob Pawley <rjpawley@shaw.ca> wrote:
I am attempting to load postmaster.
pg_ctl reload
I don't understand what is needed for [-D DATADIR]. I have tried the path to Postgresql with no luck.
I've also leftoff [-s] since it doesn't appear to be needed.
Help would be appreciated.
Bob.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Bob Pawley wrote:
> I am attempting to load postmaster.
>
> pg_ctl reload
>
> I don't understand what is needed for [-D DATADIR]. I have tried the
> path to Postgresql with no luck.
>
> I've also leftoff [-s] since it doesn't appear to be needed.
>
> Help would be appreciated.
unclear from your description what help you specifically need. there's
no actual questions there..
what happened when you "attempt" this?
the DATADIR is the full path to the postgres data directory, such as
/var/lib/pgsql/data on my RHEL/CentOS linux systems or "/program
files/postgresql/8.3/data" on a windows system. the -s flag is
'silent' and yes, quite unneccessary here. the only output from a
'reload' command is 'server signaled', to find out if it was successful,
you'd need to check the server logfile, such as
DATADIR/pg_log/postgresql-2009-02-14_000000.log, where you'd see
something like...
LOG: received SIGHUP, reloading configuration files
as a response to the reload request.
I'm running 8.3 on Windows XP. I input > pg_ctl reload -D c:\program files\postgresql\8.3\data - or any combination thereof, with or without brackets and the server is running. The return is - 'pg_ctl: too many command-line arguments'. Bob ----- Original Message ----- From: "John R Pierce" <pierce@hogranch.com> To: "PostgreSQL" <pgsql-general@postgresql.org> Sent: Saturday, February 14, 2009 2:25 PM Subject: Re: [GENERAL] pg_hba reload > Bob Pawley wrote: >> I am attempting to load postmaster. >> >> pg_ctl reload >> >> I don't understand what is needed for [-D DATADIR]. I have tried the path >> to Postgresql with no luck. >> >> I've also leftoff [-s] since it doesn't appear to be needed. >> >> Help would be appreciated. > > unclear from your description what help you specifically need. there's > no actual questions there.. > > what happened when you "attempt" this? > > the DATADIR is the full path to the postgres data directory, such as > /var/lib/pgsql/data on my RHEL/CentOS linux systems or "/program > files/postgresql/8.3/data" on a windows system. the -s flag is 'silent' > and yes, quite unneccessary here. the only output from a 'reload' > command is 'server signaled', to find out if it was successful, you'd need > to check the server logfile, such as > DATADIR/pg_log/postgresql-2009-02-14_000000.log, where you'd see something > like... > > LOG: received SIGHUP, reloading configuration files > > as a response to the reload request. > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general
Use quotes, there is a space between program and files pg_ctl reload -D "c:\program files\postgresql\8.3\data" On Sat, 2009-02-14 at 15:31 -0800, Bob Pawley wrote: > I'm running 8.3 on Windows XP. > > I input > pg_ctl reload -D c:\program files\postgresql\8.3\data - or any > combination thereof, with or without brackets and the server is running. > > The return is - 'pg_ctl: too many command-line arguments'. > > Bob > ----- Original Message ----- > From: "John R Pierce" <pierce@hogranch.com> > To: "PostgreSQL" <pgsql-general@postgresql.org> > Sent: Saturday, February 14, 2009 2:25 PM > Subject: Re: [GENERAL] pg_hba reload > > > > Bob Pawley wrote: > >> I am attempting to load postmaster. > >> > >> pg_ctl reload > >> > >> I don't understand what is needed for [-D DATADIR]. I have tried the path > >> to Postgresql with no luck. > >> > >> I've also leftoff [-s] since it doesn't appear to be needed. > >> > >> Help would be appreciated. > > > > unclear from your description what help you specifically need. there's > > no actual questions there.. > > > > what happened when you "attempt" this? > > > > the DATADIR is the full path to the postgres data directory, such as > > /var/lib/pgsql/data on my RHEL/CentOS linux systems or "/program > > files/postgresql/8.3/data" on a windows system. the -s flag is 'silent' > > and yes, quite unneccessary here. the only output from a 'reload' > > command is 'server signaled', to find out if it was successful, you'd need > > to check the server logfile, such as > > DATADIR/pg_log/postgresql-2009-02-14_000000.log, where you'd see something > > like... > > > > LOG: received SIGHUP, reloading configuration files > > > > as a response to the reload request. > > > > -- > > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-general > >
Bob Pawley wrote: > I'm running 8.3 on Windows XP. > > I input > pg_ctl reload -D c:\program files\postgresql\8.3\data - > or any combination thereof, with or without brackets and the server is > running. > > The return is - 'pg_ctl: too many command-line arguments'. you need to put " " around any pathname that has a space in it. like, pg_ctl reload -D "c:\program files\postgresql\8.3\data"
--- On Sat, 2/14/09, Bob Pawley <rjpawley@shaw.ca> wrote: > From: Bob Pawley <rjpawley@shaw.ca> > Subject: Re: [GENERAL] pg_hba reload > To: "John R Pierce" <pierce@hogranch.com>, "PostgreSQL" <pgsql-general@postgresql.org> > Date: Saturday, February 14, 2009, 11:31 PM > I'm running 8.3 on Windows XP. > > I input > pg_ctl reload -D c:\program > files\postgresql\8.3\data - or any > combination thereof, with or without brackets and the server > is running. > > The return is - 'pg_ctl: too many command-line > arguments'. > Maybe the problem is te blank space in Program Files test with pg_ctl reload -D "c:\program files\postgresql\8.3\data"