Thread: Unable to access local server

Unable to access local server

From
B A
Date:
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

Re: Unable to access local server

From
Ray O'Donnell
Date:
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

Re: Unable to access local server

From
B A
Date:
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?

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

Re: Unable to access local server

From
Ray O'Donnell
Date:
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