Skip site navigation (1) Skip section navigation (2)

Re: Help need to restore dropped db

From: "Iain" <iain(at)mst(dot)co(dot)jp>
To: "Allen Smith" <asmith86(at)midsouth(dot)rr(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: Help need to restore dropped db
Date: 2004-11-08 02:04:47
Message-ID: 013f01c4c537$55bbca20$7201a8c0@mst1x5r347kymb (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
That should be easy,

use -T template1 when you create the empty DB.


createdb -T template0 <dbname>

----- Original Message ----- 
From: "Allen Smith" <asmith86(at)midsouth(dot)rr(dot)com>
To: <pgsql-admin(at)postgresql(dot)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?

In response to

pgsql-admin by date

Next:From: AmazanderDate: 2004-11-08 05:25:27
Subject: Delete Row Containing Blob
Previous:From: Scott MarloweDate: 2004-11-06 23:00:15
Subject: Re: [PERFORM] poor performance in migrated database

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group