Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 889F5475F5F for ; Fri, 6 Sep 2002 18:50:19 -0400 (EDT) Received: from mta03ps.bigpond.com (mta03ps.bigpond.com [144.135.25.135]) by postgresql.org (Postfix) with ESMTP id E9187475E24 for ; Fri, 6 Sep 2002 18:50:17 -0400 (EDT) Received: from nemeton.com.au ([144.135.25.87]) by mta03ps.bigpond.com (Netscape Messaging Server 4.15 mta03ps May 23 2002 23:53:28) with SMTP id H21GRU00.3EW for ; Sat, 7 Sep 2002 08:50:18 +1000 Received: from 144.139.99.14 ([144.139.99.14]) by psmam07.mailsvc.email.bigpond.com(MailRouter V3.0n 119/20341300); 07 Sep 2002 08:50:14 Received: (qmail 12770 invoked from network); 6 Sep 2002 22:50:11 -0000 Received: from nemeton.com.au (203.8.3.33) by nemeton.com.au with SMTP; 6 Sep 2002 22:50:11 -0000 To: "Curtis Mortensen" Cc: pgsql-novice@postgresql.org Subject: Re: pg_restore error In-Reply-To: Message from "Curtis Mortensen" of "Fri, 06 Sep 2002 13:08:28 CST." Date: Sat, 07 Sep 2002 08:50:11 +1000 Message-ID: <12768.1031352611@nemeton.com.au> From: Giles Lean X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/34 X-Sequence-Number: 4662 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