Squirrel SQL gives: FATAL: database "localhost:5432:postgres" does not exist

Question

I want to use Squirrel SQL since it seems a good alternative to pgAdmin but I do not succeed to connect with database postgresSQL, respectively, MariaDB. The error I got is:

java.util.concurrent.ExecutionException: java.lang.RuntimeException: org.postgresql.util.PSQLException: FATAL: database "localhost:5432:postgres" does not exist

I have the following environment: Windows 7, postgreSQL 9.6, MariaDB 10.2. I can connect both databases with terminal or pgAdmin, respectively, HeidiSQL. So, I think I do something fundamentally wrong when trying to connect to the databases with Squirrel SQL.

Here are the detailled steps I did:

(1) The drivers are in C:\Program2\db_drivers and also the databases are installed in directory \Program2:

(2) I could register the drivers:

(3) Then I tried to make an alias:

(4) ... but got this error:

Łukasz Kamiński · Accepted Answer · 2017-08-29 10:23:28Z

2

As documented in the manual the URL should be:

jdbc:postgresql://localhost:5432/postgres

edited Aug 29, 2017 at 10:23

user330315

answered Aug 29, 2017 at 8:43

Łukasz Kamiński

6,0401 gold badge26 silver badges33 bronze badges

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

1 Comment

giordano Over a year ago

Thank you. This solved my problem. MariaDB had also a very strange default entry: jdbc:mysql:host:3306 which I changed to jdbc:mysql://localhost:3306/. Now it works.

Collectives™ on Stack Overflow

Squirrel SQL gives: FATAL: database "localhost:5432:postgres" does not exist

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