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

Re: restore backup : erreur

From: Pierre BOIZOT <pierre(dot)boizot(at)gmail(dot)com>
To: PG-Mail-liste <pgsql-fr-generale(at)postgresql(dot)org>
Subject: Re: restore backup : erreur
Date: 2012-05-02 17:03:07
Message-ID: CANxSh5z1Jt5J-MwRCyr_3nkc7Nv0Z-Qzty1SgkMDa_LS1bZsPw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-fr-generale
Merci pour l'info et le lien .

J'ai le même message sur un restore 8.4.11 y a t il des back-port ?
A+

Pierre Boizot

G+ <https://plus.google.com/u/0/107377830070954284209/about>




Le 2 mai 2012 18:59, Thomas Reiss <thomas(dot)reiss(at)sector1(dot)fr> a écrit :

> Bonjour Pierre,
>
> Le langage plpgsql est installé par défaut depuis la 9.0. Vous trouverez
> la configuration à la section E.8.3.7.1. de la release note :
> http://docs.postgresql.fr/9.0/release-9-0.htmlCordialement,
> Thomas
>
> Le 2 mai 2012 à 18:53, Pierre BOIZOT a écrit :
>
> Hello,
>
> suite à un excellent cours chez Dalibo , 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 ???
>
> A+
> Pierre
> Pierre Boizot
>
> G+ <https://plus.google.com/u/0/107377830070954284209/about>
>
>
>
>

In response to

pgsql-fr-generale by date

Next:From: Guillaume LelargeDate: 2012-05-02 17:05:36
Subject: Re: restore backup : erreur
Previous:From: Pierre BOIZOTDate: 2012-05-02 16:53:27
Subject: restore backup : erreur

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