| From: | Jeff Baldwin <tarheeljeff(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Migrate 2 DB's - v8.3 |
| Date: | 2016-05-27 20:56:46 |
| Message-ID: | CABk2_VnxEATLmKW2Z6u=ChtYZAhxFtBMS_iNCj9D9i+TaYi8=Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Melvin Davidson | 2016-05-27 21:05:11 | Re: Migrate 2 DB's - v8.3 |
| Previous Message | Thomas Kellerer | 2016-05-27 14:23:46 | Re: 9.6beta, parallel execution and cpu_tuple_cost |