Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 4BFEE1F60707 for ; Fri, 9 Dec 2011 03:20:02 -0400 (AST) Received: from mail-iy0-f174.google.com ([209.85.210.174]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RYukT-0005eo-Pc for pgsql-admin@postgresql.org; Fri, 09 Dec 2011 07:20:02 +0000 Received: by iakc1 with SMTP id c1so3798351iak.19 for ; Thu, 08 Dec 2011 23:19:49 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject :content-type:content-transfer-encoding; bh=VXbA8iXon2hILIvNQPBzs2a34b35HLsu0IpTo54gIqA=; b=k3RT8ZkkdoYwQT4rLA58YSBDAYc3LwbpNmetA5OyD4tRgwzosNcUzlYR1lij3EP2UC W6lzwYteUaiOX7tjMCJs9F5bCwKtiETYFKH/wwKcKiv3RQ/QpKHC32ALc8Lzv6kHleSN 1r55P1rxVN1IY2AYWGs/sfJwMtlGyqXBf5TMo= Received: by 10.42.151.65 with SMTP id d1mr2008903icw.18.1323415189455; Thu, 08 Dec 2011 23:19:49 -0800 (PST) Received: from [192.168.1.2] ([180.173.33.50]) by mx.google.com with ESMTPS id b20sm6738615ibj.7.2011.12.08.23.19.45 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 08 Dec 2011 23:19:48 -0800 (PST) Message-ID: <4EE1B68E.8000209@gmail.com> Date: Fri, 09 Dec 2011 15:19:42 +0800 From: Rural Hunter User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:8.0) Gecko/20111105 Thunderbird/8.0 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: hot standby failed to start Content-Type: text/plain; charset=GB18030; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201112/61 X-Sequence-Number: 38819 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).