pg_dumpall + restore = missing view

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

Responses

Browse pgsql-general by date

  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