Technique - général | Erreur de restauration avec pg_restore

Par selenium le 28/04/2006 - 14:01

bonjour,

j'ai posé la question sur la mailing list officielle pg-admin, mais en l'abscence de reponse satifaisante je me permet de reposter ici !
Le thread est ici : http://archives.postgresql.org/pgsql-admin/2006-04/msg00299.php

Hi,

I am having troubles using pg_restore : none of my indexes are restored !
It did not see any relevant message in the pg_restore output to explain this behaviour.

So I am trying to restore a pg_dump ( version8.1 ) sql dump file from a remote 8.0.3 DB into a local 8.1 DB using pg_restore (version 8.1).
Is there something incompatible ?
The dump file seems to be correct regarding index creation statements... I really don't understand what is happening.

As the title mentions, I have the same issue with triggers : none of my triggers are restored neither ! Is there any option in pg_dump or pg_restore to handle this ?

(c'est en anglais desolé!)
Merci d'avance et bonne journée à tous