Federico,
Of course we could use SQL (CREATE DATABASE, CREATE TABLE, INSERT INTO....)
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?
Harald
--
GHUM Harald Massa
persuasion python postgresql
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607