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.

-- 
  Bruce Momjian  <br...@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to