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 1qJfcD-0002D7-NP for pgsql-general@arkaria.postgresql.org; Wed, 12 Jul 2023 19:35:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qJfcC-0008CW-Hz for pgsql-general@arkaria.postgresql.org; Wed, 12 Jul 2023 19:35:08 +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 1qJfcC-00088N-6C for pgsql-general@lists.postgresql.org; Wed, 12 Jul 2023 19:35:08 +0000 Received: from mail.thenautilus.net ([178.162.154.203]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qJfc8-0003MM-Cs for pgsql-general@lists.postgresql.org; Wed, 12 Jul 2023 19:35:06 +0000 Received: (qmail 5196 invoked from network); 12 Jul 2023 19:35:02 -0000 Received: from unknown (HELO localhost) (dakkar@::ffff:10.111.0.42) by 0 with ESMTPA; 12 Jul 2023 19:35:02 -0000 Date: Wed, 12 Jul 2023 20:34:46 +0100 From: Gianni Ceccarelli To: pgsql-general@lists.postgresql.org Subject: Re: Reset Postgresql users password Message-ID: <20230712203446.19535e83@thenautilus.net> In-Reply-To: References: X-Mailer: Claws Mail 4.1.1git35 (GTK 3.24.37; x86_64-pc-linux-gnu) MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2023-07-12 Johnathan Tiamoh wrote: > I wish to find out if there is a way to reset all users in Postgresql > password to the same password at once. I guess you could update the `pg_catalog.pg_authid` table, see https://www.postgresql.org/docs/15/catalog-pg-authid.html -- Dakkar - GPG public key fingerprint = A071 E618 DD2C 5901 9574 6FE2 40EA 9883 7519 3F88 key id = 0x75193F88