Problem: Postgres does not check my password, i.e. it accepts all passwords.
Solution: pg_hba.conf and change trust to md5. Restart postgres. That is all.
(source)
A piggy bank of commands, fixes, succinct reviews, some mini articles and technical opinions from a (mostly) Perl developer.