I just corrected the file name from .pgpass to pgpass.cong.
While invoking pg_dump, I just added user name. Earlier, I did not give user name by thinking that it will pick up from pgpass.conf.
Thank you so much!
Sarwar
From: M Sarwar <sarwarmd02@outlook.com> Sent: Sunday, October 22, 2023 9:30 PM To: Ron <ronljohnsonjr@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org> Subject: Re: Need to run pg_dump from the laptop without entering the password
Hi Ron,
Yes, I have verified the host naming convention.
It is a RDS endpoint.
I see that host naming convention followed correct. Case sensitivity is not an issue.
Thanks,
Sarwar
From: Ron <ronljohnsonjr@gmail.com> Sent: Sunday, October 22, 2023 7:55 PM To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org> Subject: Re: Need to run pg_dump from the laptop without entering the password
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.