Re: pg_upgrade

>>> 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