Re: logical replication in PG10 BETA

-----Original Message-----
From: Adrian Klaver [mailto:adrian(dot)klaver(at)aklaver(dot)com]
Sent: Thursday, May 25, 2017 3:13 PM
To: Igor Neyman <ineyman(at)perceptron(dot)com>; George Neuner <gneuner2(at)comcast(dot)net>; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] logical replication in PG10 BETA

On 05/25/2017 11:09 AM, Igor Neyman wrote:

> ______________________________________________________________________
> ____________________________________
>
> Adrian, thanks for trying to help.
>
> Even though the role I'm using (user=repl_user) has REPLICATION attribute, I thought your question about .pgpass file was going to put me on a "right track" because I was not using/didn't have password file.

I may have steered you wrong on this. The more think about it the more I realize that the server will probably not read the .pgpass file.

> So, I created one proper password file (it works fine when I'm trying to connect through psql with no password). Unfortunately, it didn't make any difference for CREATE SUBSCRIPTION.

Two options come to mind to test whether the password is the problem:

1) Include the password in the connection string in CREATE SUBSCRIPTION.

2) Change the auth method in pg_hba.conf on the publisher server from
md5 to trust and reload the server.

Neither is optimal, still it is a starting point.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
________________________________________________________________________________________________

Tried the 1) even though CREATE SUBSCRIPTION isn't expecting password in connections string, it doesn't help.
Tried the 2) - didn't help either.
In both cases still getting:

ERROR: could not connect to the publisher: could not send data to server: Socket is not connected (0x00002749/10057)
could not send SSL negotiation packet: Socket is not connected (0x00002749/10057)

Regards,
Igor