Re: Health warning:

> I don't recommend doing so because it's very insecure.
Sir, nothing is really secure.
There is at least one person with full privileges.

On Tue, 17 Dec 2019, 21:41 Stephen Frost, <sfrost(at)snowman(dot)net> wrote:

> Greetings,
>
> * Zahid Rahman (zahidr1000(at)gmail(dot)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
>