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
[email protected]
_______________________________________________________________________________________________________
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
[email protected]
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
