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 E64C83A3CFC for ; Mon, 8 Nov 2004 02:04:24 +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 72301-05 for ; Mon, 8 Nov 2004 02:04:12 +0000 (GMT) Received: from millenium.mst.co.jp (unknown [210.230.185.241]) by svr1.postgresql.org (Postfix) with ESMTP id ED2313A2B4A for ; Mon, 8 Nov 2004 02:04:13 +0000 (GMT) Received: from mst1x5r347kymb (lc12114 [192.168.1.114]) by millenium.mst.co.jp (8.11.6p2/3.7W) with SMTP id iA8243Z15045; Mon, 8 Nov 2004 11:04:03 +0900 Message-ID: <013f01c4c537$55bbca20$7201a8c0@mst1x5r347kymb> From: "Iain" To: "Allen Smith" , References: <418933EB.7060806@midsouth.rr.com> Subject: Re: Help need to restore dropped db Date: Mon, 8 Nov 2004 11:04:47 +0900 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=MAILTO_TO_SPAM_ADDR X-Spam-Level: * X-Archive-Number: 200411/54 X-Sequence-Number: 15439 That should be easy, use -T template1 when you create the empty DB. ie: createdb -T template0 regards Iain ----- Original Message ----- From: "Allen Smith" To: Sent: Thursday, November 04, 2004 4:39 AM Subject: [ADMIN] Help need to restore dropped db >I am having a little issue. I did a dropdb. I had archived like this: > pg_dump -v -Fc -f vs-bkp.tar.gz vs > > the when I tried to restor after recreating the db with: > pg_restore -v -O -d vs vs-bkp.tar.gz > it returns > pg_restore: connecting to database for restore > Password: > after I enter the password I get > pg_restore: creating FUNC PROCEDURAL LANGUAGE plpgsql_call_handler() > pg_restore: [archiver (db)] could not execute query: ERROR: function > "plpgsql_call_handler" already exists with same argument types > pg_restore: *** aborted because of error > > any suggestions????? > > > Allen Smith > /Everyone is a genius. It's just that some people are too stupid to > realize it./ > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org