Re: Health warning:

--U0B5otXy6WXfork9
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Greetings,

* Zahid Rahman ([email protected]) wrote:
> I know a database whose name begins with O that does this.

That doesn't make it a good idea.

> the user types:
> *psql  -U postgres *
>=20
> response:
> *PROBLEM: psql: error: could not connect to server: FATAL:  Peer
> authentication failed for user "postgres"*

This indicates that the user you're connecting as doesn't have
permission to log into the database as the 'postgres' user.

> *SOLUTION: change "local  all all  peer" in file
> /etc/postgresql/12/main/pg_hba.conf *
> *to "local  all all  trust".create password then change  back.*

Using "trust" there actually means that you're able to log into the
database as any user and is terribly insecure.

Thanks,

Stephen

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

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

iQIcBAEBCgAGBQJd+UeDAAoJEO1sijiDR2RVzxwP/ipUV2ePvSIVBL0rypJLF/wB
ZpTGtWxdK+j4REQFI4WcgNEWvc+ZWUCQFn+DN8EGPhXRMqefd015ktY7G1mTdbwq
K44pG9hGPWltOgESHpCFclfewseVZWF8xejCdLKdqtuwnfQdWiyW88tOJBihlBXF
pVtBShQgPvtf1J3eo6pZ/dl6OXCgVB4/IZ+XOB7yzwIUHHr+M2vcCdnWFLod40tD
NAVPEx26ayoxgl74ZnDtcdgcL0BPQuZt5I5vcapKwOsh0mrmtHMlNYg02/OIusR/
93py0QoXUeMNul1GgAUQGYmi0fJVyrZg2yAtYoJDnNBZVhZcVg9Zj+Cvtg8HnQYw
HmF4LsR05xJKcllTSZo2EoY1e7oDbJJ02m9Romkf/qbz8X2vuN0cOqoMKB9UF2VA
35U7OJYhVya3zEUK4TnNByPGMQDfKmjxFFYvCCq+3g8YqP7OZHytRycMKEl/2kvw
VGS16v+SNl1GPnIseGZXYoirKZiBU/MZy60gVJFh6lXMfM/VfiJqWoJfUHBSm3Cq
3uTI79OZdmv9hCwE0hztO3VKBbCW0dHJoXGuhSPwY3T+y3NTQ5iFbcFlivwnxW5C
nSwp7ZRXTEWncGgzXRiDHNIqlQV5MzdlVRYydF37pzC5fz5PMzcD72srrXtg4l/B
rE1oxOOH4+uoqmC51ilX
=EVhe
-----END PGP SIGNATURE-----

--U0B5otXy6WXfork9--