• Inviting everyone who uses WordPress management tools in Plesk
    The Plesk team is conducting a 60-minute research session that includes an interview and a moderated usability test.
    To participate, please use this link .
    Your experience will help shape product decisions and ensure the tools better support real-world use cases.

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