Re: Move postmater.pid completly - Mailing list pgsql-admin

From Tom Lane
Subject Re: Move postmater.pid completly
Date
Msg-id 28495.1213806613@sss.pgh.pa.us
Whole thread Raw
In response to Move postmater.pid completly  (wolfgang.graf@ksb.com)
List 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

pgsql-admin by date:

Previous
From: wolfgang.graf@ksb.com
Date:
Subject: Move postmater.pid completly
Next
From: "pradeep kumar"
Date:
Subject: URGENT: how to GRANT privillages to user/role on relation's row??