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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux