By glennnz on

Hi

I have developed a Druaol website locally on my Mac, and am now trying to migrate to to a remote Windows Server environment.

I've successfully uploaded my website files and database, but can't get the website to talk to the PostgreSQL database. I get ,"We were unable to use the PostgreSQL database because the PostgreSQL extension for PHP is not installed. Check your PHP.ini to see how you can enable it."

I have:

- copied the php_pgsql.dll file to the ext directory.
- added the following to my php.ini:
[PHP_PGSQL]
extension=php_pgsql.dll
- restarted the server

with no luck, still the same error message.

Any help appreciated.

Thanks

Glenn

⋅ Categories: Drupal 5.x

Comments

Johnywoo’s picture

Johnywoo commented

Is that what drupal is saying? I am assuming youre running PHP under apache, if you are what does the error.log say about trying to run php_pgsql.dll?

glennnz’s picture

glennnz commented

I worked on this for ages, and in the end migrated my site to MySQL with no problems.

Thanks

Glenn
THECA Group

Johnywoo’s picture

Johnywoo commented

I had a problem in using Postgres which I ended up fixing and I will note on it for anyone who comes across this post. Apache wasnt able to load the postgres module offered by PHP so that postgres was never actually being used. There was a file missing called libpq.dll. In the bin directory of where you have your postgres the file libpq.dll is located, along with other dependencies. So after putting LoadFile "C:/Program Files/PostgreSQL/8.3/bin/libpq.dll" into httpd.conf the problem was resolved and apache and php recognized postgres.

Note: just including the file libpq.dll isnt enough, all its dependencies need to be included as well, this was the case at least for postgres 8.3