Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group