Re: Health warning:

--Pes7OZCOzfZhFQfq
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

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

--Pes7OZCOzfZhFQfq
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBCgAGBQJd+UuiAAoJEO1sijiDR2RVYiwQAI0cXi0pdbG6jK4c69HpOIe7
4VpWuve2Py3dC5Wr4JTZL6vUpuqO+xJfjaZDnFWn4oGf+yXyISzHkw6XSPVb4V5G
GAySStHPIcevGCQxmslKyKaebtjrx4GfYf86fwQkjfxyxDjdkxgMfaiT39/JfiY/
lxQtnHGUfXJDcaeqqRiNLyadBMAM7vduU3Ti5xSzr0/87jrZRZdzmWjcB3Sd/SRX
01i++wvPjjnKqJqAbeZj4ZhJXJoIVw/gT8W0PaXJ1vt80hN90zb3bXGnxx1L0+dd
Q7wTQ588GeH/SW91yjUy0rjohDuIn/hD9eZKoNQy2rifL1ub6S4P+Dvj+goTbiwE
32iTc6kw1Q9NakoxwtzyigufpmFBJTNAJa2eM7Od1A6BZW6ym4RuoiXdqxByc2Ez
Q1AbDmnkiMRwU6pOqXF5KxhUuOKnTDKUdUS4MXQLl3DfDiVwSdiPxNo1j0G3CC53
yyJ94QvmGrQvKW2a+yERzugaDVH7MySfR/uGkri2in/q40N58yfGqmis4GKGzlZg
jaxLCqvUh8Txa6gv6YwGcl6C1KNsKrNR+VQHPc8ugJgttrSdAQMIezLTiC5dkP/h
aQPTtCG+CpLYJm37NdBgBFDCsZJhLrkPBpb9arQ4MrMi7xqqE8YDuEnw0JA1/GtK
vJ2S08+NBR5dApoleTBQ
=XCbS
-----END PGP SIGNATURE-----

--Pes7OZCOzfZhFQfq--