Dear friends,
At last i can solved the problem by running CHKDSK. This program found bad allocation unit on pg_clog folder. After repairing, service can start again.
Thank you for your advice. I really appreciate it.
Regards,
Hengky
On Nov 4, 2009, at 2:14 AM, Scott Marlowe wrote:
On Tue, Nov 3, 2009 at 12:41 AM, Hengky Lie
<hengkyliwandouw@gmail.com> wrote:
What exactly file pg_clog/0085 exactly is ? Thank you for any advice. Now i'm trying to check file permission and antivirus.
pg_clog contains the commit log. Once things in pg_xlog have been committed to disk when the background writer gets around to it. They get marked committed in pg_clog.
Note that often broken antivirus programs will still cause problems if they're simply disabled. The real answer is to uninstall them (and hope they don't leave any broken system dlls behind to still cause problems).
A database server should be so far from things that can give it viruses that anti-virus software should be uneeded.