Re: Health warning: - Mailing list pgsql-novice

From David G. Johnston
Subject Re: Health warning:
Date
Msg-id CAKFQuwbYAXH2WNW+vNxbwd9J0wUGezFoUmS7kUz8LrOi0kYTNg@mail.gmail.com
Whole thread Raw
In response to Re: Health warning:  (Zahid Rahman <zahidr1000@gmail.com>)
List pgsql-novice
On Tue, Dec 17, 2019 at 2:39 PM Zahid Rahman <zahidr1000@gmail.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.

pgsql-novice by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Health warning:
Next
From: Zahid Rahman
Date:
Subject: Re: Health warning: