Connect PostgreSQL with XAMPP

[buggyec]

Hello, I have a little problem connecting postgresql with XAMPP because I edit php.ini and uncomment extension=php_pgsql.dll and restart apache in the XAMPP control panel but it doesn't work. I can't connect to postgresql

Help me please

[glitzi85]

Hello, I have a little problem connecting postgresql with XAMPP because I edit php.ini and uncomment extension=php_pgsql.dll and restart apache in the XAMPP control panel but it doesn't work. I can't connect to postgresql

Can't connect is not a error message. What's the output of your script? Are you able to connect to PostgreSQL with the Admin tools from the PostgreSQL Installation?

glitzi

[buggyec]

hello

I guess the connection to postgres is able because in the phpinfo() I saw the information and the part of pgsql is rigth.

In the login.php the message is error in login but it is not for user and password this error is the application can't connect to postgres.

I tested my application using appserv and it works good with postgres but with Xampp it doesn't work.

Thanks for reply

[glitzi85]

And what application is throwing this error message? I had a similar problem with a fresh phpPgAdmin-Installation, there I forgot to change some settings.
If the script is written by yourself, then you need to use the pg_last_error()-Function to see what the problem is.

glitzi

[buggyec]

My error is login error but it is not for the user and password, I can't connect with postgres

[glitzi85]

My error is login error but it is not for the user and password, I can't connect with postgres

Did you read my post? What application is throwing this error? Is it a script you've downloaded from the internet or did you program it by yourself?

glitzi

[buggyec]

I did my script, using appserv it works but with xampp I can't connect to postgres

[buggyec]

I restart php in XAMPP and I have this error and I think it is the reason that XAMPP can't connect to Postgres

Unable to load dynamic library '/Applications/XAMPP/xamppfiles/lib/php/php-5.2.9/extensions/no-debug-non-zts-20060613/php_pgsql.dll

Please help

[glitzi85]

OK, i've googled now what AppServ is, i thought it is an application...

Did you install PostgreSQL? It is NOT included in XAMPP!

Also it is not possible to restart PHP, as PHP is just a module of Apache. And that is the last time i ask this question: What script are you using?

glitzi

[buggyec]

my script


<?php
$conexion = pg_connect("host=localhost port=5432 password=*** user=postgres dbname=***") or die('Can't connect!!!: ' . pg_last_error());
?>


The library pgsql.dll works in windows. I think my script is right because I use this script in AppServ

[Wiedmann]

and uncomment extension=php_pgsql.dll
...
Unable to load dynamic library '/Applications/XAMPP/xamppfiles/lib/php/php-5.2.9/extensions/no-debug-non-zts-20060613/php_pgsql.dll

*.dll" are Windows shared libraries. On *nix/OS X they are always named "*.so".

Also the shared pgsql extension have the name "pqsql.so".Thus you have to use:

Code: Select all

extension=pgsql.so