From: David Steele <david@pgmasters.net>
To: Aldo Sarmiento <aldo@bigpurpledot.com>
To: pgsql-admin@postgresql.org
Subject: Re: New replica with pgbackrest
Date: Mon, 24 Sep 2018 16:06:05 -0400
Message-ID: <655096f6-e422-0630-7cc1-3db4e59a18ef@pgmasters.net> (raw)
In-Reply-To: <CAHX=r6xUGd0a-21PTvTM3UHCiu0QLF3n1Mbax72+JsXJhGWA3w@mail.gmail.com>
References: <CAHX=r6xUGd0a-21PTvTM3UHCiu0QLF3n1Mbax72+JsXJhGWA3w@mail.gmail.com>
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
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: david@pgmasters.net, aldo@bigpurpledot.com
Subject: Re: New replica with pgbackrest
In-Reply-To: <655096f6-e422-0630-7cc1-3db4e59a18ef@pgmasters.net>
* 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