pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Move postmater.pid completly 2+ messages / 2 participants [nested] [flat]
* Move postmater.pid completly @ 2008-06-18 10:28 wolfgang.graf@ksb.com 0 siblings, 1 reply; 2+ messages in thread From: wolfgang.graf@ksb.com @ 2008-06-18 10:28 UTC (permalink / raw) To: pgsql-admin Hello, is there a way to move the postmaster.pid file completely out of the PGDATA directory ? Setting the external_pid_file option in postgres.conf would only create a second file. Background: we would like to start a postmaster instance on a readonly directory to enable a server for readonly operations (SELECT) only. Wolfgang Graf KSB Group ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Move postmater.pid completly @ 2008-06-18 16:30 Tom Lane <tgl@sss.pgh.pa.us> parent: wolfgang.graf@ksb.com 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2008-06-18 16:30 UTC (permalink / raw) To: wolfgang.graf@ksb.com; +Cc: pgsql-admin wolfgang.graf@ksb.com writes: > is there a way to move the postmaster.pid file > completely out of the PGDATA directory ? No, and it's unlikely to be seriously considered, because of the enormously increased risk of starting two postmasters in the same directory. All it would take is for them to have different ideas of where the lock file is. > Background: we would like to start a postmaster instance on a readonly > directory to enable a server for readonly operations (SELECT) only. That won't ever work; the pid file is just the tip of the iceberg. regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-06-18 16:30 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2008-06-18 10:28 Move postmater.pid completly wolfgang.graf@ksb.com 2008-06-18 16:30 ` 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