Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iSpJt-00011j-IH for pgsql-bugs@arkaria.postgresql.org; Thu, 07 Nov 2019 21:27:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iSpJs-0001sH-A5 for pgsql-bugs@arkaria.postgresql.org; Thu, 07 Nov 2019 21:27:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iSpJ5-0006YU-BD for pgsql-bugs@lists.postgresql.org; Thu, 07 Nov 2019 21:27:07 +0000 Received: from mail-lf1-x143.google.com ([2a00:1450:4864:20::143]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iSpJ2-0004Vc-Fg for pgsql-bugs@lists.postgresql.org; Thu, 07 Nov 2019 21:27:06 +0000 Received: by mail-lf1-x143.google.com with SMTP id v4so2726094lfd.11 for ; Thu, 07 Nov 2019 13:27:04 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=IkG4m+RlY2krUrm53XAHQnUIkPykz1iZN1+7TIHibJg=; b=CTnMYXY6Qp/19WhXhUMQMurE0HPFbpqHpx+2G/qhBg4t+SgvZKuNZEfsA9WFPWBS1W js2hG/rP8p3YJ3ZPMkxdAurrZIWESB1nDSeWbEM4SF3RKbz8MywZ4ETroiIB0v52vMDy e1fNLGxCoSCGLr+m2xvhQy4rr7On1oa4ZfIkokCw95R5Y1fnx7FCbEQcW6nVd3jjTGNO PzD9OKKlsu9RVCaPZEhTGBmWoTthEOJHEcCyNo/ZytSMf9uCoQTWa2gukj2C54hljHNr ncBsgfOYF/c/wYpmjBVlLK3nxHE5x3ZcU25tbedZ0d3nQ/I8/ExGAXJvSIZRCKoy+Jay QDbQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:subject:message-id:references :mime-version:content-disposition:in-reply-to; bh=IkG4m+RlY2krUrm53XAHQnUIkPykz1iZN1+7TIHibJg=; b=Nlc43Cth5VOlD+37RbNeNcMldzrzuQm0zKTHdsxbzxHh+7qarpnV1ApDaRU+dPTjws 1NQ3AmRrAKBjNjJNLbNh9ZNdedkaUc3e4aWyzLwL3ikCJ5fpmKF7eaWZiSSJyjqqMG3A JUzPPNkmVa0hhc7+cNC+8+sY9MfDJo8/xDVu2C8iP3J3mwb7cqZvcraomrxfxlwi9psd noq6FxZzUPgpaGrD4wSoe0YLPfb8nP2VJVYSAl8S+KcZhpvT7U3lnB1nWMdk5Q+KaNhD X8IIDSYb+WuT654I67In7HIKAUoQEzsgET80kQgzSOD4c7Mu4Uy6QKOLjSeg27pg1mrY qKtw== X-Gm-Message-State: APjAAAX85boBau2mHHEC9OfwsJMUzc8w8UNDiAztK2/Hsw9LVXvbV5qi KbLT2ZKt10Z2xegjvDAH620dgA== X-Google-Smtp-Source: APXvYqz3sxoSJcfdq3ohnqByIHbF2r5p8LjisVPBlqRj+bJO7jSL9OMSppCYEtUvo7foxR3wK2AH3Q== X-Received: by 2002:a19:c7d3:: with SMTP id x202mr3890885lff.127.1573162023329; Thu, 07 Nov 2019 13:27:03 -0800 (PST) Received: from localhost ([217.8.174.100]) by smtp.gmail.com with ESMTPSA id v15sm3209854lfd.36.2019.11.07.13.26.54 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 07 Nov 2019 13:26:54 -0800 (PST) Date: Thu, 7 Nov 2019 22:26:52 +0100 From: Tomas Vondra To: alnaica@hotmail.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #16100: Cannot access to the sever with the password Message-ID: <20191107212652.7dnut2kiouy2u2xp@development> References: <16100-e547e6dbe8a58658@postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Disposition: inline In-Reply-To: <16100-e547e6dbe8a58658@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Thu, Nov 07, 2019 at 06:03:53PM +0000, PG Bug reporting form wrote: >The following bug has been logged on the website: > >Bug reference: 16100 >Logged by: Al Aufustave >Email address: alnaica@hotmail.com >PostgreSQL version: 12.0 >Operating system: FATAL: password authentication failed for user "p >Description: > >Hi, >I've downloaded PostgreSQL 12.0 and PgAdmin 4-4.14 recently on my >MacBookPro12,1 since I've some issues to connect the server with my >password. I've tried many times to uninstall and reinstall them and the >problem is not solved. The system doesn't recognise the password even if I >reset the password several times. I have a MacBook Pro with macOS Catalina >10.15 and Python 2.7.16. I need to use the PgAdmin to work on SQL code for >my courses and I am not able to do it. > >Could you please help me solve this issue? > >Please let me know if you need additional information. > >Looking forward to hearing from you! > Reset the password how? Are you trying to connect to the database using the macos user account? I don't think that works - PostgreSQL has a separate list of users and authentication. Maybe try user "postgres" with no password, or something like that. regards -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services