-----Original Message----- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, May 23, 2017 10:31 AM To: Igor Neyman <iney...@perceptron.com>; pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BETA
On 05/23/2017 07:05 AM, Igor Neyman wrote: >> >> pg_hba.conf modified to allow "replication" user to connect to the server. >> In the original email I mentioned that I configured Postgres_fdw foreign >> server that connects using the same connection options as I'm using in >> CREATE SUBSCRIPTION, and foreign server works fine, which to me proves that >> there is no issues with pg_hba.conf. > > What are the contents of the pg_hba.conf file? > > What are the CREATE PUBLICATION and CREATE SUBSCRIPTION commands you are > using? > > >> >> Regards, >> Igor >> > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > ______________________________________________________________________ > _____________________________________ > > These two systems are my "sandboxes". Define sandbox: Are they on VMs on a single machine or something else? > > So, here is pg_hba on the publishing server: > > # IPv4 local connections: > host all all 127.0.0.1/32 md5 > host all repl_user 0.0.0.0/0 md5 > # IPv6 local connections > host all all ::1/128 > md5 I do not see an IPv6 all hosts entry for repl_user, Something like: host all repl_user ::/0 md5 _______________________________________________________________________________________ Not a single machine. Publisher is on a physical machine. Subscriber is on VM. Nothing changed after I added IPV6 entry: host all repl_user ::/0 md5 on publishing machine. Regards, Igor -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general