Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uOiom-009oR1-I0 for pgadmin-support@arkaria.postgresql.org; Mon, 09 Jun 2025 20:10:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uOiok-00CpmW-Lk for pgadmin-support@arkaria.postgresql.org; Mon, 09 Jun 2025 20:10:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from <01020197564ee270-8dcdf3c5-bcbb-4261-8bfc-723d6eae99c1-000000@mail.rodonnell.ie>) id 1uOinT-00Cnow-39 for pgadmin-support@lists.postgresql.org; Mon, 09 Jun 2025 20:08:43 +0000 Received: from a7-13.smtp-out.eu-west-1.amazonses.com ([54.240.7.13]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from <01020197564ee270-8dcdf3c5-bcbb-4261-8bfc-723d6eae99c1-000000@mail.rodonnell.ie>) id 1uOin7-0016xI-2h for pgadmin-support@lists.postgresql.org; Mon, 09 Jun 2025 20:08:43 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/simple; s=dv7fx26oobputowqxkzhnujragfvk7eg; d=rodonnell.ie; t=1749499700; h=Content-Type:Message-ID:Date:MIME-Version:Subject:To:Cc:References:From:In-Reply-To; bh=WxMtSkxuDxZ0vdEnKbLhB5NwpAgOCG0LR9Z4jcWsyh0=; b=qHyLyKaR+U2Oc7JWE1hksSNVURpEZs8bBtZbwslhRbuURCD+PnGIGFlNBQV26mbB RyKUfDsvyVJfaY/BM6Xly6JRztZRlwgF8FR3Q9qTWA7PqxvUvNsAJTAVhuyob2pRX/V 4XyjRsXejU7CPlHyPyvFcX2Wpzmt1c2UWhxzbPEOrcEgoil4Pr0hjjYDd2OzlIldJTN HMscmcoj6Cjc6+6lqV/CUuCbeJDpr9PIVL5Sg4e3o0JuW1QvYdf8jw9JVwilUfCDHcV PvcosEbasOVTEYaAEp7DkfxPelSP+rWKUoJzHMFovCIU+D+j+D31+VORHBrHAe3pxlS TG7PagWqYg== DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/simple; s=ihchhvubuqgjsxyuhssfvqohv7z3u4hn; d=amazonses.com; t=1749499700; h=Content-Type:Message-ID:Date:MIME-Version:Subject:To:Cc:References:From:In-Reply-To:Feedback-ID; bh=WxMtSkxuDxZ0vdEnKbLhB5NwpAgOCG0LR9Z4jcWsyh0=; b=Fp35p3JOkr3fF1cagdI6A7zRoD/iS8/razI6d1voJDZxhIS2TLv35mvTJSMoNuzo iWrc3T7XhOx4Il++JiWmZ6r6Quwj43ShNwL1/uaIVzFWYJDQXCuWVTvHr0jCmE+pB3U niDaCSDQoyH4Ije6WYreRkKTcpNA0Oigt0y9VdX8= Content-Type: multipart/alternative; boundary="------------nxXMpXfCnhM0QT9Yr8bhVvEm" Message-ID: <01020197564ee270-8dcdf3c5-bcbb-4261-8bfc-723d6eae99c1-000000@eu-west-1.amazonses.com> Date: Mon, 9 Jun 2025 20:08:19 +0000 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Unable to access local server To: B A Cc: pgadmin-support@lists.postgresql.org References: <0102019754152b7a-2057ce09-cafc-4524-8bb7-f10e1c6ce546-000000@eu-west-1.amazonses.com> Content-Language: en-GB, de-DE From: Ray O'Donnell In-Reply-To: Feedback-ID: ::1.eu-west-1.Bw1eu/7Uepg3xcsiFBL71JJRCh2A2yTFrgBhhiulXmU=:AmazonSES X-SES-Outgoing: 2025.06.09-54.240.7.13 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. --------------nxXMpXfCnhM0QT9Yr8bhVvEm Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 09/06/2025 20:57, B A wrote: > Hi, > > Thanks but now it's giving me the following error: > Unable to connect to server: connection failed: connection to server > at "127.0.0.1", port 5432 failed: fe_sendauth: no password supplied > > However, when I installed pgadmin4, it never asked me to set up a > password, so how can I proceed? Hi there, This is a password for PostgreSQL - or at least, the user under which you're connecting to the PostgreSQL server. When you're first adding the server to pgAdmin, there's an option to specify the password (assuming you're using password authentication, and not another mechanism - you specify that at initial-connection time too). For a server that's already listed in the tree view in pgAdmin, you can have it forget whatever password you may already have entered and saved - right-click on the server in the tree-view, and if pgAdmin has saved a password then there'll be a option, "Clear saved password". Click this, and then you can re-enter the password on next connection. HTH, Ray. > > Please advise. > > On Mon, Jun 9, 2025 at 5:46 AM Ray O'Donnell wrote: > > You want either "localhost" or 127.0.0.1 as the host. > > Ray. > > > On 9 June 2025 09:55:19 B A wrote: > >> Hi, >> >> I tried downloading and for host I put "local" (without quotes) >> and it gives this error: >> Unable to connect to server: [Errno 11001] getaddrinfo failed >> >> So I cannot use pgadmin on Windows PC. >> >> Please advise. >> >> Thanks, >> Bob > -- Raymond O'Donnell // Galway // Ireland ray@rodonnell.ie --------------nxXMpXfCnhM0QT9Yr8bhVvEm Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
On 09/06/2025 20:57, B A wrote:
Hi,

Thanks but now it's giving me the following error:
Unable to connect to server: connection failed: connection to server at "127.0.0.1", port 5432 failed: fe_sendauth: no password supplied

However, when I installed pgadmin4, it never asked me to set up a password, so how can I proceed?

Hi there,

This is a password for PostgreSQL - or at least, the user under which you're connecting to the PostgreSQL server. When you're first adding the server to pgAdmin, there's an option to specify the password (assuming you're using password authentication, and not another mechanism - you specify that at initial-connection time too).

For a server that's already listed in the tree view in pgAdmin, you can have it forget whatever password you may already have entered and saved - right-click on the server in the tree-view, and if pgAdmin has saved a password then there'll be a option, "Clear saved password". Click this, and then you can re-enter the password on next connection.

HTH,

Ray.



Please advise.

On Mon, Jun 9, 2025 at 5:46 AM Ray O'Donnell <ray@rodonnell.ie> wrote:
You want either "localhost" or 127.0.0.1 as the host.

Ray.


On 9 June 2025 09:55:19 B A <babakasadishad@gmail.com> wrote:

Hi,

I tried downloading and for host I put "local" (without quotes) and it gives this error:
Unable to connect to server: [Errno 11001] getaddrinfo failed

So I cannot use pgadmin on Windows PC.

Please advise.

Thanks,
Bob



-- 
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie
--------------nxXMpXfCnhM0QT9Yr8bhVvEm--