Re: Need to run pg_dump from the laptop without entering the password - Mailing list pgsql-admin

From Erik Wienhold
Subject Re: Need to run pg_dump from the laptop without entering the password
Date
Msg-id gefvvyatbss4kfwbd4hrhacnzulrolbddol2eg26lssadbdl2s@45oifatof2b3
Whole thread Raw
In response to Re: Need to run pg_dump from the laptop without entering the password  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-admin
On 2023-10-23 01:55 +0200, Ron wrote:
> On 10/22/23 18:19, Erik Wienhold wrote:
> [snip]
> > The hostname in pgpass.conf is
> > case-sensitive (not mentioned in the docs), so it must match the exact
> > spelling as in the connection parameters.
> 
> That annoys me to. no. end.  Hostnames being lowercase here, uppercase
> there, and mixed case somewhere else and all working just fine *except*
> .pgpass regularly bites me when scripting.

I know.  Found a thread [1] of yours when searching for a reference
because I was sure that I read about that behavior somewhere.  But
apparently it's undocumented.  Here's a patch that adds a note.

[1] https://www.postgresql.org/message-id/a5b3740b-a665-7afe-052b-4382d6daf733%40gmail.com

-- 
Erik

Attachment

pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: Need to run pg_dump from the laptop without entering the password
Next
From: M Sarwar
Date:
Subject: Re: Need to run pg_dump from the laptop without entering the password