DBI connect failed: FATAL: database "NRF" does not exist

小帥哥飛飛

有誰知道為什么perl 訪問postgresql connect failed？ 實際的DB 路徑在/usr/local/pgsql_10,
phppgadmin 上可以看到 dbname是NRF

[root@sql sql]# perl mb1.pl
DBI connect('dbname=NRF; host=127.0.0.1','dbadmin',...) failed: FATAL:  database "NRF" does not exist
at mb1.pl line 31
________________________________________________
code:
sub dbconnect{
      
$dbh = DBI->connect("DBIg:dbname=NRF; host=127.0.0.1", "dbadmin","123456",{
        PrintError => 0,
        RaiseError=>1   
   }
) || die $DBI::errstr;
}

dbconnect();

小帥哥飛飛

"DBI:pg:dbname

大大狗

$dbh = DBI->connect("DBI:pg:dbname=NRF", "dbadmin","123456",{
   

這樣試試

小帥哥飛飛

忘記了寫上port=... 謝謝樓上，

不過PostgreSQL 的DBD:g          Perl Driver 真是難安裝啊，居然要求先安裝上PostgreSQL Database, 俺不想安裝，因為俺想連接的的數(shù)據(jù)庫已經(jīng)在遠程安好了。