X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4DA103A5E9C for ; Mon, 6 Dec 2004 06:13:09 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 02970-09 for ; Mon, 6 Dec 2004 06:13:04 +0000 (GMT) Received: from out005.verizon.net (out005pub.verizon.net [206.46.170.143]) by svr1.postgresql.org (Postfix) with ESMTP id 778013A5EBB for ; Mon, 6 Dec 2004 06:12:28 +0000 (GMT) Received: from RavChaim.rishonim.com ([68.237.238.85]) by out005.verizon.net (InterMail vM.5.01.06.06 201-253-122-130-106-20030910) with ESMTP id <20041206061217.JXAX22017.out005.verizon.net@RavChaim.rishonim.com> for ; Mon, 6 Dec 2004 00:12:17 -0600 From: "mlaks@verizon.net" To: pgsql-admin@postgresql.org Subject: psql instead of pg_restore Date: Mon, 6 Dec 2004 01:13:28 -0500 User-Agent: KMail/1.7 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200412060113.28639.mlaks@verizon.net> X-Authentication-Info: Submitted using SMTP AUTH at out005.verizon.net from [68.237.238.85] at Mon, 6 Dec 2004 00:12:17 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.8 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, FORGED_RCVD_HELO X-Spam-Level: * X-Archive-Number: 200412/48 X-Sequence-Number: 15634 I just suffered a hard drive failure and restored a database that had been saved via pg_dump DATABASE >DATABASE.dump. However, instead of doing pg_restore (which I completely forgot about :( ) , I did: createdb DATABASE then I did psql DATABASE