I have Postgres 8 on XP
Trying to recover from crash I replaced data subdirectory from backup (no
postgres backup avaliable) and re-started Postgres service.
After trying to connect to it, Postgres service terminates.
How I can recover data from this data directory ?
The following information is in event log:
Event Type: Error
Event Source: PostgreSQL
Event Category: None
Event ID: 0
Date: 21.07.2005
Time: 10:22:32
User: N/A
Computer: ANDRUS
Description:
LOG: invalid primary checkpoint record
Event Type: Error
Event Source: PostgreSQL
Event Category: None
Event ID: 0
Date: 21.07.2005
Time: 10:22:32
User: N/A
Computer: ANDRUS
Description:
LOG: unexpected pageaddr 0/45D24000 in log file 0, segment 82, offset
13778944
Event Type: Error
Event Source: PostgreSQL
Event Category: None
Event ID: 0
Date: 21.07.2005
Time: 10:22:32
User: N/A
Computer: ANDRUS
Description:
LOG: database system was shut down at 2005-07-21 10:22:27 FLE Daylight Time
Andrus.