-----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxxxx] Sent: Thursday, May 25, 2017 3:13 PM To: Igor Neyman <ineyman@xxxxxxxxxxxxxx>; George Neuner <gneuner2@xxxxxxxxxxx>; pgsql-general@xxxxxxxxxxxxxx Subject: Re: 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.klaver@xxxxxxxxxxx ________________________________________________________________________________________________ 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
