On 05/23/2017 06:33 AM, Igor Neyman wrote:
Yeah, my mistake I was working with pglogical and it got stuck in my head.
Any other ideas?
Have you gone through these sections of the docs?:
https://www.postgresql.org/docs/10/static/logical-replication-config.html
https://www.postgresql.org/docs/10/static/logical-replication-quick-setup.html
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
_______________________________________________________________________________________________________
Yes. All parameters mentioned in the docs configured properly.
CREATE PUBLICATION works fine.
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.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general