## Ron (ronljohnsonjr(at)gmail(dot)com):
> > pg_dump -h host1 dbname | psql -h host2 dbname
>
> But that assumes --format=plain which will send a whole lot of
> uncompressed text across the wire.
You can also use pg_restore with standard input, i.e. pg_dump | pg_restore.
Regards,
Christoph
--
Spare Space.