SSIS Components for DigitalOcean

Build 20.0.7587


Retrieve information regarding PostgreSQL database connection pools.

View Specific Information


Digital Ocean supports only DatabaseId and Name columns with "=" operator as filter criteria for this view.

Note: The DatabaseId columns is a required filter. The driver will fetch a list of all database clusters if this filter is not present as part of the criteria.

SELECT * FROM DatabaseConnectionPools WHERE DatabaseId='9cc10173-e9ea-4176-9dbc-a4cee4c4ff30' AND Name = 'DatabaseName'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any other search criteria will be ignored and an unfiltered response will be returned.


Name Type References Description
Name [KEY] String The name for the connection pool.
DatabaseId String


A unique ID that can be used to identify and reference a database cluster.
ConnectionDatabase String The name of the default database.
ConnectionHost String The FQDN pointing to the database cluster's current primary node.
ConnectionPassword String The randomly generated password for the default user.
ConnectionPort Integer The port on which the database cluster is listening.
ConnectionSsl Boolean A boolean value indicating if the connection should be made over SSL.
ConnectionUri String A connection string in the format accepted by the psql command. This is provided as a convenience and should be able to be constructed by the other attributes.
ConnectionUser String The default user for the database.
Database String The database for use with the connection pool.
User String The name of the user for use with the connection pool.
Size Integer The size of the PGBouncer connection pool.
Mode String The PGBouncer pool mode for the connection pool. The allowed values are session, transaction, and statement.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587