Problem with pg_dump / pg_restore - Mailing list pgsql-admin

From Armel HERVE
Subject Problem with pg_dump / pg_restore
Date
Msg-id CGEBLCNHICNOBNMINIICGEAFCDAA.ah.pgsql@laposte.net
Whole thread Raw
Responses Problem with pg_dump / pg_restore  ("Armel HERVE" <ah.pgsql@laposte.net>)
List pgsql-admin
Hi everybody,
I have a problem with dump / restore commands on PostgreSQL:
pg_dump doesn't care about objects dependencies:
    - I create a view V1 on a table and then another view V2 on the
same table
    - I modify V1 to use V2

pg_dump doesn't detect that V1 is using V2. So the command batch
generated contains in first the creation of the view V1 which uses V2
and then the creation on the view V2 and it's impossible to restore a
database with this generated file.

My question is : how can I use pg_dump / pg_restore to generate a good
backup file ?

Thanks for your answers (and sorry for my poor english!!!)

Armel


pgsql-admin by date:

Previous
From: Gémes Géza
Date:
Subject: Re: What is the advantage
Next
From: William Yu
Date:
Subject: Re: WHAT IS THE ADVANTAGE