Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M44188=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1Z6xoq-0003gO-Mx
 for pgsql-admin@arkaria.postgresql.org; Mon, 22 Jun 2015 09:15:08 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.84) (envelope-from
 <pgsql-admin-owner+M44188=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1Z6xoo-0003XT-JM
 for pgsql-admin@arkaria.postgresql.org; Mon, 22 Jun 2015 09:15:06 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <leo@workfile.de>) id 1Z6xon-0003X6-82
 for pgsql-admin@postgresql.org; Mon, 22 Jun 2015 09:15:05 +0000
Received: from mailout-afa67.mailout.artfiles.de ([212.72.176.67])
 by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA1:256)
 (Exim 4.84) (envelope-from <leo@workfile.de>) id 1Z6xoe-0007V1-O0
 for pgsql-admin@postgresql.org; Mon, 22 Jun 2015 09:15:03 +0000
Received: from p5dc866cd.dip0.t-ipconnect.de ([93.200.102.205] helo=localhost)
 auth=leo@workfile.de
 by mailout.artfiles.de with esmtpsa (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256)
 (Exim 4.80.1) id 1Z6xoZ-0006WG-1i
 for pgsql-admin@postgresql.org; Mon, 22 Jun 2015 11:14:51 +0200
Date: Mon, 22 Jun 2015 11:14:38 +0200
From: Rainer Leo <leo@workfile.de>
Reply-To: Rainer Leo <leo@workfile.de>
Organization: workfile Datenbankservice
X-Priority: 3 (Normal)
Message-ID: <1862034146.20150622111438@workfile.de>
To: pgsql-admin@postgresql.org
Subject: pg_upgrade
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="----------9B18281B1D4B0D"
X-Antivirus: avast! (VPS 150622-0, 22.06.2015), Outbound message
X-Antivirus-Status: Clean
X-Pg-Spam-Score: -0.0 (/)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

------------9B18281B1D4B0D
Content-Type: text/plain; charset=iso-8859-15
Content-Transfer-Encoding: quoted-printable

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=20
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?


Regards,
Rainer Leo
------------9B18281B1D4B0D
Content-Type: text/html; charset=iso-8859-15
Content-Transfer-Encoding: quoted-printable

<html><head><title>pg_upgrade</title>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-15=
">
</head>
<body>
<span style=3D" font-family:'Courier New'; font-size: 10pt;">Hello,<br>
<br>
we are still using PostgreSQL 9.0.2 on Windows Server.<br>
<br>
Now we are migrating to Windows Server 2012 R2 and we<br>
would like to migrate PostgreSQL at the same time to&nbsp;<br>
the current version 9.4.4-1<br>
<br>
Which is the best way to migrate the data?<br>
<br>
1. pg_dump on the old server<br>
2. pg_retore on the new server<br>
3. pg_upgrade on the new server<br>
<br>
<br>
Is this correct or is there a "best procedure" to do this?<br>
<br>
<br>
Regards,<br>
Rainer Leo</body>
------------9B18281B1D4B0D--