Updated the auth method for postgres from trust to password authentication

[DurgaiVS]

Previously the postgres auth method was set as TRUST, which is insecure so updating the auth method to password authentication.