Hi i want to use PostgreSQL for a school project and whenever i open the server in Pg Admin i got the same issue
when i first open Pg Admin i enter the password that i entered in the installation and when i click to server(1) it requires password for user "postgres" i use the same password but it tells me:
could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 1500? 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 1500?
i don't know what does it really mean .. cause i'm new to databases and servers
I'm using PostgreSQL-12 and Pg Admin-4 in Windows-10
please help !! and thank you !
On windows:
I am facing the same problem and as I edited the port to 5432 it worked. In my case, Postgres was running on 5433 and I changed it to 5432
Pretty sure the problem is due to this:
... accepting TCP/IP connections on port 1500
Postgres runs by default on port 5432. Try changing the port setting to 5432.
