| From: | Laura Horsky <lhorsky(at)gwoslabs(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | PostgreSQL won't start |
| Date: | 2015-09-09 14:13:29 |
| Message-ID: | CAKH15QBN6V3fDq0KkTjbeBG9Xjm84NaBXm9_NutF8tr4jMV0gg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Scalia | 2015-09-10 19:53:40 | Cannot get extensions to load |
| Previous Message | Armand Pirvu (home) | 2015-09-09 02:23:46 | Re: counting transactions |