• We value your experience with Plesk during 2025
    Plesk strives to perform even better in 2026. To help us improve further, please answer a few questions about your experience with Plesk Obsidian 2025.
    Please take this short survey:

    https://survey.webpros.com/

Postgresql connection problem

T

tellus

Guest
I recently had my very first customer that wanted a pgsql database (got it from the plesk addon) and everything looked good at first but the customer noticed that it was not possible to connect to the pgsql db from a php script (yes, php is compiled with --with-pgsql) but it worked fine from phppgadmin.

I did some tests myself and for some reason it works in php scripts with:

PHP:
pg_connect("host='' port=5432 dbname=$dbname user=$user password=$pass")

but not with:

PHP:
pg_connect("host=localhost port=5432 dbname=$dbname user=$user password=$pass")

Why is this? Is there something I need to change to get this to work with writing "localhost" since that is the most common usage.

Running freebsd and postgre 7.4.6
 
Back
Top