Date: Mon, 22 Jun 2015 16:21:53 +0200
From: Rainer Leo <leo@workfile.de>
Reply-To: Rainer Leo <leo@workfile.de>
Organization: workfile Datenbankservice
Message-ID: <1102220903.20150622162153@workfile.de>
To: pgsql-admin@postgresql.org
Subject: Re: pg_upgrade
In-Reply-To: <5587E6F9.50702@afilias.info>
References: <1862034146.20150622111438@workfile.de>
 <e84cbc3cee08d8569cd670860c2b1900@imap.lan.net> <5587E6F9.50702@afilias.info>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

>>>  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=20
>> pg_dump + pg_restore is "logical" (dump data and schemal to SQL=20
>> instructions). If you go that way also check pg_dumpall for dumping=20
>> the globals.


>> Regards

>> Jan


> Also, for 1+2 you would be advised to do the pg_dump/restore using the=20
> *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


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin