agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Rossi, Maria <maria.rossi@jackson.com>
To: 'pgsql-sql@lists.postgresql.org' <pgsql-sql@lists.postgresql.org>
To: 'pgsql-novice@lists.postgresql.org' <pgsql-novice@lists.postgresql.org>
Subject: md5 and trust and pg_hba.conf
Date: Mon, 10 Sep 2018 14:45:38 +0000
Message-ID: <daa1d04cccf6417e83a3f52cd8ab1781@DC03PXMBP003.jacksonnational.com> (raw)
Hi,
Question on pg_hba.conf. I have these entries:
host all psgdba localhost trust
host all psgdba 127.0.0.1/32 trust
host all gd07 localhost trust
host all gd07 127.0.0.1/32 trust
Command to logon to Postgres:
/usr/pgsql-9.3/bin/psql -d postgres
If I am logged on 'gd07' at the server , it lets me log-on to Postgres without prompting for password
If I am logged on as 'psgdba', it prompts for password.
As you can see, both have 'trust', but 'gd07' is the instance owner.
Why does 'psgdba' prompts? What I am missing?
Your help would be much appreciated.
Thanks.
Maria
view thread (8+ messages) latest in thread
Message-ID: <daa1d04cccf6417e83a3f52cd8ab1781@DC03PXMBP003.jacksonnational.com>
Permalink: ../daa1d04cccf6417e83a3f52cd8ab1781@DC03PXMBP003.jacksonnational.com/
Also on: postgresql.org/message-id/daa1d04cccf6417e83a3f52cd8ab1781@DC03PXMBP003.jacksonnational.com
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: pgsql-sql@postgresql.org
Cc: maria.rossi@jackson.com, pgsql-sql@lists.postgresql.org, pgsql-novice@lists.postgresql.org
Subject: Re: md5 and trust and pg_hba.conf
In-Reply-To: <daa1d04cccf6417e83a3f52cd8ab1781@DC03PXMBP003.jacksonnational.com>
* 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