Postgres terminates on first connecton

Started by Andrusover 20 years ago1 messagesgeneral
Jump to latest
#1Andrus
eetasoft@online.ee

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.