Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id C72474769F6
	for <pgsql-novice@postgresql.org>; Fri,  6 Sep 2002 15:07:20 -0400 (EDT)
Received: from smtp014.mail.yahoo.com (smtp014.mail.yahoo.com
 [216.136.173.58])
	by postgresql.org (Postfix) with SMTP id EFD76475EA9
	for <pgsql-novice@postgresql.org>; Fri,  6 Sep 2002 15:07:19 -0400 (EDT)
Received: from unknown (HELO internn80ka8rc) (shakiro2@63.230.25.194 with
	login)
	by smtp.mail.vip.sc5.yahoo.com with SMTP; 6 Sep 2002 19:07:20 -0000
From: "Curtis Mortensen" <shakiro2@yahoo.com>
To: <pgsql-novice@postgresql.org>
Subject: pg_restore error
Date: Fri, 6 Sep 2002 13:08:28 -0600
Message-ID: <CPECIDGAKENJOOCGOHGJIEOACBAA.shakiro2@yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0)
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Importance: Normal
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200209/32
X-Sequence-Number: 4660

I've tried searching the archives for a solution to this, but I was unable
to find it.  So, I hope you'll forgive my newbie question if it's been asked
before.  I'm trying to backup a database on our company's server.  First I
create the backup (pg_dump [databasename] > backup.dump) then I create a new
database [databasename2].  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

I get the same even if I give the absolute path for backup.dump.  I assume
that postgres is looking somewhere else for my file, but being fairly new to
SQL, I don't know where that is or where to find out.  So, any help or hints
you could give me would be appreciated.

Thanks,

Curtis Mortensen