pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Configfiles outside initDB dir
2+ messages / 2 participants
[nested] [flat]

* Configfiles outside initDB dir
@ 2005-12-14 13:59  Hannes Dorbath <light@theendofthetunnel.de>
  0 siblings, 1 reply; 2+ messages in thread

From: Hannes Dorbath @ 2005-12-14 13:59 UTC (permalink / raw)
  To: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Configfiles outside initDB dir
@ 2005-12-14 15:33  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Hannes Dorbath <light@theendofthetunnel.de>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2005-12-14 15:33 UTC (permalink / raw)
  To: Hannes Dorbath <light@theendofthetunnel.de>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-12-14 15:33 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-12-14 13:59 Configfiles outside initDB dir Hannes Dorbath <light@theendofthetunnel.de>
2005-12-14 15:33 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox