Re: Using symbolic links with tablespaces - Mailing list pgsql-general

From Tom Lane
Subject Re: Using symbolic links with tablespaces
Date
Msg-id 15182.1252466039@sss.pgh.pa.us
Whole thread Raw
In response to Re: Using symbolic links with tablespaces  (miller_2555 <nabble.30.miller_2555@spamgourmet.com>)
Responses Re: Using symbolic links with tablespaces  (miller_2555 <nabble.30.miller_2555@spamgourmet.com>)
List pgsql-general
miller_2555 <nabble.30.miller_2555@spamgourmet.com> writes:
> So this does not work well apparently.

The only obvious thing wrong with your example is failing to preserve
ownership/permissions of the moved files.  I think the upper directories
are probably not readable by Postgres so it's choking.

BTW, Postgres *already* refers to tablespaces via symlinks, so you could
do this with a tad less runtime overhead by re-pointing the appropriate
symlink inside $PGDATA/pg_tblspc/.

            regards, tom lane

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: where clauses and multiple tables
Next
From: 纪晓曦
Date:
Subject: Re: Can I Save images in postgres?