1

I used postgresql almost a year on my local. Yesterday I used it and after I update the windows. Today I can not connect to the postgresql. It gives the below error:

connection to server at "localhost" (::1), port 5432 failed: Connection refused (0x0000274D/10061) Is the server running on that host and accepting TCP/IP connections? connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused (0x0000274D/10061) Is the server running on that host and accepting TCP/IP connections?

After that I tried restart/start postgresql from services and it gives another error:

The postgresql-x64-13 service on local computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.

When I check the event viewer I saw this error:

2023-11-17 10:56:01.911 +03 [20256] FATAL:  configuration file "C:/Program Files/PostgreSQL/13/data/postgresql.conf" contains errors

I did not change any config, how can I fix this issue? I also share the properties:

enter image description here

Config file: C:\Program Files\PostgreSQL\13\data\postgresql.conf WeTransfer link of config file: (I can not share the link) enter image description here

Improve this question
9
  • Perhaps, the update routine failed and tried to apply a diff to the config file. Could you post the contents of the config file? Commented Nov 17, 2023 at 8:17
  • Does the config file exist? This question/answers may help stackoverflow.com/questions/16730405/… Commented Nov 17, 2023 at 8:17
  • 1
    @erny the config file is in the question, and the change date has not changed. Commented Nov 17, 2023 at 8:29
  • "the config file is in the question" -no, it's not. Theres only a link to that file. Please share all details in text form Commented Nov 17, 2023 at 8:30
  • The file has 780 lines, the text limit of question box exceeded. Thats why I added the we transfer link. And also if you want to check a specific part of the config file, I can share. Or do you have another suggestion for me to share? Commented Nov 17, 2023 at 8:34
Related questions
1200
How can I start PostgreSQL server on Mac OS X?
89
unable to connect to server for Postgres
82
Create new local server in pgadmin?
Load 3 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.