From: Iain <iain@mst.co.jp>
To: Allen Smith <asmith86@midsouth.rr.com>
To: pgsql-admin@postgresql.org
Subject: Re: Help need to restore dropped db
Date: Mon, 8 Nov 2004 11:04:47 +0900
Message-ID: <013f01c4c537$55bbca20$7201a8c0@mst1x5r347kymb> (raw)
References: <418933EB.7060806@midsouth.rr.com>
That should be easy,
use -T template1 when you create the empty DB.
ie:
createdb -T template0 <dbname>
regards
Iain
----- Original Message -----
From: "Allen Smith" <asmith86@midsouth.rr.com>
To: <pgsql-admin@postgresql.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: iain@mst.co.jp, asmith86@midsouth.rr.com
Subject: Re: Help need to restore dropped db
In-Reply-To: <013f01c4c537$55bbca20$7201a8c0@mst1x5r347kymb>
References: <418933EB.7060806@midsouth.rr.com> <013f01c4c537$55bbca20$7201a8c0@mst1x5r347kymb>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox