OpenCart Community

Good day,

I have been trying to install OpenCart using postgresql, and I keep getting the error

Error: Could not load database driver pgsql!

I have tried installing OpenCart using the MySQLi and it works just fine.

About my set up:
OS: Debian Jessie
Webserver: Apache 2.4.10
php: 5.6.9
I installed the php5-pgsql driver

I hope some one can point me where I am going wrong, Thansk

I just installed OpenCart 2.1.0.1 on PostgreSQL 9.4 with the modified installation scripts. The original download just won't be able to go through the entire installation steps.

Here is the set up of mine:

CentOS 6.6
updated PHP from 5.3 to 5.5.6
Apache 2.2.15
PostgreSQL 9.4

Hello,
I'm new here and I just discovered the platform! It appears very well done and I want to give it a shoot for a serie of medium-size e-commerce. I'm very exited about that!

Coming back to the topic:

postgresql wrote:I just installed OpenCart 2.1.0.1 on PostgreSQL 9.4 with the modified installation scripts. The original download just won't be able to go through the entire installation steps.

How to find this script?

Thanks for the help!

I'm interested as well, i keep getting stuck at step 3 of installing with pgsql

For installation, there are two majoy files needed to be changed.

OpenCart Team already did the script half way and includes it in the official download under directory \upload\system\library\db. Rename the file postgre.php to pgsql.php. But, this file still has several syntax error and needed to modify.

Secondly, the file \upload\install\opencart.sql contains all the statements to create database and insert some sample data but the sql statements are not 100% compatible with PostgreSQL's syntax. Changes are needed too.

So far, that is for installation only. Further changes on the \upload\system\library\db\pgsql.php are needed to make the entire system run with no error. Anyway, I am not done with this part yet but I'm more interested in why others are also willing to make OpenCart run on PostgreSQL. I made some mobile App run on PostgreSQL and would like OpenCart to be able to share the same database and do the data exchange.

Now opencart support pgsql database? because still option os not showing for the pgsql at time of fresh opencart install.

OpenCart Version >= 3.0.3.8 include file \upload\system\library\db\pgsql.php

Guys, this forum thread is over 9 years old. If you experience issues with pgsql, please open a new forum thread!

JNeuhoff wrote: ↑

Sun Jun 01, 2025 7:40 pm

Guys, this forum thread is over 9 years old. If you experience issues with pgsql, please open a new forum thread!

Seems want to continue till solution arrives