Enable password authentication for PostgreSQL

resolves #5264