Postgres Pro
Downloads
Home   >   mailing lists

Re: Migrate 2 DB's - v8.3 - Mailing list pgsql-general

From Melvin Davidson
Subject Re: Migrate 2 DB's - v8.3
Date
Msg-id CANu8FizWZSars9wjbHyek4-qjBAp+H65+ni3T9kE71EfU6cmhw@mail.gmail.com
Whole thread Raw
In response to Migrate 2 DB's - v8.3  (Jeff Baldwin <tarheeljeff@gmail.com>)
Responses Re: Migrate 2 DB's - v8.3  (Jeff Baldwin <tarheeljeff@gmail.com>)
List pgsql-general
Tree view


On Fri, May 27, 2016 at 4:56 PM, Jeff Baldwin <tarheeljeff@gmail.com> wrote:
Hello,

I am working to migrate 2 DB's (not the entire postgres instance), from 1 host to another... and I need some guidance on the best approach/practice.

I have migrated ~25 other DB's in this environment, and I was able to use pg_dump/pgrestore for those, and it worked fine.  These final 2 are live DB's, and I need to move them with minimal downtime (1-2hrs is acceptable).

The DB's are blob DB's that are 45 and 90G in size, and are in the same Data Center, with 1G connection in between

I am running postres 8.3 (I know :) ), so there may be some limitations there as well.   

Any help/guidance on the best way to approach this, are greatly appreciated.

Kind Regards,
Jeff

Well generically speaking, since you are migrating from 8.3, you are limited to pg_dump in plain format.
It would be nice (important) to know the PostgreSQL version you are migrating to, as well as what O/S you are working with.

--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

pgsql-general by date:

Previous
From: Jeff Baldwin
Date:
Subject: Migrate 2 DB's - v8.3
Next
From: Jeff Baldwin
Date:
Subject: Re: Migrate 2 DB's - v8.3