Home > mailing lists

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

From	M Sarwar
Subject	Need to run pg_dump from the laptop without entering the password
Date	October 21, 2023 15:07:01
Msg-id	DM4PR19MB59780DA57A7F16460518F146D3DAA@DM4PR19MB5978.namprd19.prod.outlook.com Whole thread Raw
Responses	Re: Need to run pg_dump from the laptop without entering the password Re: Need to run pg_dump from the laptop without entering the password
List	pgsql-admin

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.

Thanks,

Sarwar

From: M Sarwar
Date: 20 October 2023, 14:57:32
Subject: Re: User/Roles, Owner, and privileges migration strategy

From: Ron
Date: 21 October 2023, 15:18:32
Subject: Re: Need to run pg_dump from the laptop without entering the password