Re: How to determine

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

 



Gregery L. Thompson wrote:
> Had an error message on saying a datafile was missing:
> 
> 1.       How do you determine if you have a healthy postgres database?

pg_dumpall the cluster and see if you get errors.
That won't find all data corruption (e.g. a broken index),
but it is a good starting point.
Besides, if it succeeds, you have a backup in case the data corruption
eats your data.

> 2.       If you have datafile corruption will the database come up.

Yes, in most cases.

> 3.       It seems we have a datafile missing, how can you tell if you have datafile corruption.

See 1)
If you know the name of the missing datafile, you can query for
the "relfilenode" column of the "pg_class" table to find out which table
it belongs to.

> 4.       What do you need to confirm before rebooting?

I do not understand this question.
If you have data corruption, a reboot will probably not help.

Yours,
Laurenz Albe

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin




[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