Hi Doug,

Generally speaking, when our Users try to connect to PostgreSQL, I will advise you for some general steps you can check :

First, please check if you have the following drivers installed, and activated.

These drivers need to be installed and activated on the server where your WordPress website is. 

The server to which wpDataTables is connecting has its own method of establishing the connection, and we're using PHPs logic of connecting to separate connections.

 If there are errors your server returns, those are returned by the server, and only displayed by wpDataTables

 - there's no additional log within wpDataTables that would distinctively show you what's behind the error.

-

If your PostgreSQL is installed on Ubuntu 18.04 server, and you’re receiving the following error:

“wpDataTables could not connect to postgresql server. postgresql said: There was a problem with your SQL connection – could not find driver”

You may need to install the PGSQL driver by following these steps:

[sudo] apt-get install php-pgsql

Then uncomment pgsql and pdo-pgsql extentions in php.ini and restart Apache with the following command:

[sudo] /etc/init.d/apache2 restart

Let me know if these steps might have helped to solve the issue;

Here is some additional advice, in case if you have chosen a different driver from our dropdown in the External DB Connection configuration.

You should only select the driver from the dropdown if the connection doesn't work. 

The plugin detects the connection you selected (MSSQL, MySQL, PostgreSQL) and based on that it attempts to connect using the default driver for that type of database.

 If that doesn't work automatically, then you need to select a different/ specific driver.

If you have a Linux server, you can take a look at this thread on Stack Overflow. 

There are a lot of resources available online for installing the PHP drivers, so the hosting provider should be able to do this without many issues.

Let me know how it goes, one of these suggested methods should allow you to add your DB connection.

Thank you.