trouble with PostgreSQL 9.2 on FreeBSD 10.0-CURRENT: superuser can not autheticate anymore with md5 password hash set

O. Hartmann ohartman at zedat.fu-berlin.de
Tue Aug 13 14:30:09 UTC 2013


For the past I ran PostgreSQL 9.2 servers on FreeBSD 10.0-CURRENT
successfully. But by now, out of the blue, login as the database's
supervisor "pgsql" remotely isn't possible any more.

The appropriate lines in pg_hba.conf are:

local   all  pgsql md5
hostssl all  pgsql 0.0.0.0/0   md5

The funny thing is: when login locally without providing a password
(swap md5 to trust in the "local" line) and setting the password for
the role "pgsql" via

ALTER ROLE pgsql ENCRYPTED PASSWORD 'FooMe";

or doing the same via pgadmin3 from remotely by also swapping md5 to
trust in the line "hostssl" for global network, it seems I could
alter/change the password for the supervisor pgsql. But restoring the
password check by setting back "md5" leaves me locked out!

By the way, this strange behaviour occurs on ALL(!) PostgreSQL 9.2
servers running on FreeBSD 10.0-CURRENT boxes.

Ports databases/postgresql-XXX as well as FreeBSD is as of the latest
sources and up to date.

What is going wrong?

Please CC me.

Regards,

Oliver
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 488 bytes
Desc: not available
URL: <http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20130813/d0145c47/attachment.sig>


More information about the freebsd-questions mailing list