• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

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