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 <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
