Automatically configure pg_hba to use password authentication for local connections