Problem working with Postgres

Thursday 01 July 2004 8:50:39 am

I'm trying to perform a fresh install on eZ publish 3.4.0 and have it use Postgres. The setup dectects the presence of Postgres and allows me to select. At the screen where the host, user name, and password are entered, it fails with this message:

"Please make sure that the username and the password is correct. Verify that your PostgreSQL database is configured correctly."

I run a simple php test script:

$link = pg_connect("host=localhost dbname=ezpublish user=postgres password=password");
if (!$link) {
die("Could not connect: " .pg_last_error());
}
echo 'Connected successfully';

And it connects just fine.
Is there some Postgres parameter that ez Publish needs set ?

phpinfo returns the following on postgres

pgsql
PostgreSQL Support enabled
PostgreSQL(libpq) Version 7.3.4
Multibyte character support enabled
SSL support enabled
Active Persistent Links 0
Active Links 0

Directive Local Value Master Value
pgsql.allow_persistent On On
pgsql.auto_reset_persistent Off Off
pgsql.ignore_notice Off Off
pgsql.log_notice Off Off
pgsql.max_links Unlimited Unlimited
pgsql.max_persistent Unlimited Unlimited

Thanks

Thursday 01 July 2004 12:24:20 pm

Thank you. I just tested the fix and it worked for me also.