Post by ed1023 » Wed Jul 29, 2015 3:46 am

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

Newbie

Posts

Joined
Wed Jul 29, 2015 3:25 am

Post by postgresql » Tue Dec 22, 2015 8:34 pm

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

Newbie

Posts

Joined
Tue Dec 22, 2015 7:59 pm

Post by cesco » Thu Jan 14, 2016 8:02 pm

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! ;D

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!

Newbie

Posts

Joined
Thu Jan 14, 2016 7:54 pm

Post by reaga » Mon Jan 18, 2016 5:33 pm

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

Newbie

Posts

Joined
Wed Jan 06, 2016 6:46 pm

Post by postgresql » Tue Jan 19, 2016 4:46 pm

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.

Newbie

Posts

Joined
Tue Dec 22, 2015 7:59 pm

Post by psp500 » Fri May 30, 2025 5:31 pm

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

Newbie

Posts

Joined
Tue Sep 24, 2019 3:32 am

Post by CartCoding » Sun Jun 01, 2025 5:36 pm

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

Tracking Assiatant - Integrate Realtime Tracking Information on Website
OpenCart Extensions, Plugins Development, Themes Design and Website Optimization
FREE Guidance and Advice at https://www.cartcoding.com


User avatar
Newbie

Posts

Joined
Thu Aug 03, 2023 3:48 pm

Post by JNeuhoff » 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!

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by khnaz35 » Mon Jun 02, 2025 10:15 pm

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 :laugh:

Got an urgent question that’s keeping you up at night? There might just be a magical inbox ready to help: khnaz35@gmail.com
Enjoy nature ;) :) :-*


User avatar
Active Member

Posts

Joined
Mon Aug 27, 2018 11:30 pm
Location - Malaysia
Who is online

Users browsing this forum: No registered users and 14 guests