PGSQL Driver Mismatch

PDO: driver pgsql requires PDO API version 20060409; this is PDO version 20060511

The above error was the final roadblock in getting one of our servers back into working condition after a server upgrade. I am posting this here because it took a very long time to discover a solution and I found the solution on a site in German. Thank you google translate.

In short, this server is a combination of PHP, Lighttpd and PGSQL. After the update Apache tried to run at startup and I had to remove the links to the Apache startup scripts found in /etc/rc*.d. A few more step to clear a Lighttpd warning about ipv6 and then I tried to start Lighttpd, /etc/init.d/lighttpd start. That’s when the above error reared its ugly head.

Some generic searches gave some results, but nothing that said “do this to fix it”. Until I slapped the error in google word for word and found a handful of Chinese and German pages talking about it. Fixing this issue ultimately required upgrading PDO and its PGSQL module and that looked something like this:

  1. pecl uninstall pdo pdo_pgsql
  2. pear upgrade PEAR
  3. pecl install pdo pdo_pgsql

Start Lighttpd and life was back to normal!

One thought on “PGSQL Driver Mismatch

  1. Margarita  

    You post interesting articles here. Your website
    deserves much more traffic. It can go viral if you give it
    initial boost, i know useful service that can help you, just search
    in google: svetsern traffic tips

Leave a Reply

Your email address will not be published. Required fields are marked *