I have installed pgadmin on a new windows laptop and when I try to create a new server, it says: <img src="https://i.stack.imgur.com/YI5l3.png" alt="enter image description here"> When I try to run my django app in pycharm it is giving me the same error <blockquote> 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? </blockquote> How to solve this ?

You may need to installing PostgreSQL Server first. <hr> You can verify if the folder is created in the below folder, C:\Program Files\PostgreSQL

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: <ul> <li> Enter your server’s IP address in the “Hostname/ Address” field. Default is localhost. </li> <li> Specify the “Port” as “5432”. </li> <li> Enter the name of the database in the “Database Maintenance” field. </li> <li> 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. </li> <li> Click “Save” to apply the configuration. </li> </ul> <blockquote> NOTE You first have to install PostgreSQL on your machine and run it or run it with docker. </blockquote>

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, <img src="https://i.stack.imgur.com/VDBLW.png" alt="enter image description here"> 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 <img src="https://i.stack.imgur.com/YbGM6.png" alt="enter image description here"> 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 <img src="https://i.stack.imgur.com/lZ98T.png" alt="enter image description here"> <img src="https://i.stack.imgur.com/7ohxn.png" alt="enter image description here">

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 <code>postgresql.conf</code> file. Or even simplier, change the port in the server creation from 5432 to 5433. Now you are able to create a server again.

Unable to connect to server: PgAdmin 4

Video Answer

4 Answers

You may need to installing PostgreSQL Server first.

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

113

answered Oct 07 '22 14:10

Jeberdson Abraham

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.

answered Oct 07 '22 12:10

Stevy

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,

enter image description here

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 enter image description here 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

enter image description here

answered Oct 07 '22 13:10

Kjk

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.

answered Oct 07 '22 12:10

kwoxer

Related questions
                            
                                How to filter django model by its objects in many-to-many field (exact match)?
                            
                                Django template engine indentation
                            
                                Django South Error: "there is no enabled application matching 'myapp'"
                            
                                Getting a "The following content types are stale and need to be deleted" when trying to do a migrate. What does this mean, and how can I solve it?
                            
                                Customize the djoser create user endpoint
                            
                                Facebook, Django, and Google App Engine
                            
                                Django Generic Views: When to use ListView vs. DetailView
                            
                                Django send_mail not working
                            
                                Pass a custom queryset to serializer in Django Rest Framework
                            
                                Django: Duplicated logic between properties and queryset annotations
                            
                                schedule number of web dynos by time of day
                            
                                How to get coverage data from a django app when running in gunicorn
                            
                                Django and REST API to serve calculation-based requests
                            
                                How do I use perform_create to set a field automatically in Django Rest Framework?
                            
                                How to force select_related() to select ForeignKeys that have null=True attribute?
                            
                                Disabling Django CSRF for views that do not always have a response
                            
                                In Django, how can I get an exception's message?
                            
                                What are the disadvantages of using AWS ELB directly with Gunicorn (no nginx)?
                            
                                Could not find a version that satisfies the requirement django (from versions: ) No matching distribution found for django [duplicate]
                            
                                What is the difference between south migrations and django migrations?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!

Donate Us With

Unable to connect to server: PgAdmin 4

Tags:

django

database-connection

pgadmin

Rahul Sharma

People also ask