PostgreSQL: Enable Password Authentication for Super user
By default, on localhost, a super user is able to connect to database using psql with out a password. This lecture talks about modifying that default behavior.
This lecture talks about setting up a password for "postgres" database user.