pg_dumpall - Mailing list pgsql-sql

From Oleg Lebedev
Subject pg_dumpall
Date
Msg-id 3CE02FF5.ABDC8CC@waterford.org
Whole thread Raw
List pgsql-sql
Hello,
I am upgrading from Postgres7.1.3 to Postgres7.2.1 and dumped all the
data to a file with
pg_dumpall -o > dump
When I go throught the dump file it turns out that some views are
created before the base relations are created. When I try to import the
dump file in Postgres 7.2.1 some of the views are not created because if
this.
Why the order of created data objects is wrong?
I kept view definitions in several files, but I would still like to know
how to move data between releases consistently.
thanks,

Oleg



pgsql-sql by date:

Previous
From: Edipo Elder Fernandes de Melo
Date:
Subject: timestamp and datestyles
Next
From: Marc SCHAEFER
Date:
Subject: Various PostgreSQL questions