pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHot standby hangs when restoring WAL files
2+ messages / 1 participants
[nested] [flat]
* Hot standby hangs when restoring WAL files
@ 2014-02-11 09:47 Jürgen Fuchsberger <juergen.fuchsberger@uni-graz.at>
2014-02-11 09:56 ` Re: Hot standby hangs when restoring WAL files Jürgen Fuchsberger <juergen.fuchsberger@uni-graz.at>
0 siblings, 1 reply; 2+ messages in thread
From: Jürgen Fuchsberger @ 2014-02-11 09:47 UTC (permalink / raw)
To: pgsql-admin
Hi,
After my Master server hanged I have problems with my Standby: It
repeats trying to restore the same WAL file all the time:
2014-02-11 10:19:20 CET LOG: invalid record length at 2B3/E6F9C40C
2014-02-11 10:19:25 CET LOG: restored log file
"00000001000002B3000000E6" from archive
2014-02-11 10:19:25 CET LOG: invalid record length at 2B3/E6F9C40C
2014-02-11 10:19:30 CET LOG: restored log file
"00000001000002B3000000E6" from archive
2014-02-11 10:19:30 CET LOG: invalid record length at 2B3/E6F9C40C
2014-02-11 10:19:36 CET LOG: restored log file
"00000001000002B3000000E6" from archive
2014-02-11 10:19:36 CET LOG: invalid record length at 2B3/E6F9C40C
What can I do?
(I do keep a Backup of my WAL files a week back or so, so maybe I can
just try to start recovery at an earlier point?)
Best,
Juergen
Attachments:
signature.asc (application/pgp-signature, 290B) download
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Hot standby hangs when restoring WAL files
2014-02-11 09:47 Hot standby hangs when restoring WAL files Jürgen Fuchsberger <juergen.fuchsberger@uni-graz.at>
@ 2014-02-11 09:56 ` Jürgen Fuchsberger <juergen.fuchsberger@uni-graz.at>
0 siblings, 0 replies; 2+ messages in thread
From: Jürgen Fuchsberger @ 2014-02-11 09:56 UTC (permalink / raw)
To: pgsql-admin
On 02/11/2014 10:47 AM, Jürgen Fuchsberger wrote:
> Hi,
>
> After my Master server hanged I have problems with my Standby: It
> repeats trying to restore the same WAL file all the time:
>
> 2014-02-11 10:19:20 CET LOG: invalid record length at 2B3/E6F9C40C
> 2014-02-11 10:19:25 CET LOG: restored log file
> "00000001000002B3000000E6" from archive
> 2014-02-11 10:19:25 CET LOG: invalid record length at 2B3/E6F9C40C
> 2014-02-11 10:19:30 CET LOG: restored log file
> "00000001000002B3000000E6" from archive
> 2014-02-11 10:19:30 CET LOG: invalid record length at 2B3/E6F9C40C
> 2014-02-11 10:19:36 CET LOG: restored log file
> "00000001000002B3000000E6" from archive
> 2014-02-11 10:19:36 CET LOG: invalid record length at 2B3/E6F9C40C
>
> What can I do?
>
> (I do keep a Backup of my WAL files a week back or so, so maybe I can
> just try to start recovery at an earlier point?)
>
> Best,
> Juergen
>
btw: PG-version is 9.1 under Debian Wheezy.
Juergen
Attachments:
signature.asc (application/pgp-signature, 290B) download
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2014-02-11 09:56 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-02-11 09:47 Hot standby hangs when restoring WAL files Jürgen Fuchsberger <juergen.fuchsberger@uni-graz.at>
2014-02-11 09:56 ` Jürgen Fuchsberger <juergen.fuchsberger@uni-graz.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox