| From: | "Jules Alberts" <jules(dot)alberts(at)arbodienst-limburg(dot)nl> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | pg_restore problem |
| Date: | 2002-08-14 09:49:57 |
| Message-ID: | 200208140954.g7E9s4uL012392@artemis.cuci.nl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hello world,
(PostgreSQL 7.2.1-5, fully patched RedHat 7.3)
I have a db with some relations on OIDs and some BLOBs. I create a
backup with this command:
pg_dump -Fc -o -b mydb > mydb.dump
But a restore with:
pg_restore -dmydb -Fc mydb.dump
Gives this error:
CREATE DATABASE
pg_restore: connecting to database for restore
pg_restore: executing <Init> Max OID
pg_restore: creating FUNCTION "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
Am I doing something wrong? TIA!
--
Jules Alberts.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jules Alberts | 2002-08-14 10:00:38 | Re: pg_restore problem |
| Previous Message | paul butler | 2002-08-14 06:47:29 | disappearing tables |