Postgres terminates on first connecton
| От | Andrus |
|---|---|
| Тема | Postgres terminates on first connecton |
| Дата | |
| Msg-id | dbnk2k$2tga$1@news.hub.org обсуждение |
| Список | 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.
В списке pgsql-general по дате отправления: