Migrating a live database - Mailing list pgsql-admin

From Vladislav Geller
Subject Migrating a live database
Date
Msg-id 58123383-B024-48E8-B863-651E455A3861@vincorex.ch
Whole thread Raw
Responses Re: Migrating a live database  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: Migrating a live database  (Vladimir Rusinov <vladimir@greenmice.info>)
List pgsql-admin
Hello,

I'm currently in the process of migrating a huge live database from one part of the world to the other (for local use
anddata analysis). The bandwidth does not allow me to get a decent transfer speed. Furthermore i can not migrate during
businesshours since the connection is critical. This leaves me with a timeframe of 9 hours a day where i can migrate
thisdatabase. Does anyone have experience he is willing to share in respect how to migrate such databases?  

Regards,
Vladislav Geller

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: ssl client cert authentication
Next
From: "Gnanakumar"
Date:
Subject: How do I stop/disable PITR and safely clean WAL segments?