public inbox for [email protected]
help / color / mirror / Atom feedFrom: Stephen Frost <[email protected]>
To: Zahid Rahman <[email protected]>
Cc: [email protected]
Subject: Re: Health warning:
Date: Tue, 17 Dec 2019 16:41:54 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAPGSW3THojtnEYy3jPbsS0CsFy=81K5=wHekjqMWMr1YijHNGg@mail.gmail.com>
References: <SY4P282MB11318377CCCAB2878AA32A1DB1500@SY4P282MB1131.AUSP282.PROD.OUTLOOK.COM>
<CALL-XeOWFk_zSpJkY53jN6XpZsBxLPsS5eMSZeM1zw7bzRco7A@mail.gmail.com>
<CAPGSW3RRh3iFaRPpBgqrte3JcK2VPej7QxyKJw=nu4wt_VmAfA@mail.gmail.com>
<CALL-XeP_XoznM1eXptNX+TOdSNYDsdY3XkYUs6XkrGhshvTyEA@mail.gmail.com>
<CAPGSW3TC_N6YQfe9NBP737fiHUeHuSY1u2rUtexY6YMJ02mkDw@mail.gmail.com>
<CALL-XeMG3tMM7cNVm_72PoRUuweZn+crP9rzjKwsEBgM8yROWQ@mail.gmail.com>
<CAPGSW3QNsaF38oBHs4f=Jd6GfY-0p6Dz5Rwjj0nt17=sV2J_iQ@mail.gmail.com>
<CAPGSW3QYUPXP9Zj=5x3WjeY6WKmOcjmAxU013XOMWX1-bhDQYQ@mail.gmail.com>
<[email protected]>
<CAPGSW3THojtnEYy3jPbsS0CsFy=81K5=wHekjqMWMr1YijHNGg@mail.gmail.com>
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
Attachments:
[application/pgp-signature] signature.asc (819B, ../[email protected]/2-signature.asc)
download
view thread (29+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Health warning:
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox