Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1quDkS-00H7Xx-Sl for pgsql-admin@arkaria.postgresql.org; Sat, 21 Oct 2023 15:18:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1quDkQ-003BEe-MB for pgsql-admin@arkaria.postgresql.org; Sat, 21 Oct 2023 15:18:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1quDkQ-003BDE-7H for pgsql-admin@lists.postgresql.org; Sat, 21 Oct 2023 15:18:43 +0000 Received: from mail-yb1-xb2b.google.com ([2607:f8b0:4864:20::b2b]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1quDkJ-001uqP-4I for pgsql-admin@lists.postgresql.org; Sat, 21 Oct 2023 15:18:42 +0000 Received: by mail-yb1-xb2b.google.com with SMTP id 3f1490d57ef6-d849df4f1ffso1830746276.0 for ; Sat, 21 Oct 2023 08:18:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1697901513; x=1698506313; darn=lists.postgresql.org; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=f1/fMhXl0tNROGRgYrSPFIkL0u2z5Wpqy73BSt8KMmc=; b=bVx1oXYohWSOUDfgCAVmdi8ioZbE+zS1k5iYLpsEiD1rqzy/lBfZX6IF/9nQLxNcPV 9GAOUZQ9vUJCD0/bk/d9A/IXynnZ4BfyDTmjfEtAOkfF6spXsdIVOzAHa3ovuhSL/gC3 KsixyOymMSvDIfqYu43sEhxXfbbntxIYrZPJ1YrGieLhqC1hDpPSd9pFY5kR5azEmpri hhuZPe7037wuOhG2Z0hKAk7EpXIfxYQf0yDsgl0xS7d0B5/XikhRnlTG/0MX6gvgKK/b znVEbbniZzLwuFdPxyf6hQ3Rwn/6nadJWjA6UJJFfQGWH2PYs43bjBAkvXaTImNVF1Ms 9s/Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1697901513; x=1698506313; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=f1/fMhXl0tNROGRgYrSPFIkL0u2z5Wpqy73BSt8KMmc=; b=moOhJDi7x8psW26hNhmCgiMzc//mpJHglSsH3QZuAGYAY7740QWHDi5n8M7eXSazv7 9DpzeJGVGD2swra2JGSeVXTVMA8yq7WbHh0Oe65tiuEHu8APtstOIT2HTfblfm8BiS9S UwZgeF3kYV30yyfb0T9I+hRPqFrDGFzI6WrjWtWWNmRYm4+nO3k2C0kwWui77grM7QQR Tui2yjCq8EmqkgjCuej12FNKAfGN9KNEhA/vJoTIY0aS0sMElVp0ljaKrJCDJvTs1VGB KsYw52NssHamUyI2/qgfLaRSFr6JZOGf371z7Daok+boR3JW6zzMluWl0hptjOweT708 Hz6g== X-Gm-Message-State: AOJu0YwdjENpW6QygNDB+Oy0qQpiI83mYDxZdSaHuTUWBPY9zbA73lOq ud8VsYWdvJLugEt+86rD7y19ZJFsypI= X-Google-Smtp-Source: AGHT+IEcXngHojN+oe/ZGZ9SwFEVyz5aEhz3OA3k4jF/r6HsUhWunl4XoRde81wsuF+Nk+05te40BQ== X-Received: by 2002:a25:8f8a:0:b0:d9a:41a0:54be with SMTP id u10-20020a258f8a000000b00d9a41a054bemr4511785ybl.25.1697901512972; Sat, 21 Oct 2023 08:18:32 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:7848:b9a:8948:8624? ([2600:1700:bd2c:b810:7848:b9a:8948:8624]) by smtp.googlemail.com with ESMTPSA id k142-20020a252494000000b00d9cb47932a0sm1346178ybk.25.2023.10.21.08.18.32 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sat, 21 Oct 2023 08:18:32 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------39hx0g0Xgs0p62fIz00pdmxr" Message-ID: <2194a8e8-f1cc-4c72-96cb-710dcd973094@gmail.com> Date: Sat, 21 Oct 2023 10:18:32 -0500 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Need to run pg_dump from the laptop without entering the password Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: From: Ron In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------39hx0g0Xgs0p62fIz00pdmxr Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit 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. --------------39hx0g0Xgs0p62fIz00pdmxr Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit 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.
--------------39hx0g0Xgs0p62fIz00pdmxr--