Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: Giles LeanDate: 2002-09-07 02:34:09
Subject: Re: pg_restore error
Previous:From: torres montaes manuel eduardoDate: 2002-09-06 22:22:42
Subject: KDevelop error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group