From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: [External] Re: WAL Replication query
Date: Tue, 1 Nov 2022 02:43:46 -0500
Message-ID: <8f9e6c92-4daa-a543-6825-05a3503f4296@gmail.com> (raw)
In-Reply-To: <c1b6b89d6b89706acaeca9b4d45958f4739c4f28.camel@cybertec.at>
References: <CAKgGyB-SMT0RxeoifAfjkRx6RHEOgpn7sf8F_zD1DPsKydTu=w@mail.gmail.com>
<88faef33e966796226022d6e7f3e32ad6c59fcfd.camel@cybertec.at>
<MW4PR20MB4525ED0222DDE9FED0519D8FF3369@MW4PR20MB4525.namprd20.prod.outlook.com>
<c1b6b89d6b89706acaeca9b4d45958f4739c4f28.camel@cybertec.at>
On 11/1/22 01:53, Laurenz Albe wrote:
> On Tue, 2022-11-01 at 06:44 +0000, Sacheen Birhade wrote:
>> If replication is in asynchronous then there will be data loss, right Laurenz?
> Why? The data will perhaps show up on the standby a little later, but why is
> that data loss? Remember that the question was about replication, and there
> was no mention of failover.
No, the question was about a crash during replication: OP (not Sacheen,
unless that person is using two email addresses) explicitly asked "*When the
primary crashes* due an unforeseen reason (what happens)?"
If the two database systems are really busy, and especially if the network
connection isn't fast enough, *async* replication means there *might* be
some transactions committed on Primary which were queued for transmission,
but hadn't yet made it to the Secondary, right?
--
Angular momentum makes the world go 'round.
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: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: [External] Re: WAL Replication query
In-Reply-To: <8f9e6c92-4daa-a543-6825-05a3503f4296@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