Postgres terminates on first connecton

From: "Andrus" <eetasoft(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres terminates on first connecton
Date: 2005-07-21 07:37:43
Message-ID: dbnk2k$2tga$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Browse pgsql-general by date

  From Date Subject
Next Message vinita bansal 2005-07-21 07:43:06 Re: RAMFS with Postgres
Previous Message Magnus Hagander 2005-07-21 07:36:00 Re: Cannot start DB system