Re: moving postgresql.conf: pg_ctl can't find postmaster.pid anymore

Tom Lane wrote:
> Ludo Smissaert <ludo@ludikidee.com> writes:
>> Both methods works fine on server startup, but the first method gives
>> problems when stopping the server with pg_ctl.
>
> Yeah, pg_ctl is far too stupid to cope with such things --- it expects
> that PGDATA points at the data directory.  Short of teaching it to parse
> the config file it's not clear what we could do about that.

Thanks. Summarizing:

$ ls /etc/postgresql
postgresql.conf pg_hba.conf pg_ident.conf

$ pg_ctl -D /var/postgresql/data -o "-D /etc/postgresql" start -l ...

... server started

$ pg_ctl -D /var/postgresql/data -o "-D /etc/postgresql" stop -m fast

works for the first method, and for the second:

$ pg_ctl -D /var/postgresql/data/ \
   -o "-c config_file='/etc/postgresql/postgresql.conf'" -l ... start

and for stopping the same.

Have a nice day/night,

Ludo