Re: Running pg_upgrade under Debian

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(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.
>

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(dot)klaver(at)aklaver(dot)com