From: | "Augustine, Jobin" <jobin(dot)augustine(at)openscg(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Andres Freund <andres(at)anarazel(dot)de>, Noah Misch <noah(at)leadboat(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, pgsql-bugs(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [BUGS] Replication to Postgres 10 on Windows is broken |
Date: | 2017-08-14 09:01:51 |
Message-ID: | CAHBggj_qnibwvJRK=+7pr5O3KdEfsGFrQ9J4JiehxBgF3jaoHA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
Thank you Tom Lane,
This patch fixes the problem.
With this patch, streaming replication started working (replication to
Windows)
(Tested for Linux to Windows replication)
-Jobin.
On Mon, Aug 14, 2017 at 2:17 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Andres Freund <andres(at)anarazel(dot)de> writes:
> > On 2017-08-11 18:11:03 +0530, Augustine, Jobin wrote:
> >> Appears that patch is not helping.
>
> > That's too bad. Any chance you could install
> > https://docs.microsoft.com/en-us/sysinternals/downloads/procmon and
> > activate monitoring just for that phase? I think it can export to a text
> > file...
>
> It strikes me that maybe the misuse of io_flag could be contributing
> to this: if the walreceiver process's latch were set, we'd end up calling
> PQconnectPoll before the socket had necessarily come ready, which would
> produce the described symptom. That's grasping at straws admittedly,
> because I'm not sure why the walreceiver process's latch would be set
> at this point; but it seems like we ought to test a version of the patch
> that we believe correct before deciding that we still have a problem.
>
> To move things along, here's a corrected patch --- Jobin, please test.
>
> regards, tom lane
>
>
--
*Jobin Augustine*
Architect : Production Database Operations
*OpenSCG*
*phone : +91 9989932600*
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Meskes | 2017-08-14 09:33:00 | Re: BUG #14754: ecpg SQL parsing error |
Previous Message | Peter Geoghegan | 2017-08-13 22:36:09 | Re: [BUGS] Replication to Postgres 10 on Windows is broken |
From | Date | Subject | |
---|---|---|---|
Next Message | Masahiko Sawada | 2017-08-14 09:18:42 | Re: pgbench: Skipping the creating primary keys after initialization |
Previous Message | Magnus Hagander | 2017-08-14 08:44:07 | Re: Patches I'm thinking of pushing shortly |