Re: A query in Streaming Replication - Mailing list pgsql-general

From Sreerama Manoj
Subject Re: A query in Streaming Replication
Date
Msg-id CA+go1QF6OEzGCERRz9pyK2dUY0-qrCeR1RiH3cywiCgxsWCp-g@mail.gmail.com
Whole thread Raw
In response to A query in Streaming Replication  (Sreerama Manoj <manoj.sreerama973@gmail.com>)
Responses Re: A query in Streaming Replication  (Kyotaro Horiguchi <horikyota.ntt@gmail.com>)
List pgsql-general
Hello,

Forgot to add the version details. I'm using postgres 10.7 . 

On Sat, Jun 13, 2020, 20:26 Sreerama Manoj <manoj.sreerama973@gmail.com> wrote:
Hello,
      I use streaming replication in async mode. When master gets down, slave will be promoted using a trigger file. During this process ".partial" file will be created and a WAL file with same ID will be created in a different time line in slave. When master comes back as slave, it will be synced to the current master. This is the normal procedure as far as I understood. But in some cases, ".partial" file is not getting created and peer DB which comes back as slave is unable to sync when this happens.. Please suggest if this happens in any scenario and how to overcome this.

Thanks & Regards:
Manoj.


pgsql-general by date:

Previous
From: sekhar chandra
Date:
Subject: Re: Fwd: not able to give usage access to public schema
Next
From: Adrian Klaver
Date:
Subject: Re: Fwd: not able to give usage access to public schema