Re: Running pg_upgrade under Debian

On 04/20/2015 02:42 PM, Bruce Momjian wrote:
> On Mon, Apr 20, 2015 at 02:41:09PM -0700, Adrian Klaver wrote:
>> 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
>
> But pg_upgrade supports tablespaces, and I assume pg_dump/pg_restore do
> as well.
>

I don't think it is about the underlying programs, it is about teaching
the wrapper script what do with the choices. Sort of like pgAdmin not
supporting all pg_backup/pg_restore combinations or for that matter
pg_restore not knowing what to do with a plain text pg_dump file.

--
Adrian Klaver
adrian.klaver@aklaver.com