Unable to connect to server: PgAdmin 4

Question

I have installed pgadmin on a new windows laptop and when I try to create a new server, it says:

When I try to run my django app in pycharm it is giving me the same error

could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 5432?

How to solve this ?

Answer 1

You may need to installing PostgreSQL Server first.

---

You can verify if the folder is created in the below folder, C:\Program Files\PostgreSQL

Answer 2

You can configurate your newly created server to run on localhost and port 5432.

First select the “Connection” tab in the “Create-Server” window. Then, configure the connection as follows:

• Enter your server’s IP address in the “Hostname/ Address” field. Default is localhost.

• Specify the “Port” as “5432”.

• Enter the name of the database in the “Database Maintenance” field.

• Enter your username as postgres and password (use the same password you used when previously configuring the server to accept remote connections) for the database.

• Click “Save” to apply the configuration.

NOTE You first have to install PostgreSQL on your machine and run it or run it with docker.

Answer 3

In case someone is running the pgadmin-4 in docker, and not able to connect to postgres container, like me. The solution is to first find the ip at which the docker image is running.

Step-1, make sure the postgres container is running.

Step-2 write command- PS C:\docker> docker ps Should result as below or similar,

Step3- in order to find the ip address running the postgres use part of container ID and analyze like below command

PS C:\docker> docker inspect fc834 Note: Here I have only used part of container id that is fc834..

This should result the following or similar, Step4-

Use this ip address in the connection as below with your correct username and password

Answer 4

I had the same issue. But in my case I had installed pgadmin in version 9. But also installed version 12 at the same time.

When I now uninstalled version 9, the port was already set in the config of version 12 and not given free.

So my solution was to change the port of version 12 in the postgresql.conf file. Or even simplier, change the port in the server creation from 5432 to 5433. Now you are able to create a server again.