Re: 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" <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