PostgreSQL won't start
| От | Laura Horsky |
|---|---|
| Тема | PostgreSQL won't start |
| Дата | |
| Msg-id | CAKH15QBN6V3fDq0KkTjbeBG9Xjm84NaBXm9_NutF8tr4jMV0gg@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: PostgreSQL won't start
|
| Список | pgsql-admin |
I have a PostgreSQL server that was restarted. When it was brought back online, PostgreSQL fails to start with:
....LOG: database system was interrupted; last known up at ....
....LOG: unexpected pageaddr 2F/8D000000 in log file 47, segment 159, offset 0
....LOG: invalid primary checkpoint record
....LOG: invalid secondary checkpoint record
....PANIC: could not locate a valid checkpoint record
....LOG: startup process (PID 20879) was terminated by signal 6: Aborted....LOG: aborting startup due to startup process failure
I have pg_dumps that were taken prior to failure that I can restore to if I can get PostgreSQL running again.
How can I fix PostgreSQL? I have seen pg_resetxlog but there are so many warnings, I want to make sure that this is the tool to use.
Thanks.
Laura
В списке pgsql-admin по дате отправления: