Re: Move postmater.pid completly

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: wolfgang(dot)graf(at)ksb(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Move postmater.pid completly
Date: 2008-06-18 16:30:13
Message-ID: 28495.1213806613@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

wolfgang(dot)graf(at)ksb(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message pradeep kumar 2008-06-18 17:05:13 URGENT: how to GRANT privillages to user/role on relation's row??
Previous Message Andrew Sullivan 2008-06-18 13:55:48 Re: full-text search question