From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, rob stone <floriparob(at)gmail(dot)com>, Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>, pgsql-general(at)postgresql(dot)org, myon(at)debian(dot)org |
Subject: | Re: Running pg_upgrade under Debian |
Date: | 2015-04-20 22:06:37 |
Message-ID: | 20150420220637.GX4369@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
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.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2015-04-20 22:09:00 | Re: Running pg_upgrade under Debian |
Previous Message | Bruce Momjian | 2015-04-20 22:05:32 | Re: Running pg_upgrade under Debian |