Re: Running pg_upgrade under Debian - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Running pg_upgrade under Debian
Date
Msg-id 20150420221812.GZ4369@alvh.no-ip.org
Whole thread Raw
In response to Re: Running pg_upgrade under Debian  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Running pg_upgrade under Debian
List pgsql-general
Bruce Momjian wrote:
> On Mon, Apr 20, 2015 at 07:06:37PM -0300, Alvaro Herrera wrote:
> > ISTM there's a documentation bug here: in the code, the "dump" method
> > checks for tablespaces and raises an error if they are found, but the
> > "upgrade" method does not check.  I think the documentation should state
> > that only the dump method does not support tablespaces.
>
> OK, it would be nice if someone could report that to upstream Debian.

That's why I added myon@debian.org to the CC list.

> I am a little confused why pg_dump/pg_restore can't use tablespaces
> though.  Years ago we used to not use PG-major-version-specific
> subdirectories in tablespaces, but we added that for pg_upgrade, and I
> am sure they would work fine for pg_dump too.

Maybe they haven't gotten the memo yet.  This was implemented in 9.0,
and as I recall Debian supported 8.4 until recently.  Perhaps they just
need to remove the check now.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Running pg_upgrade under Debian
Next
From: Adrian Klaver
Date:
Subject: Re: Running pg_upgrade under Debian