Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g4X7V-0003Dt-0z for pgsql-admin@arkaria.postgresql.org; Mon, 24 Sep 2018 20:06:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g4X7S-0007et-Jp for pgsql-admin@arkaria.postgresql.org; Mon, 24 Sep 2018 20:06:10 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g4X7S-0007em-8i for pgsql-admin@lists.postgresql.org; Mon, 24 Sep 2018 20:06:10 +0000 Received: from mail.thelabyrinth.net ([45.56.70.56]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g4X7P-0003xV-NG for pgsql-admin@postgresql.org; Mon, 24 Sep 2018 20:06:08 +0000 Received: from Davids-MacBook.local (unknown [162.210.198.23]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) (Authenticated sender: dsteele) by mail.thelabyrinth.net (Postfix) with ESMTPSA id 041F454664; Mon, 24 Sep 2018 20:06:05 +0000 (UTC) Subject: Re: New replica with pgbackrest To: Aldo Sarmiento , pgsql-admin@postgresql.org References: From: David Steele Message-ID: <655096f6-e422-0630-7cc1-3db4e59a18ef@pgmasters.net> Date: Mon, 24 Sep 2018 16:06:05 -0400 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi Aldo, On 9/23/18 11:53 AM, Aldo Sarmiento wrote: > > # (REPLICA) tail -n 100 -f /var/log/postgresql/postgresql-9.4-main.log > 2018-09-23 10:22:14.111 P00   INFO: unable to find > 0000000100000CB600000053 in the archive > 2018-09-23 10:22:14.111 P00   INFO: got WAL segment 0000000100000CB600000053 > 2018-09-23 10:22:14.111 P00   INFO: archive-get command end: aborted > with exception [001] This is a known issue in 2.05. It will report an error at INFO level when a WAL segment is not found, but is otherwise harmless. > 2018-09-23 10:27:57.129 CDT [10139-2]: bpd_production postgres@[local] > 57P03 [unknown] FATAL:  the database system is starting up Are you sure `hot_standby=on` on the standby? I don't see it in your configuration. Regards, -- -David david@pgmasters.net