pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Help need to restore dropped  db
2+ messages / 2 participants
[nested] [flat]

* Help need to restore dropped  db
@ 2004-11-03 19:39 Allen Smith <asmith86@midsouth.rr.com>
  2004-11-08 02:04 ` Re: Help need to restore dropped  db Iain <iain@mst.co.jp>
  0 siblings, 1 reply; 2+ messages in thread

From: Allen Smith @ 2004-11-03 19:39 UTC (permalink / raw)
  To: pgsql-admin

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./



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Help need to restore dropped  db
  2004-11-03 19:39 Help need to restore dropped  db Allen Smith <asmith86@midsouth.rr.com>
@ 2004-11-08 02:04 ` Iain <iain@mst.co.jp>
  0 siblings, 0 replies; 2+ messages in thread

From: Iain @ 2004-11-08 02:04 UTC (permalink / raw)
  To: Allen Smith <asmith86@midsouth.rr.com>; pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-11-08 02:04 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-11-03 19:39 Help need to restore dropped  db Allen Smith <asmith86@midsouth.rr.com>
2004-11-08 02:04 ` Iain <iain@mst.co.jp>

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