* Zahid Rahman (zahidr1000@gmail.com) wrote: > You have to set to trust from peer the first time you download and install > postgres. > Because there is no default password. > After you create a password. > Then you can reset from trust.
No- peer auth allows the "postgres" unix user, which is the user that the database runs as, to connect.
To do so, you would first "sudo su - postgres" and then run psql, and then you'll be able to connect without any need for a password. This is exactly what 'peer' auth is for and how it works and it's quite secure.
There's no need to ever change the authentication method to be 'trust' and I don't recommend doing so because it's very insecure.
> You also have to reboot your computer each time you change > etc/postgresql/12/main/pg_hba.conf. > at the very least restart the database.
You don't have to restart the computer or the database when changes are made to pg_hba.conf- you just need to issue a "reload".