On Mon, Aug 21, 2006 at 06:40:22AM -0700, Paul Silveira wrote:
> Yes the needs are simple.  I was also thinking about using DBI.  The most
> important thing to me is that everything is kept in a transaction so that
> users can still read the data while I'm snapshotting it at the same time. 
> If my transaction is isolated from all the reads happening, then it
> shouldn't matter how long it takes for me to move the data over (granted,
> that will increase latency, but in this project that's not really too
> sensitive) and it will be transparent to the end users.  

Looks to me like the -c option to pg_dump should do what you want.


Have a nice day,
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to 
> litigate.

Attachment: signature.asc
Description: Digital signature

Reply via email to