Re: Running pg_upgrade under Debian

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, rob stone <floriparob(at)gmail(dot)com>, Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>, pgsql-general(at)postgresql(dot)org, myon(at)debian(dot)org
Subject: Re: Running pg_upgrade under Debian
Date: 2015-04-20 22:18:12
Message-ID: 20150420221812.GZ4369@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)debian(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-04-21 00:34:04 Re: Running pg_upgrade under Debian
Previous Message Bruce Momjian 2015-04-20 22:09:00 Re: Running pg_upgrade under Debian