« previous next »
Pages: [1]

Author Topic: [SOLVED] PostgreSql on WampServer  (Read 4793 times)

0 Members and 1 Guest are viewing this topic.

Offline cbrooksTopic starter

  • Irregular
  • Posts: 36
    • View Profile
[SOLVED] PostgreSql on WampServer
« on: November 11, 2009, 01:27:46 PM »
I am currently running WampServer 2.0i (Apache 2.2.11, PHP 5.3.0, MySql)
As installed all works great.
I installed PostgreSQL 8.4 listing on port 5432. It works great outside of Apache/PHP
I enabled pdo_pgsql.dll and pgsql.dll in php.ini and restarted Apache. It seems that it is not loading the .dll files as I am getting Fatal Error: undefined function pg_connect, when you try to connect to the database. Also when you look in phpinfo() under PDO drivers it only mentions mysql and sqlite. No mention anywhere about PostgreSQL.

I have been looking around and it seems that this is an issue with WampServer after PHP version 5.2.5 or .6
Does anyone have any suggestions?? I really need to get this working!
Logged
According to 'Hillary' It takes a village to raise an Idiot! And My mother thanks you for your assistance in raising hers!

Offline Mchl

  • Staff Alumni
  • Freak!
  • *
  • Posts: 8,582
  • Gender: Male
  • That's Largo in my avatar, not me.
    • View Profile
    • FlingBits
Re: PostgreSql on WampServer
« Reply #1 on: November 11, 2009, 01:30:07 PM »
Click on WampServer icon in tray, select PHP > PHP Extensions and mark php_pdo_pgsql. Wait until server restarts itself.

Edit:

Ok. Just tried it myself, and indeed it doesn't seem to be working. Did you ask at WampServer's forum?
« Last Edit: November 11, 2009, 01:32:15 PM by Mchl »
Logged
NetBeans fanatic | ExtJS masochist | C++ denier
PHP4 & MySQL4 are no longer supported.
PHPFreaks Tutorials | PHP Debugging: A Beginner's guide | PHP Security Tutorial || How To Ask Questions The Smart Way
Flingbits tutorials | Class Autoloading

Offline cbrooksTopic starter

  • Irregular
  • Posts: 36
    • View Profile
Re: PostgreSql on WampServer
« Reply #2 on: November 11, 2009, 01:44:50 PM »
Yes, that was the first place I checked. Never received any type of answer from them at all.
Logged
According to 'Hillary' It takes a village to raise an Idiot! And My mother thanks you for your assistance in raising hers!

Offline cbrooksTopic starter

  • Irregular
  • Posts: 36
    • View Profile
Re: PostgreSql on WampServer
« Reply #3 on: November 13, 2009, 05:01:34 PM »
Ok, got it all working as follows:

I removed the WampServer 2.0i version that I was using and installed WampServer 2.0c in it's place.

I then went to the following site:

[www.blog.bmedon.net]

This site is in a non English language, so click on the 'Translate' Button on the top right to get it in English.

and get their copies of the following to dll's

php_pdo_pqsql.dll
php_pqsql.dll

place them into your ext directory
enable php_pdo_pqsql.dll and php_pqsql.dll in your php.ini and restart your Apache server.

It worked for me the first time.

I never heard any info from WampServer personnel concerning this issue.

ended up with the following versions of everything:

Apache 2.2.8
PHP 5.2.6
MySQL 5.0.51a
PostgreSQL 8.2.3
Logged
According to 'Hillary' It takes a village to raise an Idiot! And My mother thanks you for your assistance in raising hers!

Offline Mchl

  • Staff Alumni
  • Freak!
  • *
  • Posts: 8,582
  • Gender: Male
  • That's Largo in my avatar, not me.
    • View Profile
    • FlingBits
Re: PostgreSql on WampServer
« Reply #4 on: November 13, 2009, 05:16:20 PM »
Quote from: cbrooks on November 13, 2009, 05:01:34 PM

I never heard any info from WampServer personnel concerning this issue.


Their forum is not very busy, and your issue is far from common (after all MySQL is most widely used with WampServer).
Anyway, it would be nice to get any kind of response.
Logged
NetBeans fanatic | ExtJS masochist | C++ denier
PHP4 & MySQL4 are no longer supported.
PHPFreaks Tutorials | PHP Debugging: A Beginner's guide | PHP Security Tutorial || How To Ask Questions The Smart Way
Flingbits tutorials | Class Autoloading
Pages: [1]
« previous next »