Re: R: How to move a DB from one server to another...

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