Re: Tablespaces - Mailing list pgsql-hackers

From Gavin Sherry
Subject Re: Tablespaces
Date
Msg-id Pine.LNX.4.58.0403031541280.29986@linuxworld.com.au
Whole thread Raw
In response to Re: Tablespaces  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Tablespaces  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Tablespaces  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
On Tue, 2 Mar 2004, Bruce Momjian wrote:

> Gavin Sherry wrote:
> > Actually, I think that's a pretty good idea :-). I'd solves a bunch of
> > issues in the backend (postmaster start up can recurse through
> > $PGDATA/tablespaces looking for postmaster.pid files) and will also assist
> > admins with complex configurations (perhaps).
>
> Why are you asking about postmaster.pid files.  That file goes in the
> top level /data directory, no?

I was trying to be paranoid about users who have multiple postmasters on
the same machine and want to share a table space while both systems are
live. There'd be no mechanism to test for that situation if we didn't have
something like a postmaster.pid file. Is this being a little too paranoid?

Gavin


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Tablespaces
Next
From: Tom Lane
Date:
Subject: Re: Out of space situation and WAL log pre-allocation (was Tablespaces)