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

[M Sarwar <sarwarmd02@xxxxxxxxxxx>]

Hello,

I appreciate the responses from Ron and Ramana.

Now Error Message:- "pg_dump: error: connection to database "ngbrpesb" failed: fe_sendauth: no password supplied"

 

File names attempted:-

1. C:\Users\N28068\AppData\Roaming\pgAdmin\pgpass.conf
   
2. C:\Users\N28068\AppData\Roaming\pgAdmin\.pgpass
   
3. C:\Users\N28068\AppData\Roaming\postgresql\pgpass.conf
   
4. C:\Users\N28068\AppData\Roaming\postgresql\.pgpass
   

A.1) On my laptop initially, I had only subdirectory called   C:\Users\N28068\AppData\Roaming\pgAdmin and no sub directory called 'postgresql'.

A.2) I tried using the subdirectory pgAdmin first when pg_dump did not have success, I created sub directory postgresql under C:\Users\N28068\AppData\Roaming\

B.3) Initially, I tried to create the file pgpass.conf.

B.4) When I did not have success in the step B.3, I also tried to create a file by name .pgpass as per some of the documentation. In both cases B.3 and B.4, I am getting the same error message as stated above.

I created .pgpass file in C:\Users\N28068\AppData\Roaming\postgresql but when I run pg_dump command I got the same above error message.

I also tried using the file name pgpass.conf from the local directory,  C:\Users\N28068\AppData\Roaming\postgresql and I am getting the same error message.

When pgpass.conf file did not run successfully, I changed the file name .pgpass and tried the same again.

 

Thanks,

Sarwar

---

From: Ron <ronljohnsonjr@xxxxxxxxx>
Sent: Saturday, October 21, 2023 11:18 AM
To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: Need to run pg_dump from the laptop without entering the password

 

On 10/21/23 10:07, M Sarwar wrote:

Hello,

Environment:-

Database Postgres 13.7 is running from AWS RDS.

I am trying to run pg_dump from my Windows laptop which has got pgAdmin installed on it.

When I installed pgAdmin, it has pg_dump on the client side.

Now I am trying to make backup using pg_dump from my laptop. I am trying to run as Windows job from the laptop.

I need to schedule the job without entering the password.

I am going to look into scheduling job thru aws which is later and not right now.

Can you please help me in scheduling thru Windows from my laptop without entering the password?

I am having issues with entering the password while running this job.

https://www.postgresql.org/docs/15/libpq-pgpass.html

The file .pgpass in a user's home directory can contain passwords to be used if the connection requires a password (and no password has been specified otherwise). On Microsoft Windows the file is named %APPDATA%\postgresql\pgpass.conf (where %APPDATA% refers to the Application Data subdirectory in the user's profile).

--
Born in Arizona, moved to Babylonia.