Re: Problems with missing OIDs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Alexander Lohse <al@xxxxxxxxxxxxx> writes:
>> That really shouldn't have happened in the first place.  Are you  
>> running
>> an up-to-date Postgres version?  Are you sure your disk drives don't  
>> lie
>> about write completion?

> the server is running PostgreSQL 7.4. The disks where replaced by our  
> hosting partners, so I do not know anything about their internal state.

7.4.what?

> The index for a primary key contstraint on that table is missing.
> I also cannot drop and recreate that constraint!
> Can I just go ahead and drop the corresponding rows from pg_contraint  
> and pg_index?

Yeah, what you'll have to do is remove individual rows from the catalogs
until you can get pg_dump to run without error.  Then reload into a
fresh database and check for signs of inconsistency, missing data or
tables, etc.

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux