From: | Stephen Frost <sfrost(at)snowman(dot)net> |
---|---|
To: | Zahid Rahman <zahidr1000(at)gmail(dot)com> |
Cc: | pgsql-novice(at)lists(dot)postgresql(dot)org |
Subject: | Re: Health warning: |
Date: | 2019-12-17 21:41:54 |
Message-ID: | 20191217214154.GP3195@tamriel.snowman.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2019-12-17 21:43:18 | Re: Health warning: |
Previous Message | Zahid Rahman | 2019-12-17 21:39:13 | Re: Health warning: |