Dear List,
I need to migrate my database from a 2.x to 3.x. Usually Im using
pg_basebackup , but this is not possible with different versions.
Pg_dump seems to be an option but it is slow like hell and I dont want
to stay offline all the time.
Is there another possibility to migrate a
On 15/04/2015 20:03, Filip Lyncker wrote:
Dear List,
I need to migrate my database from a 2.x to 3.x. Usually Im using
pg_basebackup , but this is not possible with different versions.
Pg_dump seems to be an option but it is slow like hell and I dont want
to stay offline all the time.
Is
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Filip Lyncker
Sent: Wednesday, April 15, 2015 3:03 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Best way to migrate a 200 GB database from PG 2.7 to 3.6
Dear
On 4/15/2015 2:03 PM, Filip Lyncker wrote:
Dear List,
I need to migrate my database from a 2.x to 3.x. Usually Im using
pg_basebackup , but this is not possible with different versions.
Pg_dump seems to be an option but it is slow like hell and I dont want
to stay offline all the time.
Is there
On 04/15/2015 12:14 PM, Andy Colson wrote:
Postgresql is on version 9. What do you mean version 2 or 3?
He probably means 9.2.7 to 9.3.6. Remember to a lot of people 9 means 9.
That said, pg_upgrade is the way to do this as long as you can have an
outage.
JD
--
Command Prompt, Inc. -