Am 2015-06-22 11:14, schrieb Rainer Leo:
pg_upgrade Hello, 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
