agora inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedFrom: Ziggy Skalski <zskalski@afilias.info>
To: pgsql-admin@postgresql.org
Subject: Re: pg_upgrade
Date: Mon, 22 Jun 2015 12:44:09 +0200
Message-ID: <5587E6F9.50702@afilias.info> (raw)
In-Reply-To: <e84cbc3cee08d8569cd670860c2b1900@imap.lan.net>
References: <1862034146.20150622111438@workfile.de>
<e84cbc3cee08d8569cd670860c2b1900@imap.lan.net>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
view thread (13+ messages) latest in thread
Message-ID: <5587E6F9.50702@afilias.info>
Permalink: ../5587E6F9.50702@afilias.info/
Also on: postgresql.org/message-id/5587E6F9.50702@afilias.info
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: zskalski@afilias.info
Subject: Re: pg_upgrade
In-Reply-To: <5587E6F9.50702@afilias.info>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox