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 E50AB3A3D0D for ; Mon, 8 Nov 2004 10:06:22 +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 05829-10 for ; Mon, 8 Nov 2004 10:06:15 +0000 (GMT) Received: from gw.fs-cfc.co.uk (gw.fs-cfc.co.uk [193.203.83.22]) by svr1.postgresql.org (Postfix) with SMTP id 8FBC53A3CEA for ; Mon, 8 Nov 2004 10:06:14 +0000 (GMT) Received: (qmail 12692 invoked by uid 0); 8 Nov 2004 10:06:11 -0000 Received: from dilipan.sebastiampillai@framestore-cfc.com by proxy by uid 502 with qmail-scanner-1.14 ( Clear:. Processed in 0.022382 secs); 08 Nov 2004 10:06:11 -0000 Received: from unknown (HELO mail.admin.local) (192.168.2.15) by 0 with SMTP; 8 Nov 2004 10:06:11 -0000 Received: from localhost (localhost [127.0.0.1]) by mail.admin.local (Postfix) with ESMTP id 3C7B556AF50; Mon, 8 Nov 2004 10:04:51 +0000 (GMT) Received: from [172.18.10.132] (sys132.prod.local [172.18.10.132]) by mail.admin.local (Postfix) with ESMTP id 00BDCABA006; Mon, 8 Nov 2004 10:04:49 +0000 (GMT) Message-ID: <418F44C0.1060300@framestore-cfc.com> Date: Mon, 08 Nov 2004 10:04:48 +0000 From: Dilipan Sebastiampillai User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7) Gecko/20040618 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Allen Smith Cc: pgsql-admin@postgresql.org Subject: Re: Help with restore References: <418AE5E6.4020309@midsouth.rr.com> In-Reply-To: <418AE5E6.4020309@midsouth.rr.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/59 X-Sequence-Number: 15444 > 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 > > however after looking back over my notes and the documentation that I > recieved I noticed that I was supposed to make the backup like this: > pg_dump -U dbname -v -Fc -f bkp.tar.gz dbname > I had the same problem. One way is to use as template the table template0 with the following command : createdb yourdatabasename -T template0 and then pg_restore .... it works if you didn't make anychanges to your template1 table. hope it helps Dilipan > Sincec this is apearantly a specific way to make the backup Im > assuming that that is why the restore doesnt work since it was setup > do restore form that specific backup syntax. What I would like to know > is, how I can get the data out of this archive, so that I can recover > the data and put it back in place and get the site up and running. > > any suggestions????? > > Thanks in Advance > > Allen Smith > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)