Re: pg_upgrade

On 2015-06-22 12:36 PM, Jan Lentfer wrote:
> 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
>
>
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