How to determine - Mailing list pgsql-admin
Had an error message on saying a datafile was missing:
1. How do you determine if you have a healthy postgres database?
2. If you have datafile corruption will the database come up.
3. It seems we have a datafile missing, how can you tell if you have datafile corruption.
4. What do you need to confirm before rebooting?
Thanks
Greg
Greg Thompson
Sr. Database Administrator
Redflex Traffic Systems, Inc.
4402 W. Calle Lejos
Glendale, AZ 85310 USA
Ph: +1 (623) 207-2227
Cell: +1 (623) 221-3728
Fx: +1 (623) 207-2050
Making A Safer World!
| ||
| Gregery Thompson | Senior Database Administrator | Redflex Traffic Systems, Inc. | |
Confidentiality Note: This e-mail, and any attachment to it, is intended only for the use of the individual(s) or entity named on the e-mail, and may contain confidential or proprietary information (including copyrighted materials). If the reader of is not an authorized recipient, you are hereby notified that reading it or further distributing it (other than to the author or the intended recipient) is prohibited and is potentially an infringement of the rights of the sender or intended recipient. If you have received this e-mail in error, please immediately return it to the sender and delete it from your system. Thank you. | ||
| ||
Confidentiality Note: This e-mail, and any attachment to it, is intended only for the use of the individual(s) or entity named on the e-mail, and may contain confidential or proprietary information (including copyrighted materials). If the reader of is not an authorized recipient, you are hereby notified that reading it or further distributing it (other than to the author or the intended recipient) is prohibited and is potentially an infringement of the rights of the sender or intended recipient. If you have received this e-mail in error, please immediately return it to the sender and delete it from your system. Thank you.
Attachment
pgsql-admin by date: