| From: | Sreerama Manoj <manoj(dot)sreerama973(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | A query in Streaming Replication |
| Date: | 2020-06-13 14:56:37 |
| Message-ID: | CA+go1QERSrPQXsjzvadqetBg5srsa6bfxxBnm++6rEXbkdRZng@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | sekhar chandra | 2020-06-13 17:33:57 | Re: Fwd: not able to give usage access to public schema |
| Previous Message | Laurenz Albe | 2020-06-13 11:53:28 | Re: Something else about Redo Logs disappearing |