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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
