Data Management for VMware Tanzu supports provisioning database Service Instances running these PostgreSQL versions:
When you create a PostgreSQL database Service Instance with Data Management for VMware Tanzu, you configure certain PostgreSQL properties.
The Database Instance Configuration properties identify the name of the default database, the database server port number, and the database administrator user credentials.
|Property Name||Description||Default Value|
|Database Name||The name of the default database.||PostgresDB|
|Database Port No||The port number on which the database server runs. (Read-only)||5432|
|Admin Username||The database administrator user name.||admin|
|Admin Password||The password for the database adminstrator.||Admin!23Admin|
The DB Options Configuration properties control certain runtime characteristics of the PostgreSQL database. These are:
|Property Name||Description||Default Value||Restart Required on Update?|
|TimeZone||The time zone for the PostgreSQL server.1||GMT||Yes|
|max_connections||The maximum number of concurrent connections allowed to the PostgreSQL server. Choose a suitable value based on CPU, memory, and application requirements.||100||Yes|
|log_connections||Enable or disable logging of connection attempts and successful completion of authentication.||off||No|
|locale||The language, sorting, number formatting, date/time, currency, etc. preference for the PostgreSQL server.2
Note: You can set the
The following PostgreSQL
1 Run the following PostgreSQL query to obtain the possible time zone values:
SELECT name FROM pg_timezone_names;
2 Be sure to consult the PostgreSQL documentation before you set the
locale or related
To access a PostgreSQL database Service Instance, the host on which the client application is running must have connectivity to the Application Network configured for the instance.
You can use any SQL client application to connect to a database in your PostgreSQL Service Instance. To connect, you must be able to identify the FQDN of the PostgreSQL server host, the port on which the server is running, and the database name. You must also have the PostgreSQL admin credentials on hand. You can obtain this information from the Data Management for VMware Tanzu console as described in Locating the Database Service Instance Connection Parameters.
Refer to SSL Support in the PostgreSQL documentation for more information on using SSL/TLS with PostgreSQL.
verify-fullTLS configuration for client applications connecting to a Service Instance.
You can configure a PostgreSQL Service Instance to require SSL/TLS client connections during creation or after provisioning as follows: