Connecting to Managed PostgreSQL

Managed Databases can be reached via the user’s SDN Private Network or Utility network, with the option for public network connectivity. By default, a private connection is enabled. When using SDN Private Networks, access is limited to Cloud Servers linked to those networks. Alternatively, with the Utility network, the database will be accessible from all Cloud Servers within the same data centre as the Managed Database.

At the configuration settings, users can set a preferred hostname. The hostname is used to automatically create DNS entries using a unique subdomain name. Each Managed Database can have up to four DNS entries, one for private and another for public access, as well as read-only access for each.

  • Private: example-mctapmghasah.db.upclouddatabases.com

  • Private read-only: replica-example-mctapmghasah.db.upclouddatabases.com

  • Public: public.example-mctapmghasah.db.upclouddatabases.com

  • Public read-only: public-replica-example-mctapmghasah.db.upclouddatabases.com

PostgreSQL is a registered trademark of the PostgreSQL Community Association of Canada, and used with their permission.