From: | Matthew <matt(at)ctlno(dot)com> |
---|---|
To: | Hackers List <pgsql-hackers(at)postgresql(dot)org> |
Subject: | More Problems |
Date: | 2001-04-06 15:33:19 |
Message-ID: | 183FA749499ED311B6550000F87E206C1FD0C4@srv.ctlno.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
My nightly dump of one of my databases started failing Wednesday night and
I'm not sure what is going on. When I pg_dump this one database (others on
this machine are fine) I get this output from pg_dump
-- last builtin oid is 17216
-- reading user-defined types
-- reading user-defined functions
-- reading user-defined aggregates
-- reading user-defined operators
-- reading user-defined tables
-- finding Triggers for relation: 'jobs'
[snip] ...
-- finding DEFAULT expression for attr: 'id'
-- finding the attrs and types for table: 'testassignments'
-- finding DEFAULT expression for attr: 'id'
-- finding DEFAULT expression for attr: 'standby'
-- finding the attrs and types for table: 'pagedata'
-- finding DEFAULT expression for attr: 'id'
-- flagging inherited attributes in subtables
-- dumping out database comment
-- dumping out user-defined types
-- dumping out tables
-- dumping out user-defined procedural languages
-- dumping out user-defined functions
failed sanity check, type with oid 101993741 was not found
relevant info: pg7.0.2 on redhat 6.1, 700MHz Athlon, 256M, linux software
mirror hard drives.
btw: This is a completely different server at a different location from the
one that was having problems two weeks ago and thank you all for the help
then, I don't think I emailed a thank you, it was a busy day.
From | Date | Subject | |
---|---|---|---|
Next Message | Rod Taylor | 2001-04-06 15:51:57 | Re: Foreign Key & Rule confusion WAS: Lost Trigger(s)? |
Previous Message | Tom Lane | 2001-04-06 15:20:33 | Re: Foreign Key & Rule confusion WAS: Lost Trigger(s)? |