Re: Need to run pg_dump from the laptop without entering the password

[M Sarwar <sarwarmd02@xxxxxxxxxxx>]

Hi Ron / Erik,

That did work.

1. I just corrected the file name from .pgpass to pgpass.cong.
   
2. 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@xxxxxxxxxxx>
Sent: Sunday, October 22, 2023 9:30 PM
To: Ron <ronljohnsonjr@xxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
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@xxxxxxxxx>
Sent: Sunday, October 22, 2023 7:55 PM
To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
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.

--
Born in Arizona, moved to Babylonia.