Page 1 of 1

pdo postgres driver not found

PostPosted: 08. May 2009 04:29
by besteasylamp
Dear friends,

Good day to all of you. I am new to this forum, although I have used XAMPP for close to 2 years.
Usually I google around for help, or I will do a search in apachefriends forum for related issue (I have tried to search for "pdo", "pdo postgres", "postgres", "pgsql", "pdo pgsql").
This time round, my searches end in vain - I have to start a new topic.
I must state that if this has been answered somewhere, will you point to the thread please?

The issue is simply, PDO Postgres driver not found. My phpinfo() listed the following:
PDO support | enabled
PDO drivers | mssql, mysql, sqlite2

pgsql
PostgreSQL Support | enabled
PostgreSQL(libpq) Version | 8.3.1
Multibyte character support | enabled
SSL support | enabled
Active Persistent Links | 0
Active Links | 0

Directive | Local Value | Master Value
pgsql.allow_persistent | On | On
pgsql.auto_reset_persistent | Off | Off
pgsql.ignore_notice | Off | Off
pgsql.log_notice | Off | Off
pgsql.max_links | Unlimited | Unlimited
pgsql.max_persistent | Unlimited | Unlimited

Re: pdo postgres driver not found

PostPosted: 08. May 2009 07:38
by Wiedmann
The issue is simply, PDO Postgres driver not found. My phpinfo() listed the following:
PDO support | enabled
PDO drivers | mssql, mysql, sqlite2

If the PDO Postgres driver is not enabled in php.ini, just do this.

Re: pdo postgres driver not found

PostPosted: 11. May 2009 02:55
by besteasylamp
Dear Wiedmann,

I thank you very much for your kind response.
As you can see in my 1st post, PDO driver is enabled and it supports mysql, mssql, mysqlite2. Seeing it, what should I set next?

Re: pdo postgres driver not found

PostPosted: 11. May 2009 07:00
by Wiedmann
As you can see in my 1st post, PDO driver is enabled

I can see, that the PDO-Extension is loaded.

and it supports mysql, mssql, mysqlite2

And the PDO drivers for mysql, mssql and sqlite2are enabled.

Well, you want work with PDO and Postgres, you must enable the "PDO Postgres driver" (in addition to the already loaded PDO-extension).

BTW:
In your first post, the pqsql-extension is also loaded. But this one have nothing to do with PDO, and if you want work with PDO, there is no need to enable this.

(There is also a chapter about installing the PDO extension in the PHP- manual...)

Re: pdo postgres driver not found

PostPosted: 10. July 2011 08:06
by rdwonline
Actually I am having this problem as well. In the past all I had to do was uncomment the lines for the native PostgreSQL driver and its PDO equivalent. I have restarted the server AFTER saving the correct php.ini file, and I have even restarted my computer. My XAMPP install still does not load the PostgreSQL drivers.

Has anyone been able to get this to work?

I'm using Windows 7 Ultimate SP1 with XAMPP 1.7.4 and now 1.7.5 beta

Re: pdo postgres driver not found

PostPosted: 10. July 2011 14:54
by JonB
In the past all I had to do was uncomment the lines for the native PostgreSQL driver and its PDO equivalent.


"with what and when" was that the situation?

Anyway, Google is your friend:

http://notepad.patheticcockroach.com/62 ... n-windows/

8)