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

Re: Move 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 completly
Date: 2008-06-18 16:30:13
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
wolfgang(dot)graf(at)ksb(dot)com writes:
> is there a way to move the 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-2017 The PostgreSQL Global Development Group