| From: | Pierre BOIZOT <pierre(dot)boizot(at)gmail(dot)com> |
|---|---|
| To: | PG-Mail-liste <pgsql-fr-generale(at)postgresql(dot)org> |
| Subject: | restore backup : erreur |
| Date: | 2012-05-02 16:53:27 |
| Message-ID: | CANxSh5zPY_KkYeFEGTKv-oJ8wD1Yy8Tt8HP1Gn=MV7Ss--5ftg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-fr-generale |
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>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pierre BOIZOT | 2012-05-02 17:03:07 | Re: restore backup : erreur |
| Previous Message | Pierre BOIZOT | 2012-05-02 14:50:32 | Connexion sans PWD |