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 569B13A5EE3 for ; Mon, 6 Dec 2004 13:17: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 22312-07 for ; Mon, 6 Dec 2004 13:17:00 +0000 (GMT) Received: from out012.verizon.net (out012pub.verizon.net [206.46.170.137]) by svr1.postgresql.org (Postfix) with ESMTP id 844703A5E84 for ; Mon, 6 Dec 2004 13:17:02 +0000 (GMT) Received: from RavChaim.rishonim.com ([68.237.238.85]) by out012.verizon.net (InterMail vM.5.01.06.06 201-253-122-130-106-20030910) with ESMTP id <20041206131702.WZNW25255.out012.verizon.net@RavChaim.rishonim.com> for ; Mon, 6 Dec 2004 07:17:02 -0600 From: "mlaks@verizon.net" To: pgsql-admin@postgresql.org Subject: pg_dump DATABASE > database.dump -> psql X-Authentication-Info: Submitted using SMTP AUTH at out012.verizon.net from [68.237.238.85] at Mon, 6 Dec 2004 07:17:02 -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/47 X-Sequence-Number: 15633 Hi! 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