From: | "Jules Alberts" <jules(dot)alberts(at)arbodienst-limburg(dot)nl> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: pg_restore problem |
Date: | 2002-08-14 10:00:38 |
Message-ID: | 200208141004.g7EA48uL012581@artemis.cuci.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 14 Aug 2002 at 11:49, Jules Alberts wrote:
> 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:
BTW in between I do a dropdb mydb
> 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 | Tom Ansley | 2002-08-14 11:38:11 | Linking two tables from different databases |
Previous Message | Jules Alberts | 2002-08-14 09:49:57 | pg_restore problem |