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 ) id 1nk0bL-00061l-9P for pgsql-sql@arkaria.postgresql.org; Thu, 28 Apr 2022 09:38:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nk0bK-00089u-1G for pgsql-sql@arkaria.postgresql.org; Thu, 28 Apr 2022 09:38:18 +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 ) id 1nk0bJ-00089k-JL for pgsql-sql@lists.postgresql.org; Thu, 28 Apr 2022 09:38:17 +0000 Received: from mout.gmx.net ([212.227.17.21]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nk0bF-0003xa-Ix for pgsql-sql@lists.postgresql.org; Thu, 28 Apr 2022 09:38:16 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1651138690; bh=eSMGmtl00S4YjBrajjDHw+DZ1KG5Z03E+ftGuLnxHfY=; h=X-UI-Sender-Class:From:To:Cc:Subject:Date:In-Reply-To:References; b=fmQcZhiz93qq4eL4NXOE79o3lx124sAzCx8qntcExouFzawujy3dq4hF31WqjTVwh aHbyqdq/Dg1Q2+LIcZKAT5JgrODMwhAJXf4W4DOPpU13qNeH55JVNrcoft2fDV6o5x 7FOM5XnZaAg+5lgUC+ANXeR9YEbWT+YiVxnHZGaI= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from [217.91.207.107] ([217.91.207.107]) by web-mail.gmx.net (3c-app-gmx-bap15.server.lan [172.19.172.85]) (via HTTP); Thu, 28 Apr 2022 11:38:10 +0200 MIME-Version: 1.0 Message-ID: From: Karsten Hilbert To: Shaozhong SHI Cc: pgsql-sql Subject: Aw: How to use password in psql command line? Content-Type: text/plain; charset=UTF-8 Date: Thu, 28 Apr 2022 11:38:10 +0200 Importance: normal Sensitivity: Normal In-Reply-To: References: Content-Transfer-Encoding: quoted-printable X-UI-Message-Type: mail X-Priority: 3 X-Provags-ID: V03:K1:bTggMz6SlQ9Ts60Z8YfryROv8K6gt/D6wWcw8TG20tqq23gLQG3N0XxaNgl5y4ns6tJzJ fLNbX4/0ZuNiQWFNFl/ZnyVw+POXGI89rJiv5tYCTL4QSQGB3GbzufNaP2CtWVkYgASu43AUfdFM rTv/Lb0FkWXG4krur7ID15FXeqwXmJG1E+QWxErJA82ffehc+xNcIa1ZHekMAzxkmAB+spZtp4U0 W8tY2/QuYcEXujF27Q1xDI2pP5W4vocFDOLT2O6bK1KN9rC8CNRs0bZYG0d91zxZaFzzGBK08HE2 Uc= X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:7lHDVu3YPFU=:aV2Vkwyp9Qzy6OjdpQkGRg QEHEG3quKRc6TdVH66C/6eCoiF7loxYy7h0E3cSNbYgg8DBwlb5g35M0twfUryJGe5TOdmXzR JFNjRxSUUkgkineHIpi9fsOlcNfV/H8ahmxBBKElWIKPZ/47F3byXJgA5hKDM3hzRvy4hVAjf aan8/C9hDz+4ImsNVzTa8Nr1t7AAhEW2fl63Bo/9QddvkRNprGm/503kf7loBj5kNWIj5IfTO gxeXi/BRCgM+zJB3xC2LhaCxLDBxyd01uHZ0CZXnZi7Bhf/tUgy8Budn/OjIotOUtjJ0U6vv6 0v1jTKMuU9vQbYjA8xk17B1Rge/bno9Fr3FnCTLo1DLiLFn+/IHfZRnLUuLlKEpW7fBQ2w3yN C6Sj/dH0wh+dNvq+JTKLEV0Ui5B+6DyCjC7TU3hn3mGCmPVMQ5ZJH4MdtyWZ7Z6QcN5sCQ6Jl EVcCHKzcKxgF0OXI5A0ZUYxBur3if/6i8rI0BQBON6F0e0d88maRQCtc+gkUmXwAoaWQTKZWS T3Ju4ZhvQ5hsQhx8gTh0JSMNyKQ3elFiAnHUSTXllLWMKgBk5xg7+/ICytUMa/HZLSOKuebio oFsx3q7XHSvKyUOjoXfZtQ7laZs2MA4HrGDr+/L1Ms3i+/YuJQkkNJcbSrquIyes6zOdDZMS4 eZ7sC383ueeQOq7tazxtkQ10F32O4jgI+Gw/L3p6F17t1tiQFMCeTOs3vGPG5gPMpSNXqjOA/ ZMVysMNppq7r+PkL8qwh0AeYyh0VOLyEdDzQY+RtKkw3J8vv210ghwAcErBCXQIrodoZla1CZ twfn0fM List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > Running lots of postgres commands in parallel | Mark's blog (markandruth= =2Eco=2Euk)[https://markandruth=2Eco=2Euk/2016/05/26/running-lots-of-postgr= es-commands-in-parallel] >=C2=A0 > How can make this work by providing password in this command line? Your first option could be to read the manual=2E Karsten