On Mon, Jul 16, 2012 at 5:44 PM, Olga Vingurt <[email protected]> wrote:
> Hi,**** > > ** ** > > We are using PostgreSQL 8.3 on Windows Server. **** > > The db crashed and now it fails to start up.**** > > ** ** > > The error is:**** > > FATAL: could not access status of transaction 4020264**** > > DETAIL: Could not read from file "pg_clog/0003" at offset 212992: No > error.**** > > ** ** > > Additional log from event viewer:**** > > LOG: database system was interrupted; last known up at 2012-07-12 > 11:35:00 CEST**** > > ** ** > > ** ** > > How can we recover from the current state? **** > > ** ** > > > Please perform below steps: 1. Backup the current pg_clog/0003 file in different directory 2. Create a file by assumption of make the uncommitted record as they haven't been committed. command as follows: *dd if=/dev/zero of=<data directory location>/pg_clog/0003 bs=256K count=1 * 3. Start the Cluster -- Thanks & Regards, Raghu Ram EnterpriseDB Corporation Blog:http://raghurc.blogspot.in/
