On Wed, 2004-03-03 at 04:59, Tom Lane wrote: > What might make sense is some sort of marker file in a > tablespace directory that links back to the owning $PGDATA directory. > CREATE TABLESPACE should create this, or reject if it already exists.
It will not be enough for the marker to list the path of the parent $PGDATA, since that path might get changed by system administration action. The marker should contain some sort of unique string which would match the same string somewhere in $PGDATA. Then, if either tablespace or $PGDATA were moved, it would be possible to tie the two back together. It wouldn't be an issue on most normal systems, but might be of crucial importance for an ISP running numerous separate clusters. -- Oliver Elphick <[EMAIL PROTECTED]> LFIX Ltd ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster