I think you need to download windows version DD and use it. http://www.chrysocome.net/dd
--- Regards, Raghavendra EnterpriseDB Corporation Blog: http://raghavt.blogspot.com/ On Mon, Jul 16, 2012 at 7:25 PM, raghu ram <raghuchenn...@gmail.com> wrote: > > > On Mon, Jul 16, 2012 at 5:44 PM, Olga Vingurt <olg...@checkpoint.com>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/ > > > >
