Postgresql – Setting up PostgreSQL Connection with DBVisualiser

connectivitypostgresql

Apologies for the rudimentary question, I'm new to setting up databases. Am aiming to create a new Postgres connection and load some CSV files into a table using DBVisualiser. Working on a Mac running El Capitan 10.11.3

I enter all the details in the Connection Wizard as follows:

enter image description here

But get the following 5432 error when I try to ping the server.

enter image description here

Where am I going wrong? I also tried using 127.0.0.1 as my local host but that didn't work either.

Best Answer

Did you checked your postgresql configuration, mainly the pg_hba.conf? Can you login to your server with psql? http://www.postgresql.org/docs/current/static/auth-pg-hba-conf.html

Related Question