Re: how do you determine if you have a healthy database
От | Adrian Klaver |
---|---|
Тема | Re: how do you determine if you have a healthy database |
Дата | |
Msg-id | 56C2105C.8040106@aklaver.com обсуждение исходный текст |
Ответ на | how do you determine if you have a healthy database ("Gregery L. Thompson" <gthompson@redflex.com>) |
Список | pgsql-general |
On 02/08/2016 04:28 PM, Gregery L. Thompson wrote: > Two quick questions > > 1.How do you determine if you have a healthy database? I would say start by looking at the database logs. If you are seeing FATAL and PANIC errors something is not happy. A lot of this depends on what you consider healthy? There are conditions within the database, i.e. file corruption and then there are conditions outside of the database, memory issues, lack of space, etc. The two can also be connected, where bad memory or hard drive causes database file corruption. > > 2.It needs to be healthy before rebooting correct? It depends on what is causing the problem. Postgres has a single user mode that can be started to fix some problems. Also if the database issue was that it was resource constrained and you fixed that then the database could be started. > > 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 > > www.redflex.com > > Making A Safer World! > > -- Adrian Klaver adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления: