On 21.02.2010 00:22, Greg Stark wrote: > On Sat, Feb 20, 2010 at 10:42 PM, Andrzej Zawadzki <zawadaa@xxxxxxxxx> wrote: > >> Downgrade to 7.4 >> Dump >> Upgrade >> Restore >> >> > Actually that's not the best way. > > True bat not easier for beginner ;-) > The best way is to install 7.4 and 8.1.19 (not 8.1.11 which has known > bugs) at the same time. > > Use the pg_dump *from* *8.1.19* to connect to the 7.4 server and dump > the database. > Then shut down 7.4 and start up 8.1.19 and use pg_restore to restore > the database. > BTW. Isn't better make static (?) (stand alone) build of pg_dump(all)? Postgresql engine could be 7.1 and pg_dump will in 8.1 version. Much easier to upgrade on one machine. -- Andrzej Zawadzki -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
