Greetings,
* 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".
Thanks,
Stephen