From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Need to run pg_dump from the laptop without entering the password
Date: Sat, 21 Oct 2023 10:18:32 -0500
Message-ID: <2194a8e8-f1cc-4c72-96cb-710dcd973094@gmail.com> (raw)
In-Reply-To: <DM4PR19MB59780DA57A7F16460518F146D3DAA@DM4PR19MB5978.namprd19.prod.outlook.com>
References: <DM4PR19MB59780DA57A7F16460518F146D3DAA@DM4PR19MB5978.namprd19.prod.outlook.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Need to run pg_dump from the laptop without entering the password
In-Reply-To: <2194a8e8-f1cc-4c72-96cb-710dcd973094@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox