Re: pg_upgrade

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