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

From Adrian Klaver
Subject Re: Running pg_upgrade under Debian
Date
Msg-id 55359AFC.6070301@aklaver.com
Whole thread Raw
In response to Re: Running pg_upgrade under Debian  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-general
On 04/20/2015 03:18 PM, Alvaro Herrera wrote:
> 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.
>

Well in the code I see a checks for >= 8.2 stepping up to 9.4, so I not
sure they could just remove it.

--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Running pg_upgrade under Debian
Next
From: rob stone
Date:
Subject: Re: Running pg_upgrade under Debian