pg_restore problem

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: Raw Message | Whole Thread | 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.

Responses

Browse pgsql-novice by date

  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