From: | Michael Banck <michael(dot)banck(at)credativ(dot)de> |
---|---|
To: | William Ivanski <william(dot)ivanski(at)2ndquadrant(dot)com> |
Cc: | pgsql-pkg-debian(at)postgresql(dot)org |
Subject: | Re: Fixed port 65432 in pglogical_create_subscriber |
Date: | 2020-09-25 09:41:13 |
Message-ID: | 852075437da46121ef5c3293356fd05bec600160.camel@credativ.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-pkg-debian |
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: michael(dot)banck(at)credativ(dot)de
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
From | Date | Subject | |
---|---|---|---|
Next Message | apt.postgresql.org Repository Update | 2020-09-25 10:12:13 | plr updated to version 1:8.4.1-1.pgdg+1 |
Previous Message | William Ivanski | 2020-09-25 04:18:30 | Fixed port 65432 in pglogical_create_subscriber |