Using an Existing PostgreSQL Database

If you plan to use an existing database—one that is not created by default by the Operator-based installer—you must configure the relevant database parameters in the daideploy_cr.yaml file.

Note: Skip this section if you do not want to use your own database instance. The Digital.ai Deploy Operator creates a PostgreSQL instance by default. This procedure is for those who want to use an existing PostgreSQL database server with Digital.ai Deploy.

Using an Existing Database

Create the PostgreSQL database in your existing PostgreSQL server if not done already. See the following SQL commands, for example.

CREATE USER <xld-username> WITH
NOSUPERUSER
NOCREATEDB
NOCREATEROLE
ENCRYPTED PASSWORD '<xld-password>';

CREATE DATABASE <xld-database-name>;
GRANT <xld-database-name> TO postgres;

ALTER ROLE <xld-username> WITH PASSWORD '<xld-password>';
ALTER DATABASE <xld-database-name> OWNER to <xld-username>;

Once you have your database up and running, set the following parameters in the daideploy_cr.yaml file:

  • postgresql.install: false—with this setting, the Operator-based installer skips the default PostgreSQL database installation.
  • UseExistingDB.Enabled: true—with this setting, Deploy is being set up to use an existing database.
  • UseExistingDB.XL_DB_URL: jdbc:postgresql://<postgres-service-name>.<namespace>.svc.cluster.local:5432/<xld-database-name>—the existing PostgreSQL database server URL
  • UseExistingDB.XL_DB_USERNAME: Database User for xl-deploy—PostgreSQL database user name
  • UseExistingDB.XL_DB_PASSWORD: Database Password for xl-deploy—PostgreSQL database password

Here’s an example.

UseExistingDB:
  Enabled: true # If you want to use an existing database, change the value to "true". Uncomment the following lines and provide the values.
  XL_DB_URL: jdbc:postgresql://xld-production-postgresql.default.svc.cluster.local:5432/<xld-database-name>
  XL_DB_USERNAME: <xld-username>
  XL_DB_PASSWORD: <xld-password>

Note: If you have your database instance running outside the cluster, configure the parameters above to match your setup.