Re: Tablespaces - Mailing list pgsql-hackers

From Marko Karppinen
Subject Re: Tablespaces
Date
Msg-id 9A79CD2E-7094-11D8-8995-000A95C56374@karppinen.fi
Whole thread Raw
In response to Re: Tablespaces  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Tablespaces  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-hackers
On 3 March 2004, at 19:52, Bruce Momjian wrote:
> The advantage of symlinks is that an administrator could see how things
> are laid out from the command line.

One thing to keep in mind is that system administrators don't see
symlinks as being informational -- they see them as the actual UI
for the redirection in question. So their expectation is that they'll
be able to move the actual directory around at will (as long as they
update the symlink to match).

If symlinks are used, the rule of least surprise would mean that
no information whatsoever about the physical location of a tablespace
should be stored in the system catalogs. Otherwise their relationship
with the information stored in the symlink is ambiguous.

mk



pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Slony-I makes progress
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: 7.4.2 ... all commits in?