[ADMIN] transfer of database

[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 database 'streamdb' failed. FATAL 1:
Database streamdb does not exist in pg_database"
Thanks!