cluster_mgr pg连接失败，导致句柄

[jd-zhang]

Issue migrated from trac ticket # 556

component: DBA GUI | priority: major

2022-04-06 17:42:08: barney created the issue

---

int PGSQL_CONN::connect(const char *database)
{
if(connected && db == database)
return 0;
else
close_conn();

char conninfo[256];
sprintf(conninfo, "dbname=%s host=%s port=%d user=%s password=%s",
database, ip.c_str(), port, user.c_str(), pwd.c_str());

conn = PQconnectdb(conninfo);

if (PQstatus(conn) != CONNECTION_OK)
{
syslog(Logger::ERROR, "Connected to pgsql fail: %s", PQerrorMessage(conn));

          PQfinish(conn);   //pg socket leak.
  return 1;

}

db = database;
connected = true;

return 0;
}