Re: pg_migrator issues

Bruce Momjian wrote:
> Alvaro Herrera wrote:
> > > 2)  Right now pg_migrator renames old tablespaces to .old, which fails
> > > if the tablespaces are on mount points.  I have already received a
> > > report of such a failure.
> > 
> > I thought it was impossible to use bare mountpoints as tablespaces due
> > to ownership problems ... Is that not the case?  -1 for special hacks
> > that work around bogus setups, if that means intrusive changes to the
> > core code.
> 
> I talked to the person who reported the problem and he and I confirmed
> that it is quite easy to make the mount point be owned by the postgres
> user and have that function as a tablespace.  Is that not a supported
> setup?  There is probably a larger problem that the tablespace must be
> located in a directory that has directory rename permission for
> postgres.  I have updated the pg_migrator INSTALL file to mention this
> issue.

Oh, the actual INSTALL warning is:

	If you are using tablespaces, there must be sufficient directory
	permissions to allow each tablespace directory to be renamed with a
	".old" suffix.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +