[Bug 1533153] Re: cannot connect to database after update to postgresql 9.5
Christian Bachmaier
chris at infosun.fim.uni-passau.de
Tue Jan 12 13:01:53 UTC 2016
This is not a bug, but a feature which was hard to see for me:
The package update installs postgresql 9.5 in parallel to 9.4 such that one has the chance to dump the database with 9.4 and to import the dump with 9.5 as a .releases have incompatible data base formats. To be able to run them in parallel, the (tcp/ip) port of 9.5 is incremented by one and thus 5433 instead of default 5432. So far so good, as I connect over a socket and never by tcp/ip on this system.
However, the socket file in /var/lib/postgresql contains also the port number, probably to have seperate sockets for more than one postgresql server on one system. So my mistake was to identify port with tcp/ip port. I wonder if that is on the update notification automatically displayed during system updates.
Sorry, I was too fast (after about 10h trying) to open this bug here.
** Changed in: libapache2-mod-auth-pgsql (Ubuntu)
Status: New => Invalid
--
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to libapache2-mod-auth-pgsql in Ubuntu.
https://bugs.launchpad.net/bugs/1533153
Title:
cannot connect to database after update to postgresql 9.5
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libapache2-mod-auth-pgsql/+bug/1533153/+subscriptions
More information about the Ubuntu-server-bugs
mailing list