Did you ever find a resolution to this issue?
We have a working PG4WP site, which I attempting to move to another server. The server’s are similar, with only minor version differences between them (I.e., psql 8.1.24 versus psql 8.4.13). However, on the new server, we are also getting this error.
I’ve verified that the database is good and the credentials valid; I can connect to the db via the command line.
I’ve turned on logging in PG4WP, however this error doesn’t generate any log messages.
This install is using
WP 3.4.2
PG4WP 1.3.0
PgSQL 8.4.13
PHP 5.4.16
I’ve also tried doing a fresh, vanilla install with WP 3.5.2 (everything else the same), and likewise get “Error establishing a database connection”.
I understand the PG4WP 1.3 should work with version of PostgreSQL up to 9.1
Edited to add: I forgot to make note that there is also a PHP version change from the server where PG4WP works (PHP 5.3.15) and the server where it does not (PHP 5.4.16). I have not found anything indicating what versions of PHP are supported.
