| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Zahid Rahman <zahidr1000(at)gmail(dot)com> |
| Cc: | Stephen Frost <sfrost(at)snowman(dot)net>, pgsql-novice <pgsql-novice(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Health warning: |
| Date: | 2019-12-17 21:43:18 |
| Message-ID: | CAKFQuwbYAXH2WNW+vNxbwd9J0wUGezFoUmS7kUz8LrOi0kYTNg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Tue, Dec 17, 2019 at 2:39 PM 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.
>
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zahid Rahman | 2019-12-17 21:48:18 | Re: Health warning: |
| Previous Message | Stephen Frost | 2019-12-17 21:41:54 | Re: Health warning: |