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 1iT2NO-0004JT-M7 for pgsql-bugs@arkaria.postgresql.org; Fri, 08 Nov 2019 11:24:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iT2NN-000844-0k for pgsql-bugs@arkaria.postgresql.org; Fri, 08 Nov 2019 11:24:25 +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 1iT2NM-00083x-PN for pgsql-bugs@lists.postgresql.org; Fri, 08 Nov 2019 11:24:24 +0000 Received: from mail-lf1-x141.google.com ([2a00:1450:4864:20::141]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iT2NJ-0005f5-21 for pgsql-bugs@lists.postgresql.org; Fri, 08 Nov 2019 11:24:24 +0000 Received: by mail-lf1-x141.google.com with SMTP id y6so4195130lfj.2 for ; Fri, 08 Nov 2019 03:24:20 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:content-transfer-encoding:in-reply-to; bh=/28ehh+Wd2vTiaDz1ODTtqzGhBXeag7gA/DLkLIy5t8=; b=bI1uz8rUthOrxjt+rNaE13uDnxsp22xXqB1bLPyP6XTH1jodnBC7e8aF8jJG++eqe2 cyrjUIjP0//pfIGidbrxRK/xwlyB+i0w5LI8aD3GJ1GTkDtsZdN5XEUP2Ud9inP8hYLQ eGsREKdRj6e68i0Co2nN0e3bgYEcivQqiAPAyY/DjpYnw7fxb+KLjUD3bbsthiyjmhsi tryfJR5+DhXA+aRcbhRyPXvFWBMs+6HvUau5wGT9/K0C2MZZoFI+zb8NUDoY3rWxfZmi z3UhumXYlkLfjRHKk72ldqhxA3U5n8QB+ykUJrAUAfznDHhqX4bjIcDzTlAVGS2PUtOb Fpiw== 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:cc:subject:message-id:references :mime-version:content-disposition:content-transfer-encoding :in-reply-to; bh=/28ehh+Wd2vTiaDz1ODTtqzGhBXeag7gA/DLkLIy5t8=; b=MqCuknl8awB04h6NvhLX6gkkRdSv1xLSDRdCMMU0g0ylUuGg+to3ovZPkVLFF9yYzw pIF0VV3W3qKnYM7Y+WGOmtjFTS5/C/0r12FQcMupCkr/wHkDAGUYKiEUd4NgFBs/FQJ7 yrFAmXp40SSoPj27VHNMF0qlj6GGx6yrc3vq/rDeRdAj9IDNAE6/NL065OiZVoCVgFZr +S6HUCujKxUBPtSQ0Ilm4uYqmTgJY6CNXQ4X4HF6XfjXDOrMKghYxjgS5lXP4l6NJHFK kDIvPFQeU8GKd0RXvNHaqfzUBNqFm2V2//5migegsUd6qcIP4hhnpQ4BSrUCqk+bnbyq moqw== X-Gm-Message-State: APjAAAUExtL48uCXoCDC7ZbCside+oCKnEBg08l2avyPPjgR425De5Do BBiG4L5dNSnNMD0YpJHeqFtQNA== X-Google-Smtp-Source: APXvYqxVeqL1eVyFpTO0YsJ7FTIBNP1Vv1zee38UiT2E8uNAAfNXVjfShs3QdJ5hHIGxF6AWydKR1Q== X-Received: by 2002:a19:8889:: with SMTP id k131mr6301424lfd.113.1573212259740; Fri, 08 Nov 2019 03:24:19 -0800 (PST) Received: from localhost ([217.8.174.100]) by smtp.gmail.com with ESMTPSA id l21sm2307065lfc.62.2019.11.08.03.24.11 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 08 Nov 2019 03:24:11 -0800 (PST) Date: Fri, 8 Nov 2019 12:24:11 +0100 From: Tomas Vondra To: Alnaica Augustave Cc: "pgsql-bugs@lists.postgresql.org" Subject: Re: BUG #16100: Cannot access to the sever with the password Message-ID: <20191108112411.tme6ras4vtzh63np@development> References: <16100-e547e6dbe8a58658@postgresql.org> <20191107212652.7dnut2kiouy2u2xp@development> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Fri, Nov 08, 2019 at 10:39:47AM +0000, Alnaica Augustave wrote: >Hi, > >How can I use Postgres with no password? Could you please tell me how to do it? > See https://www.postgresql.org/docs/current/auth-trust.html But be careful, in most cases it's a bad idea. If you have more questions about this, please ask them on pgsql-general, this list is for bug reports. You have not really provided any additional information about the original issue, so we can't really help with that. FWIW it's customary here not to top post but respond inline, as it makes it easier to follow the discussion. regards >Thanks > >Regards, > >Alnaica >________________________________ >De : Tomas Vondra >Envoyé : jeudi 7 novembre 2019 21:26 >À : alnaica@hotmail.com ; pgsql-bugs@lists.postgresql.org >Objet : Re: BUG #16100: Cannot access to the sever with the password > >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 -- Tomas Vondra http://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services