Re: Health warning:

--000000000000e8831a0599ed4985
Content-Type: text/plain; charset="UTF-8"

Next time I have to do a fresh install Ill try your way  first.
If that doesn't work then Ill do it my way because that works.


On Tue, 17 Dec 2019 at 21:41, Stephen Frost <[email protected]> wrote:

> Greetings,
>
> * Zahid Rahman ([email protected]) 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
>

--000000000000e8831a0599ed4985
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Next time I have to do a fresh install Ill try your w=
ay=C2=A0 first.</div><div>If that doesn&#39;t work then Ill do it my way be=
cause that works.<br></div><div><br></div></div><br><div class=3D"gmail_quo=
te"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, 17 Dec 2019 at 21:41, Ste=
phen Frost &lt;<a href=3D"mailto:[email protected]">[email protected]</a>=
&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px =
0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Gree=
tings,<br>
<br>
* Zahid Rahman (<a href=3D"mailto:[email protected]" target=3D"_blank">z=
[email protected]</a>) wrote:<br>
&gt; You have to set to trust from peer the first time you download and ins=
tall<br>
&gt; postgres.<br>
&gt; Because there is no default password.<br>
&gt; After you create a password.<br>
&gt; Then you can reset from trust.<br>
<br>
No- peer auth allows the &quot;postgres&quot; unix user, which is the user =
that<br>
the database runs as, to connect.<br>
<br>
To do so, you would first &quot;sudo su - postgres&quot; and then run psql,=
 and<br>
then you&#39;ll be able to connect without any need for a password.=C2=A0 T=
his is<br>
exactly what &#39;peer&#39; auth is for and how it works and it&#39;s quite=
 secure.<br>
<br>
There&#39;s no need to ever change the authentication method to be &#39;tru=
st&#39;<br>
and I don&#39;t recommend doing so because it&#39;s very insecure.<br>
<br>
&gt; You also have to reboot your computer each time you change<br>
&gt; etc/postgresql/12/main/pg_hba.conf.<br>
&gt; at the very least restart the database.<br>
<br>
You don&#39;t have to restart the computer or the database when changes are=
<br>
made to pg_hba.conf- you just need to issue a &quot;reload&quot;.<br>
<br>
Thanks,<br>
<br>
Stephen<br>
</blockquote></div>

--000000000000e8831a0599ed4985--