phpPgAdmin 4.1.3 (PHP 4.4.4) not working with postgres 8.2.4

Hi,

My hosting company has recently upgraded my postgres database to 8.2.4 and the upgrade worked perfectly except I can no longer login to the database using phpPgAdmin.  I'm in a shared server environment and they upgraded to phpPgAdmin 4.1.3 (PHP 4.4.4) to make sure it wasn't a problem with an older version of phpPgAdmin.

I am still able to login via psql and via my jdbc connection in my java webapp with my main username and password and a database specific useraname and password, so we can't figure out what the problem is.  They have contacted the developers of phpPgAdmin, but haven't received any answer.
LVL 1
courtenaytAsked:
Who is Participating?
 
gheistConnect With a Mentor Commented:
You have to look if PHP or PhpPgAdmin connects to socket where postgresql server listens. CONNECT function does not change the way server works.
0
 
gheistCommented:
You have to review phpinfo() and phppgadmin settings if they point to correct postgreswl server - i.e localhost or 127.0.0.1 or ::1, not hostname or host IP address.
What was previous version?
0
 
courtenaytAuthor Commented:
Thanks so much for your help!

Here is the response from my host company:


The PhpPGAdmin settings are the same as were defined in the previous PhpPgAdmin config.inc.php file. I have found that Postgres 8.2.4 has a new function called CONNECT which I am not sure if it is causing a problem with the PhpPGAdmin setting.  What specifically were they wanting us to review in the phpinfo page?
 
The previous version was 4.0.1
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
courtenaytAuthor Commented:
I've sent your response to my host company along with some other ideas, but haven't heard back from them yet.  I'll let you know as soon as I know more.

Thanks,
Courtenay
0
 
courtenaytAuthor Commented:
My host compnay was able to resolve the problem.  The said: " I ended up rebuilding the actual postgres install, phppgadmin, and all of the php plugins to support postgres connections. "
0
 
gheistCommented:
Problem was seen on phpinfo()
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.