AlloyDB for PostgreSQL connection

To access your data in AlloyDB for PostgreSQL, create a connection asset for it.

AlloyDB for PostgreSQL is a PostgreSQL-compatible relational database that runs on Google Cloud AlloyDB.

Create a connection to AlloyDB for PostgreSQL

To create the connection asset, you need these connection details:

  • Database name
  • Hostname or IP address
  • Port number

Select Use Proxy server to enable the use of a proxy server for connecting to a data source.

Certificates

  • Port is SSL-enabled: Enable this option if the port you have chosen is configured to accept SSL connections.

If the Port is SSL-enabled option is enabled, fill in the following fields:

  • SSL certificate: Enter the SSL certificate of the host to be trusted
  • Hostname in SSL certificate: The hostname in SubjectAlternativeName or Common Name (CN) part of the SSL certificate
  • Validate the SSL certificate: Enable this option to validate that the SSL certificate returned by the host is trusted.

Federal Information Processing Standards (FIPS) compliance

This connection is FIPS-compliant and can be used on a FIPS-enabled cluster.

Running SQL statements

To ensure that your SQL statements run correctly, refer to the PostgreSQL language reference for the correct syntax.