Horton

Re: [HACKERS] Moving tablespaces

Andrew Dunstan <andrew@dunslane.net>

View thread
From: Andrew Dunstan <andrew@dunslane.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Magnus Hagander <magnus@hagander.net>, Bruce Momjian <bruce@momjian.us>, PostgreSQL-documentation <pgsql-docs@postgresql.org>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2011-12-04T16:55:41Z
Lists: pgsql-hackers 

On 12/04/2011 11:41 AM, Tom Lane wrote:
>
>> 1) Remove the column. Rely on the symlink. Create a
>> pg_get_tablespace_location(oid) function, that could be used by
>> pg_dumpall and friends, that just reads the symlink.
> Hm, how portable is symlink-reading?  If we can actually do that
> without big headaches, then +1.
>


I wondered that, specifically about Windows junction points, but we seem 
to have support for it already in dirmod.c::pgreadlink(). Surely there's 
no other currently supported platform where it would even be a question?

cheers

andrew