Re: pg_restore error

From: Giles Lean <giles(at)nemeton(dot)com(dot)au>
To: "Curtis Mortensen" <shakiro2(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: pg_restore error
Date: 2002-09-06 22:50:11
Message-ID: 12768.1031352611@nemeton.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-novice by date

  From Date Subject
Next Message Giles Lean 2002-09-07 02:34:09 Re: pg_restore error
Previous Message torres montaes manuel eduardo 2002-09-06 22:22:42 KDevelop error