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

From Magnus Hagander
Subject Re: Scanning pg_tablespace from walsender
Date
Msg-id AANLkTik3M67OX5XYhsfvgtHbyyhdH45X1ievuZDUU5B3@mail.gmail.com
Whole thread Raw
In response to Re: Scanning pg_tablespace from walsender  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Scanning pg_tablespace from walsender  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Mon, Jan 3, 2011 at 16:40, Robert Haas <robertmhaas@gmail.com> wrote:
> On Mon, Jan 3, 2011 at 10:37 AM, Magnus Hagander <magnus@hagander.net> wrote:
>> On Mon, Jan 3, 2011 at 16:34, Robert Haas <robertmhaas@gmail.com> wrote:
>>> On Mon, Jan 3, 2011 at 10:25 AM, Magnus Hagander <magnus@hagander.net> wrote:
>>>> I'm working on completing Heikki's patch for streaming base backups,
>>>> and have run into a problem:
>>>>
>>>> In order to dump all tablespaces properly, I have to know where they
>>>> are (d'uh).
>>>
>>> Can you get that directly from the filesystem layout?
>>
>> Hmm. I guess we could enumerate the pg_tblspc directory, and call
>> readlink() on all the symlinks in there. Assuming all platforms can do
>> readlink() (we'd obviously need a special windows implementation,  but
>> that's doable I guess).
>>
>> I just figured it'd be a lot cleaner to read it from our own catalogs...
>
> I don't even see why you'd need readlink.  Can't you just traverse the symlinks?

Well, they need to be put back in the same location on the other
machine (slave in case of replication, tarball otherwise). If I just
traverse the symlinks, they'll just appears as a subdirectory of
pg_tblspc on the other machine, won't they?

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Scanning pg_tablespace from walsender
Next
From: Alvaro Herrera
Date:
Subject: Re: Scanning pg_tablespace from walsender