Re: Problem with pg_dump / pg_restore - Mailing list pgsql-admin

From Armel HERVE
Subject Re: Problem with pg_dump / pg_restore
Date
Msg-id CGEBLCNHICNOBNMINIICGEDMCDAA.ah.pgsql@laposte.net
Whole thread Raw
In response to Re: Problem with pg_dump / pg_restore  ("Mark Carew" <markcarew@magicwanddept.com.au>)
List pgsql-admin
Hi Mark,

in fact, the problem is in the structure backup: this command doesn't care
about views dependencies. It take views in creation order to put its in
the .sql. So I have to reorder manually this view creations.
I made a view (another...) to look for dependencies. Maybe it's the good
way.

This view give, for each view oid, the dependencies:
SELECT dep.objid,
     (SELECT pg_rewrite.ev_class
        FROM pg_rewrite
        WHERE (pg_rewrite.oid = dep.objid )) AS trueoid,
       dep.refobjid
FROM pg_depend dep, pg_rewrite rew, pg_class "class"
WHERE dep.objid >= 30000
  AND rew.oid = dep.objid
  AND dep.refobjid = "class".oid
  AND "class".relkind = 'v'
  AND rew.ev_class <> dep.refobjid;


Armel


-----Message d'origine-----
De : pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]De la part de Mark Carew
Envoyé : lundi 1 décembre 2003 10:00
À : pgsql-admin@postgresql.org
Objet : Re: [ADMIN] Problem with pg_dump / pg_restore



Hi Armel,

    Why not do a structure only dump to plain text and see if you can use
that as your start .sql ext file for 'psql -e .. etc'. Eliminates the
necessity to have an active client side data dictionary. BTW, your english
is fine.

Regards
markcarew@
magicwanddept.com.au



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


pgsql-admin by date:

Previous
From: "Mark Carew"
Date:
Subject: Re: Problem with pg_dump / pg_restore
Next
From: Dominique Fenenr
Date:
Subject: db-recovery after update 7.1 -> 7.4 failed