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

Поиск
Список
Период
Сортировка
От M Sarwar
Тема Re: Need to run pg_dump from the laptop without entering the password
Дата
Msg-id DM4PR19MB5978E1C6B689F5448A35FDBAD3D8A@DM4PR19MB5978.namprd19.prod.outlook.com
обсуждение исходный текст
Ответ на Re: Need to run pg_dump from the laptop without entering the password  (M Sarwar <sarwarmd02@outlook.com>)
Список pgsql-admin
Дерево обсуждения
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@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.

--
Born in Arizona, moved to Babylonia.

В списке pgsql-admin по дате отправления: