Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1nkKu1-0008GX-IO
	for pgsql-sql@arkaria.postgresql.org; Fri, 29 Apr 2022 07:18:57 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1nkKu0-00041Q-CR
	for pgsql-sql@arkaria.postgresql.org; Fri, 29 Apr 2022 07:18:56 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <samed@reddoc.net>)
	id 1nkKu0-0003tg-2O
	for pgsql-sql@lists.postgresql.org; Fri, 29 Apr 2022 07:18:56 +0000
Received: from forward500j.mail.yandex.net ([5.45.198.250])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <samed@reddoc.net>)
	id 1nkKtt-0005hF-4c
	for pgsql-sql@lists.postgresql.org; Fri, 29 Apr 2022 07:18:54 +0000
Received: from vla1-38e2a3439e30.qloud-c.yandex.net
 (vla1-38e2a3439e30.qloud-c.yandex.net
 [IPv6:2a02:6b8:c0d:1e04:0:640:38e2:a343])
	by forward500j.mail.yandex.net (Yandex) with ESMTP id 2C3586CB6966;
	Fri, 29 Apr 2022 10:18:45 +0300 (MSK)
Received: from 2a02:6b8:c0d:3603:0:640:5413:378e
 (2a02:6b8:c0d:3603:0:640:5413:378e [2a02:6b8:c0d:3603:0:640:5413:378e])
	by vla1-38e2a3439e30.qloud-c.yandex.net (mxback/Yandex) with HTTP id
 iI9ntFEhuKo1-IihiLNUA;
	Fri, 29 Apr 2022 10:18:44 +0300
X-Yandex-Fwd: 1
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=reddoc.net; s=mail;
 t=1651216724;
	bh=EWS/KrIEqdYtZSKYlRP1hyEvNQoso7e3I7Sh4Hfmu4A=;
	h=Message-Id:References:Date:Subject:In-Reply-To:To:From;
	b=rVMgKLISTxc/vBAcvoRHvM9cXb3xKytnD59RCel5BpKPuINGxYdoMMmsG9dWgFdDq
	 72A5TmJhLPR+7iXwljMCw7r+cW4UsnXvW0yKJ+lT0+/6ndarmXD8o4Efr+2kyuCbW5
	 TwN+8P3x9XC+MxK46H8d1+lCyU100W6LU4Wg9OHg=
Authentication-Results: vla1-38e2a3439e30.qloud-c.yandex.net;
 dkim=pass header.i=@reddoc.net
Received: by vla1-5413378edd9f.qloud-c.yandex.net with HTTP;
	Fri, 29 Apr 2022 10:18:44 +0300
From: Samed YILDIRIM <samed@reddoc.net>
To: Shaozhong SHI <shishaozhong@gmail.com>,
	pgsql-sql <pgsql-sql@lists.postgresql.org>
In-Reply-To: 
 <CA+i5JwZ_m5hsVuL8pZU6Z3647=ounaUTT2tVpR80DN6EyaBzFw@mail.gmail.com>
References: 
 <CA+i5JwZ_m5hsVuL8pZU6Z3647=ounaUTT2tVpR80DN6EyaBzFw@mail.gmail.com>
Subject: Re: How to use password in psql command line?
MIME-Version: 1.0
X-Mailer: Yamail [ http://yandex.ru ] 5.0
Date: Fri, 29 Apr 2022 10:18:44 +0300
Message-Id: <325751651216627@mail.yandex.com.tr>
Content-Transfer-Encoding: 8bit
Content-Type: text/html; charset=utf-8
List-Id: <pgsql-sql.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-sql@lists.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-sql>
Archived-At: 
 <https://www.postgresql.org/message-id/325751651216627%40mail.yandex.com.tr>
Precedence: bulk

<div><div>Hi David,</div><div> </div><div>There are two options;</div><ul><li>Password file -&gt; <a href="https://www.postgresql.org/docs/current/libpq-pgpass.html" rel="noopener noreferrer" target="_blank">https://www.postgresql.org/docs/current/libpq-pgpass.html</a></li><li>PGPASSWORD environmental variable -&gt; https://www.postgresql.org/docs/14/libpq-envars.html</li></ul></div><div> </div><div>Best regards.</div><div>Samed YILDIRIM</div><div> </div><div> </div><div> </div><div>28.04.2022, 12:11, "Shaozhong SHI" &lt;shishaozhong@gmail.com&gt;:</div><blockquote><div><div><a href="https://markandruth.co.uk/2016/05/26/running-lots-of-postgres-commands-in-parallel" rel="noopener noreferrer">Running lots of postgres commands in parallel | Mark's blog (markandruth.co.uk)</a></div><div> </div><div>How can make this work by providing password in this command line?</div><div> </div><div>Regards,</div><div> </div><div>David</div></div></blockquote>