Using WP Data Access with a Postgres Database

Hi @appomatix,

You can connect to PostgreSQL, but you need to perform some extra installation steps on your OS and DBMS. There is a generic step which involves the installation of JDBC drivers described here:
https://wpdataaccess.com/docs/documentation/remote-database-connections/odbc-jdbc/

After that you need to install the ProstgreSQL interface. There is currently no documentation for a PostgreSQL installation specifically. But there is a video tutorial for SQL Server which contains the generic ODBC|JDBC installation:
https://wpdataaccess.com/docs/documentation/remote-database-connections/connect-to-sql-server/

The ProgreSQL installation installation is a bit different. This page might help:
https://mariadb.com/kb/en/connect-jdbc-table-type-accessing-tables-from-another-dbms/

You could do me a big favor in return! ?? May I ask to recordi your steps and allow me to add it to the documentation?

Let me know if you need further assistance,
Peter

@peterschulznl

Thanks for the response and sorry for the delayed reply. As much as I would like to see if I could get the process as you describe it above to work, I don’t think I’m going to be able to. My WordPress host doesn’t support MariaDB, only MySQL and Postgres, and barely Postgres at that. So, in order to attempt to do it, is seems as though I would have to have a remote MaridDB hosted somewhere then try to connect through that. If so, it would add a layer of complexity to my site that I can’t at the moment justify. If things change in the near future, I will reevaluate because I’m always up for a challenge. ??

Cheers!