Re: Please Help... Service fails to start

What exactly file pg_clog/0085 exactly is ? Thank you for any advice.
Now i'm trying to check file permission and antivirus.

On Nov 3, 2009, at 2:48 PM, Sam Jas wrote:

> >> 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.
>
>
> I faced this error before a week only. Fortunately we have a valid
> backup and we restored the file (0085) in pg_clog directory. In our
> case it is the corruption issue. Kindly check with permission and
> also under the /usr/local/pgsql/data/pg_clog directory whether the
> file (0085) is there or not ? If it is not there than try to reload
> it from the backup. At last you can touch 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 <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Subject: Re: [ADMIN] Please Help... Service fails to start
> To: "Hengky Lie" <hengkyliwandouw(at)gmail(dot)com>
> Cc: pgsql-admin(at)postgresql(dot)org
> Date: Tuesday, 3 November, 2009, 3:37 AM
>
> Hengky Lie <hengkyliwandouw(at)gmail(dot)com> 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 as not readable by the postgres user, or (probably
> more likely on Windows) you have some malfunctioning "antivirus"
> software installed.
>
> regards, tom lane
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
> Yahoo! India has a new look. Take a sneak peek.