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, 俺不想安装，因为俺想连接的的数据库已经在远程安好了。