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@aklaver.com
> _______________________________________________________________________________________________________
>
> 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
connectionoptions as I'm using in CREATE SUBSCRIPTION, and foreign server works fine, which to me proves that there is
noissues 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@aklaver.com