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 1qCMnv-0002td-LC for pgsql-general@arkaria.postgresql.org; Thu, 22 Jun 2023 16:05:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qCMnu-0003eA-Lf for pgsql-general@arkaria.postgresql.org; Thu, 22 Jun 2023 16:05:02 +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 1qCMnu-0003cv-7i for pgsql-general@lists.postgresql.org; Thu, 22 Jun 2023 16:05:02 +0000 Received: from mail-yb1-xb29.google.com ([2607:f8b0:4864:20::b29]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qCMnr-003e45-OQ for pgsql-general@lists.postgresql.org; Thu, 22 Jun 2023 16:05:01 +0000 Received: by mail-yb1-xb29.google.com with SMTP id 3f1490d57ef6-bfee66a5db6so1868160276.0 for ; Thu, 22 Jun 2023 09:04:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1687449898; x=1690041898; 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=+YZ/0zyRCIFMxmvuGirH0cppYPGKLlvxkrp7i65DUg4=; b=gV4JLRZFarAms3z1MqTwsosaa9erRp3BPde2u7Ofrj4+4zCYKy1KVM8TYgiR+IE2k1 VL1hb1pC4UZgG98d5bXY6osdE325dcOk+v9Sm0D+ilmJj+eZMsF4NU4MGx7/ycc/4xbO 6o0EXDjx67qHUAFgT+kAxyoxGWOdBwZkJJe8rMkvzLkx2DETmxzU5OWoznWbEK8CpbF8 sXOMJdOZIyJRx3ID52tqXjF7VwYwdfFpUJa9/nlu8xiaEFqgcXlt7yYHZrPdPC05NKem nmu2BLsyjceU6Rb+SdsJTZTP7j1EuvWaI3QBkGWCGlG0m4SWs/flQug2iF/qVZrGSCmk Gdaw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1687449898; x=1690041898; 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=+YZ/0zyRCIFMxmvuGirH0cppYPGKLlvxkrp7i65DUg4=; b=KW1B6tUxxC5bBiMf2LpPg0zEdADHhB6Rd3QdnollWYRL7kg5+6dzF2TEX/v7uJtA2q EkpaFepb3yckpOdacYXUM1MCKxtOzFloc/fOIsGyRwX9KugpExJKJmh92ZEzQlGOBvBu 2G1Pjj7ENV+to4uqVY3E55uTLOWh1ZCsCts7H1S+CGVYwrKljQj5t/KRTMK1zwXWZbg4 Iqe6bNvyVySmEkPIaSXMyFY2vjazvHKtJjZvBlSKL5nMyHzc+/877Dm9KuGqK8uBBPJH Yn0sqDmMebzA+dLteQAO6T+I55la/QGl5yO7g4/inw8dKv5a3/TF8okR2M1NT5BcC1UK hfDA== X-Gm-Message-State: AC+VfDxaEaPAccCiO3b9QxFWpt0t2MtfIVPWZ8K75b2pSfcuP2RFZQOf tmUDVXrJKbgV+IEqHM8lVjlnLCbhbR8= X-Google-Smtp-Source: ACHHUZ6st84AgkQQcVtC+IY6X4dkpsy500rmlzEK2hakk3lueBX4XE3BSALQ5DXB9PzaHERTOo4wkQ== X-Received: by 2002:a25:dc4d:0:b0:bc7:de19:4dd1 with SMTP id y74-20020a25dc4d000000b00bc7de194dd1mr9937529ybe.45.1687449898299; Thu, 22 Jun 2023 09:04:58 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:1087:186d:a03b:79fd? ([2600:1700:bd2c:b810:1087:186d:a03b:79fd]) by smtp.googlemail.com with ESMTPSA id v10-20020a25c50a000000b00bcdb7d2a03bsm1623861ybe.17.2023.06.22.09.04.57 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 22 Jun 2023 09:04:58 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------pi6iAZWWTaNLHiaA0A4OP4tu" Message-ID: Date: Thu, 22 Jun 2023 11:04:57 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.11.0 Subject: Re: a really dumb password question Content-Language: en-US To: pgsql-general@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. --------------pi6iAZWWTaNLHiaA0A4OP4tu Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 6/22/23 10:05, Martin Mueller wrote: > > I have a very stupid password question. I don’t know whether a postgres > database on my Mac has a pass word or not. > > I access the database via the Aqua Data Studio frontend as the user > postgres. I don’t think I ever added a password, and on the authentication > panel the password box is empty but the Remember Password box is checked. > > However on the user panel there is a sequence of black dots for the > Password and Password confirmation. This suggests that I did set a > password, but I don’t remember what it is. > > How can I undo the damage? Is there some super user way in which I can > undo the current password and set a new one. The database itself has > several hundred tables, and I need to find a way to fix my stupid error. > > I have a dump of the database.  I don’t know whether that is subject to > the password or not. If it isn’t, I suppose I could start over from scratch. > If the database is on your Mac, then edit the pg_hba.conf file, and restart. local   all             postgres trust That should give user "postgres" access with or without a password. -- Born in Arizona, moved to Babylonia. --------------pi6iAZWWTaNLHiaA0A4OP4tu Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit On 6/22/23 10:05, Martin Mueller wrote:

I have a very stupid password question. I don’t know whether a postgres database on my Mac has a pass word or not.

 

I access the database via the Aqua Data Studio frontend as the user postgres. I don’t think I ever added a password, and on the authentication panel the password box is empty but the Remember Password box is checked.

 

However on the user panel there is a sequence of black dots for the Password and Password confirmation. This suggests that I did set a password, but I don’t remember what it is.

 

How can I undo the damage? Is there some super user way in which I can undo the current password and set a new one. The database itself has several hundred tables, and I need to find a way to fix my stupid error.

 

I have a dump of the database.  I don’t know whether that is subject to the password or not. If it isn’t, I suppose I could start over from scratch.


If the database is on your Mac, then edit the pg_hba.conf file, and restart.

local   all             postgres         trust

That should give user "postgres" access with or without a password.

--
Born in Arizona, moved to Babylonia.
--------------pi6iAZWWTaNLHiaA0A4OP4tu--