Re: [GENERAL] pg_hba reload
--- On Sat, 2/14/09, Bob Pawley wrote: > From: Bob Pawley > Subject: Re: [GENERAL] pg_hba reload > To: "John R Pierce" , "PostgreSQL" > > 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" -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] pg_hba reload
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" -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] pg_hba reload
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" > To: "PostgreSQL" > 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_00.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 > > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] pg_hba reload
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" To: "PostgreSQL" 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_00.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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
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_00.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
Re: [GENERAL] pg_hba reload
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 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 >
Re: [GENERAL] pg_hba reload
On Sat, Feb 14, 2009 at 3:10 PM, 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. -D points to the data directory, which looks like this: basepg_clog pg_subtrans pg_twophase pg_xlog postmaster.pid server.crt global pg_multixact pg_tblspcPG_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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] pg_hba reload
export PGDATA=/path/to/data -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] 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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
