>>> we are still using PostgreSQL 9.0.2 on Windows Server. >>> Now we are migrating to Windows Server 2012 R2 and we >>> would like to migrate PostgreSQL at the same time to >>> the current version 9.4.4-1 >>> Which is the best way to migrate the data? >>> 1. pg_dump on the old server >>> 2. pg_retore on the new server >>> 3. pg_upgrade on the new server >>> Is this correct or is there a "best procedure" to do this? >> You do either 1 + 2 OR 3. pg_upgrade is binary upgrade, where as >> pg_dump + pg_restore is "logical" (dump data and schemal to SQL >> instructions). If you go that way also check pg_dumpall for dumping >> the globals. >> Regards >> Jan > Also, for 1+2 you would be advised to do the pg_dump/restore using the > *new* binaries (9.4), things could get tricky otherwise... > Ziggy Thanks for your help. Using the 9.4 pg_dump on the old server did not work (missing libintl-8.dll), so I used the 9.0 pg_dump. pg_restore on the new server worked fine, BUT the perfomance is lousy, for example a query that took 1732ms on the old server now takes longer than 32000ms every time on 9.4 I tuned the postgres.conf exactly like the old one, except for more RAM in some parameters. Does this mean I have to install 9.4 on the old server so I can use pg_upgrade? Rainer -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
