[Pkg-postgresql-public] Bug#915965: postgresql-11: postgresql listens on non-default port number 5433

[Ralf Jung]

Package: postgresql-11
Version: 11.1-1+b2
Severity: important

Dear Maintainer,

after some recent upgrade (within the last couple months), postgresql seemingly
switched from listening on port 5432 to listening on port 5433.  I only found
out because an application that used to work just fine suddenly stopped working
and complained it could not find the unix domain socket it expected.

I do not know why it now says "port = 5433" in my
/etc/postgresql/11/main/postgresql.conf, but I know for sure that I did not
change this configuration.  According to etckeeper, this happened when I
upgraded from postgresql-10 to postgresql-11, which happened automatically via
dist-upgrade.  (I had to manually uninstall postgresql-10 afterwards, but did
not think much about that.)

Debian not using the default port means that all sorts of applications and
tutorials will just not work, and it can take a while for people not deeply
familiar with postgres to figure out what is going on.  And either way, changing
the DB port without administrator intervention is claerly a bug.  DB upgrades
should not have side-effects like changing the DB port.

Kind regards,
Ralf

-- System Information:
Debian Release: buster/sid
  APT prefers testing
  APT policy: (990, 'testing'), (500, 'unstable-debug'), (500, 'testing-debug'), (100, 'unstable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 4.18.0-3-amd64 (SMP w/8 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages postgresql-11 depends on:
ii  libc6                 2.27-8
ii  libgcc1               1:8.2.0-9
ii  libgssapi-krb5-2      1.16.1-1
ii  libicu63              63.1-4
ii  libldap-2.4-2         2.4.46+dfsg-5+b1
ii  libllvm7              1:7-6
ii  libpam0g              1.1.8-3.8
ii  libpq5                11.1-1+b2
ii  libselinux1           2.8-1+b1
ii  libssl1.1             1.1.1a-1
ii  libstdc++6            8.2.0-9
ii  libsystemd0           239-13
ii  libuuid1              2.32.1-0.1
ii  libxml2               2.9.4+dfsg1-7+b2
ii  libxslt1.1            1.1.32-2
ii  locales               2.27-8
ii  postgresql-client-11  11.1-1+b2
ii  postgresql-common     197
ii  ssl-cert              1.0.39
ii  tzdata                2018g-1
ii  zlib1g                1:1.2.11.dfsg-1

Versions of packages postgresql-11 recommends:
ii  sysstat  12.0.1-1

Versions of packages postgresql-11 suggests:
pn  locales-all  <none>

-- no debconf information