From: Rural Hunter <ruralhunter@gmail.com>
To: pgsql-admin@postgresql.org
Subject: hot standby failed to start
Date: Fri, 09 Dec 2011 15:19:42 +0800
Message-ID: <4EE1B68E.8000209@gmail.com> (raw)
Hi,
I'm trying to set up a hot standby server with both primary and standby
are at latest version 9.1.2. I used pg_basebackup to create the backup
and there was no problem in the log:
NOTICE: pg_stop_backup complete, all required WAL segments have been
archived
-rw-r--r-- 1 postgres postgres 52203357921 2011-12-09 02:53
/dbbk/postgres/base/01/base_20111208.tar.gz
After I set up all configuration files at standby, I started the standby
but it failed with this:
2011-12-09 14:40:28 CST LOG: restored log file
"000000020000081B000000F1" from archive
2011-12-09 14:40:29 CST LOG: restored log file
"000000020000081B000000F2" from archive
2011-12-09 14:40:30 CST LOG: restored log file
"000000020000081B000000F3" from archive
2011-12-09 14:40:32 CST LOG: restored log file
"000000020000081B000000F4" from archive
2011-12-09 14:40:33 CST LOG: restored log file
"000000020000081B000000F5" from archive
2011-12-09 14:40:34 CST LOG: restored log file
"000000020000081B000000F6" from archive
2011-12-09 14:40:34 CST PANIC: heap_update_redo: invalid lp
2011-12-09 14:40:34 CST CONTEXT: xlog redo update: rel
1663/16405/8694402; tid 1529971/91; new 1529971/92
2011-12-09 14:40:34 CST LOG: startup process (PID 7728) was terminated
by signal 6: Aborted
2011-12-09 14:40:34 CST LOG: terminating any other active server processes
Here are the wal archives near the fail log:
-rw------- 1 postgres postgres 5464161 2011-12-09 02:53
000000020000081B000000F0.gz
-rw------- 1 postgres postgres 5744461 2011-12-09 02:53
000000020000081B000000F1.gz
-rw------- 1 postgres postgres 5637256 2011-12-09 02:53
000000020000081B000000F2.gz
-rw------- 1 postgres postgres 5685037 2011-12-09 02:53
000000020000081B000000F3.gz
-rw------- 1 postgres postgres 5612374 2011-12-09 02:53
000000020000081B000000F4.gz
-rw------- 1 postgres postgres 228 2011-12-09 02:53
000000020000081200000049.000000C0.backup.gz
-rw------- 1 postgres postgres 5591283 2011-12-09 02:53
000000020000081B000000F5.gz
-rw------- 1 postgres postgres 6557821 2011-12-09 02:54
000000020000081B000000F6.gz
-rw------- 1 postgres postgres 6186619 2011-12-09 02:55
000000020000081B000000F7.gz
-rw------- 1 postgres postgres 5980735 2011-12-09 02:56
000000020000081B000000F8.gz
What's wrong with the standby and what can I do to find the root cause
of this?
btw, I set full_page_writes off on primary server because it creates too
many wal files(around 20-30 files every min).
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ruralhunter@gmail.com
Subject: Re: hot standby failed to start
In-Reply-To: <4EE1B68E.8000209@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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