agora inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedFrom: Rainer Leo <leo@workfile.de>
To: pgsql-admin@postgresql.org
Subject: pg_upgrade
Date: Mon, 22 Jun 2015 11:14:38 +0200
Message-ID: <1862034146.20150622111438@workfile.de> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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?
Regards,
Rainer Leo
view thread (13+ messages) latest in thread
Message-ID: <1862034146.20150622111438@workfile.de>
Permalink: ../1862034146.20150622111438@workfile.de/
Also on: postgresql.org/message-id/1862034146.20150622111438@workfile.de
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: leo@workfile.de
Subject: Re: pg_upgrade
In-Reply-To: <1862034146.20150622111438@workfile.de>
* 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