PostgreSQL - Connection to localhost:"****" refused error

Question

I am creating a project using Spring Boot in IntelliJ Idea. I want to use PostgreSQL as a database for my project. But I get an error that"Connection refused check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections"

For postgreSQL integration into my project, I updated my "application.properties" file as shown below:

Then I created a file named data.sql and created my issue table in it:

3. My database properties:

4. My postgresql.conf file:

5. My hba.conf file:

6. The error that I get:

Can you please help me to fix this issue ?

Ian Barwick · Accepted Answer · 2020-10-13 11:44:37Z

1

Did you restart PostgreSQL after changing the port number? If not, you'll need to do that.

If you've restarted PostgreSQL and the connection is still rejected, it may not have been able to bind to the port in question. Check the PostgreSQL log file for clues.

answered Oct 13, 2020 at 11:44

Ian Barwick

1515 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Minel Aydın Over a year ago

Thank you. I deleted PostgreSQL 13 and uploaded 12 version. It fixed.

Collectives™ on Stack Overflow

PostgreSQL - Connection to localhost:"****" refused error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related