On Mon, 2009-07-27 at 22:48 +0200, Thomas Kellerer wrote: > Tory M Blue wrote on 27.07.2009 22:45: > > And those that have multiple TB's of data, weee another dump and > > restore upgrade (pfffft!!!!!) > > Isn't that what pg_migrator is for?
It depends, 8.3 and 8.4 are not compatible by default (because of --integer-datetimes). So, yeah if you are running Debian/Ubuntu but if you are running Cent/RH with the defaults, pg_migrator isn't going to work unless you compile Pg from source. Joshua D. Drake -- PostgreSQL - XMPP: jdr...@jabber.postgresql.org Consulting, Development, Support, Training 503-667-4564 - http://www.commandprompt.com/ The PostgreSQL Company, serving since 1997 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general