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 B05E33A45E9 for ; Wed, 3 Nov 2004 19:40:40 +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 65316-06 for ; Wed, 3 Nov 2004 19:40:38 +0000 (GMT) Received: from ms-smtp-02-eri0.ohiordc.rr.com (ms-smtp-02-smtplb.ohiordc.rr.com [65.24.5.136]) by svr1.postgresql.org (Postfix) with ESMTP id 31F953A4583 for ; Wed, 3 Nov 2004 19:40:37 +0000 (GMT) Received: from [24.165.161.59] (cpe-024-165-161-059.midsouth.rr.com [24.165.161.59]) by ms-smtp-02-eri0.ohiordc.rr.com (8.12.10/8.12.7) with ESMTP id iA3JeXJl007186 for ; Wed, 3 Nov 2004 14:40:35 -0500 (EST) Message-ID: <418933EB.7060806@midsouth.rr.com> Date: Wed, 03 Nov 2004 13:39:23 -0600 From: Allen Smith User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Help need to restore dropped db Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Symantec AntiVirus Scan Engine X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.9 tagged_above=0.0 required=5.0 tests=FROM_ENDS_IN_NUMS X-Spam-Level: X-Archive-Number: 200411/53 X-Sequence-Number: 15438 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./