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

Volodymyr Kostyrko c.kworr at
Tue Aug 13 14:45:57 UTC 2013

13.08.2013 17:30, O. Hartmann wrote:
> 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   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

I guess ENCRYPTED means you are substituting FooMe with md5 hashed 
password correctly salted with role name as postgresql requires?

> 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?

Sphinx of black quartz, judge my vow.

More information about the freebsd-questions mailing list