Replication to Postgres 10 on Windows is broken

From: "Augustine, Jobin" <jobin(dot)augustine(at)openscg(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Replication to Postgres 10 on Windows is broken
Date: 2017-08-04 05:53:43
Message-ID: CAHBggj8g2T+ZDcACZ2FmzX9CTxkWjKBsHd6NkYB4i9Ojf6K1Fw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

*Summary:*
Replica / Slave on Windows fails to conenct to Master.

*Scenario:*
Master: PostgreSQL 10 (beta1,beta2), Any OS (Linux, Windows, Mac)
Slave : PostgreSQL 10 (beta1,beta2), Windows (Any MS Windows OS)
Slave must be on Windows Machine running on a different server than the
Master

*Steps to reproduce:*
1. Setup a Postgres 10betaX master database can be on any platform
(Linux/Windows/Mac)
2. Try to setup a streaming replica on any of the MS Windows running a
different Server than the master
(replication within the same server works!)

*Error in Postgres logs:*
Lines like below keep repeating in Slave side postgres log
----------------------
2017-08-03 10:49:41 UTC [2108]: [1-1] user=,db=,app=,client= FATAL: could
not connect to the primary server: could not send data to server: Socket is
not connected (0x00002749/10057)
could not send SSL negotiation packet: Socket is not connected
(0x00002749/10057)
2017-08-03 10:49:45 UTC [3600]: [1-1] user=,db=,app=,client= FATAL: could
not connect to the primary server: could not send data to server: Socket is
not connected (0x00002749/10057)
could not send SSL negotiation packet: Socket is not connected
(0x00002749/10057)
2017-08-03 10:49:50 UTC [4832]: [1-1] user=,db=,app=,client= FATAL: could
not connect to the primary server: could not send data to server: Socket is
not connected (0x00002749/10057)
could not send SSL negotiation packet: Socket is not connected
(0x00002749/10057)
-------------------------

*Additional Information:*
Stand alone tools like psql, pg_basebackup, pg_recivewal etc are
successful in connecting to primary server and perform their
functionalities.
Postgres 9.6 replication works fine across same set of servers.
This Windows specific issue reproducible across pg10beta1 and beta2
This is tested and confirmed by multiple people from my team across
different Windows versions.

-Jobin Augustine

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Petr Jelinek 2017-08-04 09:41:12 Re: BUG #14769: Logical replication error "cache lookup failed for type 0"
Previous Message Dean Franken 2017-08-04 02:55:02 Unable to completely drop pgagent schema

Browse pgsql-hackers by date

  From Date Subject
Next Message Masahiko Sawada 2017-08-04 06:19:20 Re: Quorum commit for multiple synchronous replication.
Previous Message Masahiko Sawada 2017-08-04 05:22:33 Re: Unused variable scanned_tuples in LVRelStats