public inbox for [email protected]  

help / color / mirror / Atom feed

From: Michael Banck <[email protected]>
To: William Ivanski <[email protected]>
Cc: [email protected]
Subject: Re: Fixed port 65432 in pglogical_create_subscriber
Date: Fri, 25 Sep 2020 11:41:13 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAG7+Lq__342Y7GMzhmmspPRmE=SuPRcEvPhEsMJcg9o6PjWt8A@mail.gmail.com>
References: <CAG7+Lq__342Y7GMzhmmspPRmE=SuPRcEvPhEsMJcg9o6PjWt8A@mail.gmail.com>

Hi William,

Am Freitag, den 25.09.2020, 01:18 -0300 schrieb William Ivanski:
> I've been trying to convert a PostgreSQL 9.4 physical standby into a
> logical subscriber using pglogical_create_subscriber. It can't
> initialize pglogical on the subscriber server because it can't connect
> to the local PostgreSQL database after a restart, so it hangs.
> 
> As you can see below (sensitive information redacted), I have
> configured to start local PostgreSQL database on port 5433. File
> /etc/postgresql/9.4/main/postgresql.conf confirms port is set to 5433.

[...]

> pglogical_create_subscriber started the local PostgreSQL instance on
> port 65432, but it's expecting to connect to port 5433, so it will
> never be able to connect.
> 
> I checked pglogical source code on [1] and I was not able to find any
> explanation for this fixed port 65432. Then I found the pglogical
> source code is being patched to start Postgres with a fixed port 65432
> here [2].

That patch has been around a long time, I think we had to introduce it
in order to get the testsuite running; maybe it was just a shortcut. I
agree that it's breaking the user experience though.

I can see whether the testsuite got fixed/changed upstream in the
meantime and we can drop the patch now.


Michael

-- 
Michael Banck
Projektleiter / Senior Berater
Tel.: +49 2166 9901-171
Fax:  +49 2166 9901-100
Email: [email protected]

credativ GmbH, HRB Mönchengladbach 12080
USt-ID-Nummer: DE204566209
Trompeterallee 108, 41189 Mönchengladbach
Geschäftsführung: Dr. Michael Meskes, Jörg Folz, Sascha Heuer

Unser Umgang mit personenbezogenen Daten unterliegt
folgenden Bestimmungen: https://www.credativ.de/datenschutz

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Fixed port 65432 in pglogical_create_subscriber
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox