Re: Health warning:

--0000000000006d7e670599ed38f4
Content-Type: text/plain; charset="UTF-8"

On Tue, Dec 17, 2019 at 2:39 PM 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.
>

If you have sufficient access to do this you can just login using the
existing peer connection and change the password.  No configuration file
changes are required nor recommended.

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.
>

Hardly.  Reloading configuration files on the fly is a thing.  The
documentation describes how to do it.
David J.

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

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Tue, Dec 17, 2019 at 2:39 PM Zahid Rahman &lt;<a href=
=3D"mailto:[email protected]">[email protected]</a>&gt; wrote:</span>=
<br></div></div><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote=
" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);=
padding-left:1ex"><div dir=3D"auto">You have to set to trust from peer the=
=C2=A0first time you download and install postgres.<div dir=3D"auto"><div d=
ir=3D"auto">Because there is no default password.<br></div><div dir=3D"auto=
"><div dir=3D"auto" style=3D"font-family:sans-serif">After you create a pas=
sword.</div><div dir=3D"auto" style=3D"font-family:sans-serif">Then you can=
 reset from trust.</div></div></div></div></blockquote><div><br></div><div>=
<div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-seri=
f">If you have sufficient access to do this you can just login using the ex=
isting peer connection and change the password.=C2=A0 No configuration file=
 changes are required nor recommended.</div></div><div><br></div><blockquot=
e class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px s=
olid rgb(204,204,204);padding-left:1ex"><div dir=3D"auto"><div dir=3D"auto"=
><div dir=3D"auto">You also have to reboot=C2=A0your computer each time you=
 change=C2=A0<span style=3D"font-family:sans-serif;font-size:12.8px">etc/po=
stgresql/12/main/pg_hba</span><span style=3D"font-family:sans-serif;font-si=
ze:12.8px">.conf.</span><span style=3D"font-family:arial,helvetica,sans-ser=
if"></span></div></div></div></blockquote><blockquote class=3D"gmail_quote"=
 style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);p=
adding-left:1ex"><div dir=3D"auto"><div dir=3D"auto"><div dir=3D"auto">at t=
he very least restart the database.</div></div></div></blockquote><div><br>=
</div><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,san=
s-serif">Hardly.=C2=A0 Reloading configuration files on the fly is a thing.=
=C2=A0 The documentation describes how to do it.</div><div class=3D"gmail_d=
efault" style=3D"font-family:arial,helvetica,sans-serif"></div><div class=
=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">David J=
.</div><div class=3D"gmail_default" style=3D"font-family:arial,helvetica,sa=
ns-serif"><br></div></div></div>

--0000000000006d7e670599ed38f4--