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