Re: Need to run pg_dump from the laptop without entering the password
От | Ron |
---|---|
Тема | Re: Need to run pg_dump from the laptop without entering the password |
Дата | |
Msg-id | 2194a8e8-f1cc-4c72-96cb-710dcd973094@gmail.com обсуждение исходный текст |
Ответ на | Need to run pg_dump from the laptop without entering the password (M Sarwar <sarwarmd02@outlook.com>) |
Ответы |
Re: Need to run pg_dump from the laptop without entering the password
|
Список | pgsql-admin |
On 10/21/23 10:07, M Sarwar wrote:
https://www.postgresql.org/docs/15/libpq-pgpass.html
The file
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.
Born in Arizona, moved to Babylonia.
В списке pgsql-admin по дате отправления: