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 T
On Tue, Nov 3, 2009 at 12:41 AM, Hengky Lie 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 get
--- On Tue, 3/11/09, Tom Lane wrote:
From: Tom Lane
Subject: Re: [ADMIN] Please Help... Service fails to start
To: "Hengky Lie"
Cc: pgsql-admin@postgresql.org
Date: Tuesday, 3 November, 2009, 3:37 AM
Hengky Lie writes:
> 2009-11-02 10:13:35 FATAL: could not access status of tr
uch the file and restart the database. However,
in this case you will be lose your data.
-- Thanks
Sam Jas
--- On Tue, 3/11/09, Tom Lane wrote:
From: Tom Lane
Subject: Re: [ADMIN] Please Help... Service fails to start
To: "Hengky Lie"
Cc: pgsql-admin@postgresql.org
Date: Tuesd
Hengky Lie writes:
> 2009-11-02 10:13:35 FATAL: could not access status of transaction
> 139856778
> 2009-11-02 10:13:35 DETAIL: Could not read from file "pg_clog/0085"
> at offset 98304: Permission denied.
You need to fix that "Permission denied" problem. Either the file
really is marked
Dear Friends,
I really need help for my problem, 7 days ago Postgresql service fails
to start and i have no backup ! (OS: Windows XP Pro). I tried googling
everywhere but didn't find any solution.
I had tried to start the service manually from control panel, it
started for about 5 seconds
