| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us>, rob stone <floriparob(at)gmail(dot)com> |
| Cc: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Running pg_upgrade under Debian |
| Date: | 2015-04-20 21:41:09 |
| Message-ID: | 55357275.7020605@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)comp
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2015-04-20 21:42:20 | Re: Running pg_upgrade under Debian |
| Previous Message | Andomar | 2015-04-20 20:41:58 | Re: Waiting on ExclusiveLock on extension |