AnalyticDB:libpq

Prerequisites

• The internal or public endpoint of an AnalyticDB for PostgreSQL instance is obtained.

  • If your client is deployed on an Elastic Compute Service (ECS) instance that resides in the same region and uses the same network type as the AnalyticDB for PostgreSQL instance, you can use the internal endpoint to connect to the AnalyticDB for PostgreSQL instance. Log on to the AnalyticDB for PostgreSQL console. In the Database Connection Information section of the Basic Information page, view the internal endpoint of the instance.

  • If your client is deployed on an ECS instance that resides in a different region or uses a different network type from your AnalyticDB for PostgreSQL instance or a system outside Alibaba Cloud, you must apply for a public endpoint and then use the public endpoint to connect to the AnalyticDB for PostgreSQL instance. For more information about how to apply for a public endpoint, see Manage public endpoints.

• The IP address of your client is added to an IP address whitelist of the AnalyticDB for PostgreSQL instance. For more information, see Configure an IP address whitelist.

Procedure

After you install Greenplum or PostgreSQL, you can find the static and dynamic libraries of libpq in the lib directory.

• For information about libpq connection cases, see the following topics:

  • AnalyticDB for PostgreSQL V6.0: Example Programs.

  • AnalyticDB for PostgreSQL V7.0: Example Programs.

• For more information about libpq, see the following topics:

  • AnalyticDB for PostgreSQL V6.0: libpq - C Library.

  • AnalyticDB for PostgreSQL V7.0: ibpq - C Library.

References

The Greenplum official website provides a libpq package that is easy to use. For more information, see the Greenplum documentation.