I have just installed postgresql 8 on my RHEL 3.0 Update 4 system. Everything seems to be working, all my data is there I can connect using Perl/DBI and psql etc. . . then I try my PHP page, that works just fine with PostgreSQL 7, and I get the message -- DB Error: no such database. Nothing appears in the log files that I am familar with. Again, this code works currently against prior version of PostgreSQL without issue.
I am running RHEL 3.0 with all of its standard software. I have added nothing nor tweaked anything. I even installed PostgreSQL 8 from RPMs for rhel-3.0.
<?php
function MyDbConnect() {
$dsn = array(
'phptype' => 'pgsql',
'username' => 'user',
'password' => '',
'hostspec' => 'localhost',
'port' => '5432',
'database' => 'SERVER_MGMT',
);
$options = array(
'debug' => '2',
);
$db = DB::connect($dsn, $options);
return $db;
}
?>
Given the new features of 8 I would very much like to upgrade to it; however, can not until I figure out this issue. Any help is greatly appreciated. -Thanks