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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
