From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
---|---|
To: | "PostgreSQL" <pgsql-general(at)postgresql(dot)org> |
Subject: | pg_dumpall + restore = missing view |
Date: | 2004-11-19 20:20:14 |
Message-ID: | 200411191220.14538.scrawford@pinpointresearch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
During last night's "maintenance window" (er, unplanned loss of
connectivity due to workers diamond-core-drilling through an OC12 as
part of, I kid you not, installation of a new toilet) I upgraded from
7.4.1 to 7.4.6.
Basic method:
Build 7.4.6
Backup db: pg_dumpall > dumpfile
Install: stop 7.4.1/move datadir/install 7.4.6/copy configs
Start: initdb/start PG
Restore: psql -f dumpfile template1
This appears to have all gone well execpt that one view is missing.
I've restored that view by hand but am curious if this is a PG bug or
failure of the nut behind the wheel.
The view involves the union of many tables and its creation failed
because creation of one of the tables does not take place until later
in the dump file.
Ideas?
Cheers,
Steve
From | Date | Subject | |
---|---|---|---|
Next Message | GreyGeek | 2004-11-19 22:14:52 | Re: PostegreSQL 8.0.0 Beta4 Win32 |
Previous Message | Tom Lane | 2004-11-19 20:06:45 | Re: altre table and large object deletion |