Title: Using WP Data Access with a Postgres Database
Last modified: July 31, 2021

---

# Using WP Data Access with a Postgres Database

 *  Resolved [appomatix](https://wordpress.org/support/users/appomatix/)
 * (@appomatix)
 * [4 years, 10 months ago](https://wordpress.org/support/topic/using-wp-data-access-with-a-postgres-database/)
 * I have a wordpress.org WordPress site that is set up on a MySQL database to which
   I’ve added a Postgres database to hold all of my additional data which I import
   in via CSV files. Is it possible to use the WP Data Access to work with my Postgres
   database data and, if so, is there a guide somewhere that shows how I would go
   about connecting the two?
 * Thanks

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Plugin Author [Passionate Programmer Peter](https://wordpress.org/support/users/peterschulznl/)
 * (@peterschulznl)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/using-wp-data-access-with-a-postgres-database/#post-14722367)
 * Hi [@appomatix](https://wordpress.org/support/users/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/](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/](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/](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
 *  Thread Starter [appomatix](https://wordpress.org/support/users/appomatix/)
 * (@appomatix)
 * [4 years, 9 months ago](https://wordpress.org/support/topic/using-wp-data-access-with-a-postgres-database/#post-14727798)
 * [@peterschulznl](https://wordpress.org/support/users/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!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Using WP Data Access with a Postgres Database’ is closed to new replies.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

## Tags

 * [database connection](https://wordpress.org/support/topic-tag/database-connection/)
 * [postgres](https://wordpress.org/support/topic-tag/postgres/)
 * [PostgreSQL](https://wordpress.org/support/topic-tag/postgresql/)

 * 2 replies
 * 2 participants
 * Last reply from: [appomatix](https://wordpress.org/support/users/appomatix/)
 * Last activity: [4 years, 9 months ago](https://wordpress.org/support/topic/using-wp-data-access-with-a-postgres-database/#post-14727798)
 * Status: resolved