Re: Point-In-Time Recovery not working

From: gais <gais(at)alpenjodel(dot)de>
To:
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Point-In-Time Recovery not working
Date: 2011-08-26 22:12:15
Message-ID: 4E581A3F.2020705@alpenjodel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I've tried to follow the directions as closely as possible, but still
the server won't start. I do get a different PANIC:

2011-08-26 23:55:08 CEST LOG: database system was shut down at
2011-08-26 22:08:35 CEST
2011-08-26 23:55:08 CEST LOG: starting archive recovery
2011-08-26 23:55:08 CEST LOG: restore_command = 'cp
/var/lib/postgresql/8.3/main/archive/%f %p'
cp: cannot stat `/var/lib/postgresql/8.3/main/archive/00000001.history':
No such file or directory
2011-08-26 23:55:08 CEST LOG: restored log file
"0000000100000001000000EE" from archive
2011-08-26 23:55:08 CEST LOG: unexpected pageaddr 1/EB01C000 in log
file 1, segment 238, offset 114688
2011-08-26 23:55:08 CEST LOG: invalid primary checkpoint record
2011-08-26 23:55:08 CEST LOG: restored log file
"0000000100000001000000EE" from archive
2011-08-26 23:55:08 CEST LOG: invalid xl_info in secondary checkpoint
record
2011-08-26 23:55:08 CEST PANIC: could not locate a valid checkpoint record
2011-08-26 23:55:08 CEST LOG: startup process (PID 8975) was terminated
by signal 6: Aborted
2011-08-26 23:55:08 CEST LOG: aborting startup due to startup process
failure

Somehow I think the database files I used to restore are inconsistent
with the WAL's. Is there a workaround or am I still doing something
completely foolish?

> Not based very closely on the documentation. Please read the
> "Recovering using a Continuous Archive Backup" subsection closely
> and follow the directions there. In particular, initdb is not run
> as part of the recovery. If you follow the directions step by step,
> you should get farther. If you still have problems, feel free to
> post again.
>
> -Kevin

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message gais 2011-08-26 23:27:40 Re: Point-In-Time Recovery not working
Previous Message Kevin Grittner 2011-08-26 16:50:27 Re: Point-In-Time Recovery not working