I know this question may be marked as repeated, but keep in mind that I have searched for numerous posted solutions and my error has not been fixed.
When starting postgres, I get the following error:
postgresql application server could not be contacted.
When running as administrator the error is "solved", but the application opens in another port – sometimes it opens in 50142, 51120 and others in 50859 -. And when it opens on another port (like the ones previously said), it asks for the password to connect to the server and I get this error:
could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432? 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?
Infos:
- Windows 10 64Bits
- Postgresql 10
- pgAdmin 4.1
- Port 5432 (appears even in PostgreSQL\10\data\postgres.conf)
Solutions already tried:
- Run in administrator mode
- Modify the postgres.conf file
- Clear the contents of the folder AppData\Roaming\pgAdmin
I would like to know how to avoid this error when starting the application and always opening on a specific port.
Best Answer
I finally got the right solution after 3 days of tries, this was insane, some answers above was correct at least not in my case but if you running to the same problem I had, I suggested following these steps even though some answers was very clear and helpful regarding deleting the folders inside the pgAdmin folder but not all the time and it depends. So here are the steps to follow:
This PC > local Disk(C:) > Users > (your folder's name)