Re: [GENERAL] logical replication in PG10 BETA

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Thursday, May 25, 2017 3:13 PM To: Igor Neyman <iney...@perceptron.com>; George Neuner <gneun...@comcast.net>; pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BE

Re: [GENERAL] logical replication in PG10 BETA

On 05/25/2017 11:09 AM, Igor Neyman wrote: __ Adrian, thanks for trying to help. Even though the role I'm using (user=repl_user) has REPLICATION attribute, I thought your question about

Re: [GENERAL] logical replication in PG10 BETA

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Wednesday, May 24, 2017 7:06 PM To: Igor Neyman <iney...@perceptron.com>; George Neuner <gneun...@comcast.net>; pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BE

Re: [GENERAL] logical replication in PG10 BETA

t.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 a

Re: [GENERAL] logical replication in PG10 BETA

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Wednesday, May 24, 2017 10:00 AM To: Igor Neyman <iney...@perceptron.com>; George Neuner <gneun...@comcast.net>; pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BET

Re: [GENERAL] logical replication in PG10 BETA

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.kla...

Re: [GENERAL] logical replication in PG10 BETA

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, May 23, 2017 7:42 PM To: Igor Neyman <iney...@perceptron.com>; George Neuner <gneun...@comcast.net>; pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BE

Re: [GENERAL] logical replication in PG10 BETA

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, May 23, 2017 5:48 PM To: Igor Neyman <iney...@perceptron.com>; pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BETA On 05/23/2017 08:15 AM, Igor Neyman

Re: [GENERAL] logical replication in PG10 BETA

On 05/23/2017 01:38 PM, Igor Neyman wrote: -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of George Neuner Windows does not support "local" domain sockets as in Unix/Linux. Local loopback connections on Windows are

Re: [GENERAL] logical replication in PG10 BETA

On 05/23/2017 08:15 AM, Igor Neyman wrote: -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Adrian Klaver Sent: Tuesday, May 23, 2017 10:04 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication

Re: [GENERAL] logical replication in PG10 BETA

-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of George Neuner Sent: Tuesday, May 23, 2017 4:22 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BETA On Tue, 23 May 2017 15:15:46

Re: [GENERAL] logical replication in PG10 BETA

On Tue, 23 May 2017 15:15:46 +, Igor Neyman wrote: >Interestingly, when I add this line to pg_hba.conf: > >localall all md5 > >Postgres is not starting with the following error in the log file: > >2017-05-23 11:02:10.397 EDT [4796] LOG:

Re: [GENERAL] logical replication in PG10 BETA

-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Adrian Klaver Sent: Tuesday, May 23, 2017 10:04 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BETA On 05/23/2017 06:52 AM, Igor

Re: [GENERAL] logical replication in PG10 BETA

-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

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

Re: [GENERAL] logical replication in PG10 BETA

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, May 23, 2017 9:45 AM To: Igor Neyman <iney...@perceptron.com>; pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BETA On 05/23/2017 06:33 AM, Igor Neyman

Re: [GENERAL] logical replication in PG10 BETA

On 05/23/2017 06:52 AM, Igor Neyman wrote: sounds more like a SSL setup problem between the two Postgres servers, not really related to logical replication. Can you try to setup the connections without SSL?

Re: [GENERAL] logical replication in PG10 BETA

-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Thomas Kellerer Sent: Tuesday, May 23, 2017 9:46 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BETA Igor Neyman schrieb am

Re: [GENERAL] logical replication in PG10 BETA

Igor Neyman schrieb am 22.05.2017 um 21:33: > Does built-in logical replication work on Windows in PG10 BETA release? > > I can’t make it working so far. > > I created Publication on “source” PG server, but when I’m trying to CREATE > SUBSCRIPTION… on “destination” server, I’m getting: > >

Re: [GENERAL] logical replication in PG10 BETA

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

Re: [GENERAL] logical replication in PG10 BETA

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, May 23, 2017 9:26 AM To: Igor Neyman <iney...@perceptron.com>; pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BETA On 05/23/2017 06:17 AM, Igor Neyman

Re: [GENERAL] logical replication in PG10 BETA

On 05/23/2017 06:17 AM, Igor Neyman wrote: -Original Message- "ERROR: could not connect to the publisher: could not send data to server: Socket is not connected (0x2749/10057) could not send SSL negotiation packet: Socket is not connected (0x2749/10057) SQL state: XX000" In

Re: [GENERAL] logical replication in PG10 BETA

-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Monday, May 22, 2017 7:56 PM To: Igor Neyman <iney...@perceptron.com>; pgsql-general@postgresql.org Subject: Re: [GENERAL] logical replication in PG10 BETA On 05/22/2017 12:33 PM, Igor Neyman wrote

Re: [GENERAL] logical replication in PG10 BETA

On 05/22/2017 12:33 PM, Igor Neyman wrote: Hi, Does built-in logical replication work on Windows in PG10 BETA release? Short version: Maybe. Long version: AFAIK to run on Windows you need to build pglogical 2.0 from source master branch. So what version of pglogical and how did you

[GENERAL] logical replication in PG10 BETA

Hi, Does built-in logical replication work on Windows in PG10 BETA release? I can't make it working so far. I created Publication on "source" PG server, but when I'm trying to CREATE SUBSCRIPTION... on "destination" server, I'm getting: "ERROR: could not connect to the publisher: could not send