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

Re: restore backup : erreur

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: pierre(at)boizot(dot)name
Cc: PG-Mail-liste <pgsql-fr-generale(at)postgresql(dot)org>
Subject: Re: restore backup : erreur
Date: 2012-05-02 17:05:36
Message-ID: 1335978336.2377.2.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-fr-generale
Bonjour,

On Wed, 2012-05-02 at 18:53 +0200, Pierre BOIZOT wrote:
> Hello,
> 
> suite à un excellent cours chez Dalibo

Merci :)

>  , je fais des tests de backup
> restore .(pg_dump--pg_restore)
> 
> export 8.4 -- import 9.1.3
> 
> j'obtiens ce message:
> postgres(at)ubuntu:/u00/app/postgresql/admin/prod913/dump$ pg_restore -d cave
> -U caviste cave.tar
> Password:
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error from TOC entry 484; 2612 16386 PROCEDURAL
> LANGUAGE plpgsql postgres
> pg_restore: [archiver (db)] could not execute query: ERROR:  language
> "plpgsql" already exists
>     Command was: CREATE PROCEDURAL LANGUAGE plpgsql;
> 
> pg_restore: WARNING:  no privileges could be revoked for "public"
> pg_restore: WARNING:  no privileges could be revoked for "public"
> pg_restore: WARNING:  no privileges were granted for "public"
> pg_restore: WARNING:  no privileges were granted for "public"
> WARNING: errors ignored on restore: 1
> 
> Comme si le language avait déja été chargé. hors je n'ai pas chargé  aprés
> le creatdb ???
> 

La création de la nouvelle base s'est en fait en copiant la base
template1. En 9.1, la base template1 dispose dès le départ du langage
PL/pgsql. Donc ce message d'erreur est "normal". (plus exactement, il
est compréhensible et peut être ignoré, surtout qu'il ne génère pas
d'erreur dans le reste de la restauration)

Cordialement.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com


In response to

Responses

pgsql-fr-generale by date

Next:From: Pierre BOIZOTDate: 2012-05-02 17:12:02
Subject: Re: restore backup : erreur
Previous:From: Pierre BOIZOTDate: 2012-05-02 17:03:07
Subject: Re: restore backup : erreur

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