Thread: Configfiles outside initDB dir

Configfiles outside initDB dir

From
Hannes Dorbath
Date:
Hi,

I want to have postgresql.conf and pg_hba.conf outside the directory
created by initDB.

$PGDATA points to the directory the config files reside in (and nothing
else) and in postgresql.conf the option "data_directory" is set to the
directory containing the cluster created by initDB. I can use pg_ctl
start but pg_ctl stop failes as it expects the pid file in the dir with
the config files. I tried the option "external_pid_file". A second pid
file in the config files dir is created but never deleted.

How to do it correctly?

Thanks

--
Regards,
Hannes Dorbath

Re: Configfiles outside initDB dir

From
Tom Lane
Date:
Hannes Dorbath <light@theendofthetunnel.de> writes:
> I want to have postgresql.conf and pg_hba.conf outside the directory
> created by initDB.

> $PGDATA points to the directory the config files reside in (and nothing
> else) and in postgresql.conf the option "data_directory" is set to the
> directory containing the cluster created by initDB. I can use pg_ctl
> start but pg_ctl stop failes as it expects the pid file in the dir with
> the config files.

I think you want pg_ctl's PGDATA pointing to the data_directory.  pg_ctl
does not know anything about the config files, and in particular is not
smart enough to parse them to find the data_directory value.

            regards, tom lane