| 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: | Whole Thread | Raw Message | 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.
| 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 |