Re: Scanning pg_tablespace from walsender - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: Scanning pg_tablespace from walsender
Date
Msg-id 20110103162946.GK4933@tamriel.snowman.net
Whole thread Raw
In response to Re: Scanning pg_tablespace from walsender  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
* Magnus Hagander (magnus@hagander.net) wrote:
> It's already a basic requirement that they need to be the same -
> replicating over a CREATE TABLESPACE is going to fail otherwise..
> Being able to deal with that in a nice way would be good, of course,
> but we don't have that today.

If CREATE TABLESPACE replication also looked at the flag I was
proposing, it could work. :)  Of course, the admin wouldn't be able
to move the directory/change the symlink to where they actually want
it to be w/o taking the replication server down, but I'm not sure
that's a show-stopper...

It's certainly not the cleanest/nicest approach, don't get me wrong, but
I really hate the idea of forcing people to have an identical filesystem
layout on the slave that they have on the master.
Stephen

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Streaming replication as a separate permissions
Next
From: Simon Riggs
Date:
Subject: Re: Re: new patch of MERGE (merge_204) & a question about duplicated ctid