Postgres Pro
Downloads
Home   >   mailing lists

Re: Need to run pg_dump from the laptop without entering the password - Mailing list pgsql-admin

From Ron
Subject Re: Need to run pg_dump from the laptop without entering the password
Date
Msg-id 2194a8e8-f1cc-4c72-96cb-710dcd973094@gmail.com
Whole thread Raw
In response to Need to run pg_dump from the laptop without entering the password  (M Sarwar <sarwarmd02@outlook.com>)
Responses Re: Need to run pg_dump from the laptop without entering the password
List pgsql-admin
Tree view
On 10/21/23 10:07, M Sarwar wrote:
P {margin-top:0;margin-bottom:0;}
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.

pgsql-admin by date:

Previous
From: M Sarwar
Date:
Subject: Need to run pg_dump from the laptop without entering the password
Next
From: ramsiddu007
Date:
Subject: Re: Need to run pg_dump from the laptop without entering the password