Skip site navigation (1) Skip section navigation (2)

Re: pg_restore problem

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 (view raw or flat)
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.

In response to

Responses

pgsql-novice by date

Next:From: Tom AnsleyDate: 2002-08-14 11:38:11
Subject: Linking two tables from different databases
Previous:From: Jules AlbertsDate: 2002-08-14 09:49:57
Subject: pg_restore problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group