Re: [ADMIN] transfer of database

1999-08-10 Thread John M. Flinchbaugh
On Wed, 11 Aug 1999, Darren Chan wrote: > I have 2 servers running PostgreSQL 6.5.1 with different databases. Is > it possible to transfer one of the databases from one machine to > another? > I tried pg_dump streamdb > streamdb.pgdump to backup > and cat streamdb.pgdump | psql streamdb to restore

[ADMIN] transfer of database

1999-08-10 Thread Darren Chan
Hello, I have 2 servers running PostgreSQL 6.5.1 with different databases. Is it possible to transfer one of the databases from one machine to another? I tried pg_dump streamdb > streamdb.pgdump to backup and cat streamdb.pgdump | psql streamdb to restore but got the message "Connection to databas