Skip site navigation (1) Skip section navigation (2)

search for help about PostgreSQL check mechanism

From: "Chen, Dongdong (GE Healthcare)" <DongdongChen(at)ge(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: search for help about PostgreSQL check mechanism
Date: 2009-04-21 05:44:23
Message-ID: 0332CB5EB6327940B291055AAD964221042887A3@SHAMLVEM02.e2k.ad.ge.com (view raw or flat)
Thread:
Lists: pgsql-novice
 
We are now working on database check mechanism in our application. The
situation is when server shutdown abnormally, the postmaster.pid still
exists when reboot, But the PostgreSQL database itself may not be
damaged. We just do not want to restore from backups if the database is
still good. So, is there any way or tool to automatically check the
consistency status of PostgreSQL database when server starts up(like the
DBCC in SQL server)? If the PostgreSQL database records are damaged for
sure, then the restoration should be executed automatically.
 
Thanks for the suggestion.
 
B.R.
 
Kevin Chen

pgsql-novice by date

Next:From: Juan D. L.Date: 2009-04-21 19:08:06
Subject: Re: PostgreSQL not working?
Previous:From: AndrejDate: 2009-04-20 19:53:14
Subject: Re: PostgreSQL not working?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group