Re: Tablespaces

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: olly(at)lfix(dot)co(dot)uk
Cc: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Tablespaces
Date: 2004-03-03 14:36:53
Message-ID: 12449.1078324613@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-hackers-win32

Oliver Elphick <olly(at)lfix(dot)co(dot)uk> writes:
> It will not be enough for the marker to list the path of the parent
> $PGDATA, since that path might get changed by system administration
> action. The marker should contain some sort of unique string which
> would match the same string somewhere in $PGDATA.

We have already added a notion of a "unique installation identifier"
for PITR purposes (look in pg_control). So we could use that for this
purpose if we wanted to.

But I'm not sure how important it really is. AFAICS the behavior of
CREATE TABLESPACE will be "create marker file, if it already exists
then abort". It has no need to actually look in the file and so there's
no need for the contents to be unique.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-03-03 15:12:18 Re: Thread safe connection-name mapping in ECPG. Is it
Previous Message Tom Lane 2004-03-03 14:30:53 Re: [HACKERS] Tablespaces

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Andrew Dunstan 2004-03-03 15:16:17 Re: [HACKERS] Tablespaces
Previous Message Tom Lane 2004-03-03 14:30:53 Re: [HACKERS] Tablespaces