Set up authentication methods for postgresql users

[postgresql]_set_up_authentications_postgresql_user.md

1. Go to config directory

 cd /etc/postgresql/<postgresql_version>/main

2. Open and update file "pg_hba.conf" to dismiss all authentications for "postgres" user (normally line 85)

• Before updating

 local   all             postgres                                peer

• After updating

local   all             postgres                                trust

3. Restart Postgresql service to apply new configuration

sudo service postgresql restart

4. Login to postgresql with user "postgres" (without any authentications)

psql -U postgres

5. Change password of this postgresql user

ALTER USER postgres WITH PASSWORD '<your password>';

6. Reupdate file "pg_hba.conf" to apply password authentication for "postgres" user

• Before updating

 local   all             postgres                                trust

• After updating

local   all             postgres                                md5

7. Restart Postgresql service to apply new configuration

sudo service postgresql restart

8. Login to postgresql with user "postgres" (require password)

psql -U postgres