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.