Exception Name | Message | Cause / Solution |
java.sql.SQLException | Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP / IP connections. | Cannot connect to the database.Please check the host name and port number. |
Backend start-up failed: FATAL: database "<database name>" does not exist. | Make sure the specified database exists. |
Backend start-up failed: FATAL: user "<user name>" does not exist. | Make sure the specified user exists. |
ERROR: syntax error at or near "<table name>" | Please verify that the specified table name is correct. |
ERROR: relation "<table name>" does not exist | Make sure the specified table exists. |
ERROR: permission denied for relation <table name> | Please check the read permissions for the specified table. |
java.lang.Exception | The server does not support SSL. | SSL connection is made, but PostgreSQL server side does not support SSL.Please check your PostgreSQL server side configuration. |
The connection attempt failed. | SSL connection is made, but certificate is not imported to DataSpiderServer side.Please import the certificate. |
FATAL: no pg_hba.conf entry for host <host name>, user <username>, database <database name>, SSL off | Standard connection is made, but PostgreSQL server side set to [Destination] support SSL only. Please check the settings for [Destination] or PostgreSQL server side settings. |
FATAL: no pg_hba.conf entry for host <host name>, user <username>, database <database name>, SSL on | SSL connection is made, but PostgreSQL server side set to [Destination] does not support SSL. Please check the settings for [Destination] or PostgreSQL server side settings. |