[Bug 250068] databases/postgres12-server: psql: error: could not connect to server: server closed the connection unexpectedly

[bugzilla-noreply at freebsd.org]

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=250068

            Bug ID: 250068
           Summary: databases/postgres12-server: psql: error: could not
                    connect to server: server closed the connection
                    unexpectedly
           Product: Ports & Packages
           Version: Latest
          Hardware: Any
                OS: Any
            Status: New
          Severity: Affects Only Me
          Priority: ---
         Component: Individual Port(s)
          Assignee: ports-bugs at FreeBSD.org
          Reporter: ohartmann at walstatt.org

Running databases/postgresql12on a recent CURRENT (at the moment FreeBSD
13.0-CURRENT #50 r366364: Fri Oct  2 17:51:18 CEST 2020 amd64). The problem
persists a couple of months for now, last checked in March 2020. OS and ports
are updated on a regular basis.

Host is running dual stack IPv4 and IPv6.

We switched password encryption from md5 to scram-sha-256 and I believe since
then the mysterious problems occured, not sure. But I'll proceed and explain.

postgresql.conf has been adapted as well via "password_encryption =
scram-sha-256". Passwords in question have been changed within databases
accordingly, especially the passowrd for database superuser "postgres".

pg_hba.conf has been adapted accordingly as well:

local  all postgres scram-sha-256|trust # alternative for tests

host    all   postgres  127.0.0.1/32   scram-sha-256
host    all   postgres  ::1/128       scram-sha-256

The server is listening on all addresses, checked via sockstat.

Trying to login on any database with the owner of the database or even postgres
results in:

psql -U postgres -d postgres -h localhost -W (or IP of the host, even 127.0.0.1
or ::1) 

Result:
psql: error: could not connect to server: server closed the connection
unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.

Login omitting -h localhost (or IP) is all right. Login via any on-host client
authenticating locally fails. Login via remote session from another host using
psql client also results in a fail.

There are other users accessing databases and authentication via LDAP
(OpenLDAP). This works from the local host as well from remote hosts.

Looking at log protocolls revela nothing. The failed logins seeme to bee seen
by the server, the server logs aline like

LOG:  connection received: host=localhost port=37906

Then nothing and after a while I receive the error 

psql: error: could not connect to server: server closed the connection
unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.


This might be a bug.

-- 
You are receiving this mail because:
You are the assignee for the bug.