On 04/20/2015 12:49 PM, Bruce Momjian wrote:
> On Sat, Apr 18, 2015 at 09:08:20AM +1000, rob stone wrote:
>>> For what it's worth: Debian provides a
>>>
>>> pg_upgradecluster
>>>
>>> tailored to its specific setup of PostgreSQL clusters. That
>>> has worked well for me across several major version bumps.
>>>
>>> Karsten
>>>
>>
>> Indeed I have that program installed in /usr/lib but the man pages state
>> that it cannot handle tablespaces.
>
> Wow, that is odd. I wonder why.
>
Best guess is because pg_upgradecluster is a wrapper script that by
default uses pg_dump/pg_restore. Using is pg_upgrade is the second choice.
http://manpages.ubuntu.com/manpages/trusty/man8/pg_upgradecluster.8.html
--
Adrian Klaver
adrian.klaver@aklaver.comp