Re: [GENERAL] logical replication in PG10 BETA - Mailing list pgsql-general

From Igor Neyman
Subject Re: [GENERAL] logical replication in PG10 BETA
Date
Msg-id DM5PR07MB281094A19F7BF0DCCD413140DAFE0@DM5PR07MB2810.namprd07.prod.outlook.com
Whole thread Raw
In response to Re: [GENERAL] logical replication in PG10 BETA  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: [GENERAL] logical replication in PG10 BETA  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@aklaver.com] 
Sent: Tuesday, May 23, 2017 7:42 PM
To: Igor Neyman <ineyman@perceptron.com>; George Neuner <gneuner2@comcast.net>; pgsql-general@postgresql.org
Subject: Re: [GENERAL] logical replication in PG10 BETA


So take the local line out of pg_hba. Then from the machine that is the subscriber do:

psql -d repl -h pub_machine -p 5432 -U repl_user

--
Adrian Klaver

adrian.klaver@aklaver.com

________________________________________________________________________________________

This psql connection works.
Even more, like I showed in one of previous messages, connection between 2 PG servers using Postgres_fdw also works,
andit uses the same connection string as CREATE SUBSCRIPTION statement.
 

Regards,
Igor

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: [GENERAL] Current best practice for maximum shared_bufferssettings on big hardware?
Next
From: Igor Korot
Date:
Subject: Re: [GENERAL] Have just libpg installer