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 [EMAIL PROTECTED])
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
