> Of course we could use SQL (CREATE DATABASE, CREATE TABLE, INSERT
> but this would take years on large databases, while a rough "copy this
> folder to the new server" would take just a few seconds.
I do copys of databases every other day. pg_dump and pg_restore work like a
breeze on databases with around 1 gig of stuff, and I do not even use the
binary format and use intermediate files.
Where ist the performance bottleneck you are speaking of?
GHUM Harald Massa
persuasion python postgresql
Harald Armin Massa
In response to
pgsql-hackers-win32 by date
|Next:||From: Andrew Dunstan||Date: 2005-06-23 11:47:18|
|Subject: Re: How to move a DB from one server to another...|
|Previous:||From: John A Meinel||Date: 2005-06-23 06:35:56|
|Subject: Re: R: How to move a DB from one server to|