Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
While executing SQL recipe with default settings (notably checked case Use psql For PostgreSQL recipes, use psql binary instead of the JDBC driver) I received an error
psql: error: connection to server at "blabla" (22.214.171.124), port 5432 failed: SSL error: certificate verify failed [16:49:44] [INFO] [dku.utils] - connection to server at "blabla" (126.96.36.199), port 5432 failed: FATAL: no pg_hba.conf entry for host "195.154.x.x", user "postgres", database "postgres", SSL off
which at first glance might indicate that I have a bad connection for my DB. However, connection is tested and working.
Here is the list of thing I tried:
Why there is such a difference between JDBC driver and psql binary? And more importantly how do I solve it?
Operating system used: Linux
There shouldn't be any noticeable performance difference between psql and jdbc driver.
In a SQL notebook the query is limited by default to 1000 rows hence it may be much faster as it won't execute the full query.
If you want to use psql you will need to modify the pg_hba.conf file to include an entry for :
host all all 195.154.x.x/32 trust
Try your connection again but again you shouldn't see a performance difference between issuing a command via PSQL vs JDBC as long as the network path is the same.
In your case, if you run the query directly on the Postgres server itself locally and compared this from DSS issuing then the cause of the slowness is either network or intermittent performance
I know that it does not make any sense but, in fact it is not just slow, it never finishes the job.
I think my configs in pg_hba.conf are ok since I manage to launch the commands from terminal of server on which dataiku is hosted.