Curtis Mortensen asked:
> When I try to move the dump to the new database
> (pg_restore [databasenam2] < backup.dump) it gives me this error:
>
> pg_restore: [archiver] could not open input file: No such file or directory
To specify the database name to restore to, you want the --dbname option:
$ pg_restore --dbname=databasenam2 < backup.dump
Regards,
Giles