CODEWITHSUNDEEP
postgresqljdbc
Tom
Tom

Reputation: 41

Postgres and JDBC

I'm converting postgres to Exasol, gonna run some time trials on supposedly a super-fast DB. Exasol has an import script which I'm using and getting a "Connection refused error". This is for a local connection, Windows 10 and postgres 9.4

Things I've double-checked:

host all all 127.0.0.1/128 md5

host all all ::1/128 md5

Here is the error msg: [43000] "JDBC-Client-Error: Connecting to 'jdbc:postgresql://127.0.0.1:5432/tom_db' as user='postgres' failed [Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.]"

Any ideas? Not sure what to check next...

Upvotes: 0

Views: 496

Answers (1)

Graham Mossman
Graham Mossman

Reputation: 1

are using the EXASOL community edition in a VM ?

If so, you don't want 127.0.0.1

For example I have my EXASOL database running as a VM on my laptop at 192.168.56.123 and I am running postgres directly on my laptop (which is 192.168.56.1 as well as 127.0.0.1)

In this case my JDBC connection would use 192.168.56.1 for connecting from EXASOL to postgres

Hope this helps - bear in mind too that you can also post these questions on the EXASOL community website https://www.exasol.com/portal/questions

Upvotes: -1

Related Questions