| From: | "Scott Marlowe" <smarlowe(at)qwest(dot)net> |
|---|---|
| To: | "Sandro Dentella" <sandro(at)e-den(dot)it> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: pg_clog error after crash |
| Date: | 2004-07-01 22:14:09 |
| Message-ID: | 1088720049.14882.12.camel@localhost.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, 2004-06-30 at 09:59, Sandro Dentella wrote:
> After a crash of the (frozen) system, postgreSQL issues a message:
>
> 2004-06-30 17:51:39 [3165] LOG: connection authorized: user=sandro database=sia
> 2004-06-30 17:51:39 [3165] ERROR: could not access status of transaction 4011600129
> DETAIL: could not open file "/var/lib/postgres/data/pg_clog/0EF1": No such file or directory
>
>
> when trying to acces a db.
>
> I'm really clueless as I didn't find anything usefull with google to fix
> it. The db is very little, and I'm the only one that writes on it, so I know
> there shouldn't be real problems ignoring the transaction, but I don't know
> what to say postgreSQL to ingore it.
>
> Should I recreate an empty file?
What version are you running?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bender, Cheryl | 2004-07-01 23:27:13 | Re: PL/pgsql |
| Previous Message | Tom Lane | 2004-07-01 22:05:17 | Re: pg_clog error after crash |