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
> but got the message "Connection to database 'streamdb' failed. FATAL 1:
> Database streamdb does not exist in pg_database"
the streamdb does not exist on the second machine. pg_dump doesn't create
databases like pg_dumpall will. so you need to ``createdb streamdb'',
then load the database as you attempted.
____________________}John Flinchbaugh{______________________
| -> [EMAIL PROTECTED] <- [EMAIL PROTECTED] |
| [EMAIL PROTECTED] http://www.hjsoft.com/~glynis/ |
~~Powered by Linux: Reboots are for hardware upgrades only~~
