Re: [GENERAL] pg_dumpall + restore = missing view

2004-11-23 Thread Jim Seymour
"Thomas F.O'Connell" <[EMAIL PROTECTED]> wrote: > > For the record, you shouldn't have needed to do a dump restore between > 7.4.1 and 7.4.6 should you? IIRC, it was 7.4.1 -> 7.4.2 that required either that or some manual fixing-up. Jim ---(end of broadcast)

Re: [GENERAL] pg_dumpall + restore = missing view

2004-11-23 Thread Thomas F.O'Connell
For the record, you shouldn't have needed to do a dump restore between 7.4.1 and 7.4.6 should you? -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 On Nov 19, 2004, at 7:24 PM,

Re: [GENERAL] pg_dumpall + restore = missing view

2004-11-19 Thread Tom Lane
Steve Crawford <[EMAIL PROTECTED]> writes: > 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 >

[GENERAL] pg_dumpall + restore = missing view

2004-11-19 Thread Steve Crawford
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