DBeaver localhost PostgreSQL connection refused

0
votes

I just installed DBeaver on my personal computer and am trying to create a PostgreSQL database.

I entered the following in the Connect to database window:

  • Host: localhost
  • Port: 5432
  • Database: postgres
  • User: postgres

Those values were all pre-filled defaults, so I left them and clicked the Test Connection... button.

When I click the Test button an error window opens, saying, "Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. Connection refused: connect"

I tried setting my own db name and credentials, but get the same results.

How do I set up a local PostgreSQL database in DBeaver?

2
postgresqldatabase-connectiondbeaver

2 Answers

3
votes

DBeaver does not allow to setup a local PostgreSQL server or instance: it allows to connect to an existing server or instance. If the PostgreSQL instance does not exist you should install PostgreSQL binaries and create a new database instance with initdb.

3
votes

If your operating system is Windows 10 Home, you have to use 192.168.99.100 instead of localhost.