database - 无法连接到 Postgres

Question

我正在尝试连接到 postgres 数据库。无论如何，我做错了什么，因为我收到了这个错误:

invalid connection option "DBI:Pg:dbname"

这里是代码片段:

  my $dbinstance = "DBI:Pg:dbname=DB_NAME;host=111.222.111.2;port=1234";
  my $dbdriver = DBI->install_driver('Pg');
  if ( !$dbdriver ) {
      $dberror = "Load driver: " . $dbdriver->errstr;
  }

  $database = $dbdriver->connect(
        $dbinstance,
        $dbuser,
        $dbpassword,
        {
            RaiseError => 1,
            AutoCommit => 0
        }
    ) or die($dbdriver->errstr);

有什么线索吗？

提前致谢!

问候。

Answer 1

更改以下行:

$database = $dbdriver->connect(...)

用这个:

$database = DBI->connect(...)