Thread: Best way to migrate a 200 GB database from PG 2.7 to 3.6
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 database with 200 GB ? Thanks a lot, cheers Filip
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 there another possibility to migrate a database with 200 GB ? Those version numbers aren't correct... current PG major versions run from 9.0 to 9.4. I don't think there was ever any version less than 6 (though I could be wrong). Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie
-----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@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 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 differentversions. 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 database with 200 GB ? Thanks a lot, cheers Filip --- PG 2.7 to 3.6??? Anyway, did you look at pg_upgrade? Regards, Igor Neyman
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 another possibility to migrate a database with 200 GB ? > > Thanks a lot, > > cheers > > Filip > > Postgresql is on version 9. What do you mean version 2 or 3? Maybe use replication? http://www.slony.info/documentation/1.2/versionupgrade.html Or something similar? -Andy
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. - http://www.commandprompt.com/ 503-667-4564 PostgreSQL Centered full stack support, consulting and development. Announcing "I'm offended" is basically telling the world you can't control your own emotions, so everyone else should do it for you.