How to fix Postgres error - "connection timeout expired"

[Suspect128482]

If you are getting said "connection timeout expired" error when trying to connect to your PostGreSQL server
Simply;
-Go to Windows Run (windows + R)
-Type in "services.msc"
-Go to the Postgresql service and manually start it

Voila problem solved, unsure why even though the Startup Type is automatic I had to manually turn it on
Had this problem for ages and solved it myself couldn't find anything helpful online, so hopefully this will help :)

[Suspect128482]

Also restarting the service might help if it is going already :)

[Suspect128482]

Also within C:\program files\postgresql\16\data\postgresql.conf make sure the listening address it set to "*" not a loopback address for ipv4 or 6 (127.0.0.1::1), this should enable you to start the service manually

[Pabl0l]

THANK U SO MUCH <3

[Pabl0l]

THANK U SO MUCH <3

[Pabl0l]

THANK U SO MUCH <3

[Pabl0l]

THANK U SO MUCH <3

[Pabl0l]

THANK U SO MUCH <3

[Pabl0l]

THANK U SO MUCH <3

[Pabl0l]

THANK U SO MUCH <3

[Pabl0l]

THANK U SO MUCH <3

[Pabl0l]

THANK U SO MUCH <3

[Pabl0l]

THANK U SO MUCH <3

[Pabl0l]

THANK U SO MUCH <3

[Pabl0l]

THANK U SO MUCH <3

[Pabl0l]

THANK U SO MUCH <3

[Pabl0l]

THANK U SO MUCH <3

[Pabl0l]

THANK U SO MUCH <3

[Pabl0l]

THANK U SO MUCH <3

[Pabl0l]

THANK U SO MUCH <3

[Pabl0l]

THANK U SO MUCH <3

[Pabl0l]

THANK U SO MUCH <3

[Pabl0l]

THANK U SO MUCH <3

[Pabl0l]

THANK U SO MUCH <3

[Vini0100]

THANK

[Bang28]

Not work for me sir, please help

[Mognatti]

Thanks, you are a life saver!

[Arthur-Peixoto]

Not work for me sir, please help

look into your postgresql logs in /var/log/postgresql/postgresql-{version}-main.log

[MthetheleliMbuyisa]

Thank you champ

[deepsalternate]

Thanks man I was searching for solution for hours finally found it . Thanks

[muhammadshahms]

Thank you

[myatsoekaung]

It works for me, thank u for your solution. I appreciate it.

[sushanth91]

Subject: Persistent "Connection Timeout Expired" Issue with PostgreSQL Installation on Windows

Description:
Unable to resolve "Connection Timeout Expired" error despite attempting various troubleshooting steps. This includes multiple reinstallation and uninstallation attempts of PostgreSQL on the Windows system.

Details:
Issue: Connection Timeout Expired
Platform: Windows
Database: PostgreSQL

Steps Taken:

Attempted multiple reinstalls of PostgreSQL.
Followed recommended troubleshooting steps.
Ensured system compatibility and requirements.
Request:
Seeking immediate assistance to resolve the persistent "Connection Timeout Expired" issue with PostgreSQL installation on Windows.

Additional Information:
Any further guidance or insights to effectively resolve this issue would be greatly appreciated.

Thank you.

[osipov-slava]

Check contex menu - Properties/Connection/Port
try 5432 or 5433 or which you use. I had 5433 in this field. May be from previous installation
Additionally your brandmayer/antivirus app can block access

[chrajeshdagur]

Thanks!

[akhilpraghav407]

thanks!!!

[emrucar]

Not work for me sir, please help

Delete all PostgreSQL files, then download 15.6 Version https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

[GW-Der]

Thanks fam, it worked.

[techiemithlesh]

Also within C:\program files\postgresql\16\data\postgresql.conf make sure the listening address it set to "*" not a loopback address for ipv4 or 6 (127.0.0.1::1), this should enable you to start the service manually

Already applied this but still the same issue facing

[mjDanny]

THANKS

[G3ntleM4n]

You can try open "Reload configuration" as Administrator, but i guess it erases all stuff to defaults. It is in the postgreSQL folder at windows start menu. It helped me when i had that issue on just installed postgre

[omar-medhat2]

worked

[Endeathia]

Thank you this helps