Re: pg_restore error - Mailing list pgsql-novice

From Giles Lean
Subject Re: pg_restore error
Date
Msg-id 12768.1031352611@nemeton.com.au
Whole thread Raw
In response to pg_restore error  ("Curtis Mortensen" <shakiro2@yahoo.com>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Giles Lean
Date:
Subject: Re: Unix domain sockets
Next
From: Giles Lean
Date:
Subject: Re: pg_restore error