pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHost name in .pgpass
2+ messages / 1 participants
[nested] [flat]
* Host name in .pgpass
@ 2023-03-29 14:16 Ron <ronljohnsonjr@gmail.com>
2023-03-29 14:28 ` Re: Host name in .pgpass Ron <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Ron @ 2023-03-29 14:16 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
https://www.postgresql.org/docs/current/libpq-pgpass.html doesn't mention
anything about host name case sensitivity, but my experience is that the the
field *IS* case sensitive.
Am I missing some other bit of documentation?
$ psql --host=FISPTAPPGS302a.itocservices.com -c "\q"
$ psql --host=FISPTAPPGS302A.itocservices.com -c "\q"
Password for user postgres:
psql: error: fe_sendauth: no password supplied
--
Born in Arizona, moved to Babylonia.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Host name in .pgpass
2023-03-29 14:16 Host name in .pgpass Ron <ronljohnsonjr@gmail.com>
@ 2023-03-29 14:28 ` Ron <ronljohnsonjr@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Ron @ 2023-03-29 14:28 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
/etc/hosts is not case sensitive, and neither is the value passed via
"--hosts=".
Thus, it is completely reasonable that .pgpass be case-insensitive.
On 3/29/23 09:24, c Campo wrote:
> Since PostgreSQL runs on UNIX/LINUX/Win systems, which ARE case sensitive
> operating systems, and since PostgreSQL database table field names ARE
> case sensitive, then I would assume that case sensitivity would carry over
> to the .pgpass table.
>> On March 29, 2023 10:16 AM Ron <ronljohnsonjr@gmail.com> wrote:
>>
>>
>>
>> https://www.postgresql.org/docs/current/libpq-pgpass.html doesn't mention
>> anything about host name case sensitivity, but my experience is that the
>> the field *IS* case sensitive.
>>
>> Am I missing some other bit of documentation?
>>
>> $ psql --host=FISPTAPPGS302a.itocservices.com -c "\q"
>>
>> $ psql --host=FISPTAPPGS302A.itocservices.com -c "\q"
>> Password for user postgres:
>> psql: error: fe_sendauth: no password supplied
>>
>>
>>
>> --
>> Born in Arizona, moved to Babylonia.
--
Born in Arizona, moved to Babylonia.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-03-29 14:28 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-03-29 14:16 Host name in .pgpass Ron <ronljohnsonjr@gmail.com>
2023-03-29 14:28 ` Ron <ronljohnsonjr@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox