Re: Alternative database locations are broken - Mailing list pgsql-hackers

From Vadim Mikheev
Subject Re: Alternative database locations are broken
Date
Msg-id 017c01c046ee$edf39be0$b87a30d0@sectorbase.com
Whole thread Raw
In response to RE: Alternative database locations are broken  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Alternative database locations are broken  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
List pgsql-hackers
> >> I think that to handle locations we could symlink catalogs - ln -s
> >> path_to_database_in_some_location .../base/DatabaseOid
> 
> > But that's a kludge.  We ought to discourage people from messing with the
> > storage internals.
> 
> It's not a kluge, it's a perfectly fine implementation.  The only kluge
> here is if people have to reach in and establish such symlinks by hand.
> We want to set up a user interface that hides the implementation.

Agreed. And I don't see problems with handling this at CREATE DATABASE
time. Create database dir in specified location, create symlink from
base dir and remember location name in pg_database.datpath.

Vadim




pgsql-hackers by date:

Previous
From: "Vadim Mikheev"
Date:
Subject: Re: Transaction ID wraparound: problem and proposed solution
Next
From: Peter Mount
Date:
Subject: Re: Current CVS broken?