Use an External PostgreSQL Database in the JFrog Platform Installation

JFrog Installation & Setup Documentation

ft:sourceType
Paligo

You can configure the JFrog Platform installation to use an external PostgreSQL database instead of the bundled PostgreSQL database.

Create values-external-postgresql.yaml file with the following YAML configuration.

global:
  database:
    initDBCreation: false
postgresql:
  enabled: false
artifactory:
  database:
    type: postgresql
    driver: org.postgresql.Driver
    url: 'jdbc:postgresql://${POSTGRESQL_HOST}:${POSTGRESQL_PORT}/${ARTIFACTORY_DATABASE}'
    user: ${ARTIFACTORY_DATABASE_USER}
    password: ${ARTIFACTORY_DATABASE_PASSWORD}
xray:
  database:
    url: 'postgres://${POSTGRESQL_HOST}:${POSTGRESQL_PORT}/${XRAY_DATABASE}?sslmode=disable'
    user: ${XRAY_DATABASE_USER}
    password: ${XRAY_DATABASE_PASSWORD}
distribution:
  database:
    url: 'jdbc:postgresql://${POSTGRESQL_HOST}:${POSTGRESQL_PORT}/${DISTRIBUTION_DATABASE}?sslmode=disable'
    user: ${DISTRIBUTION_DATABASE_USER}
    password: ${DISTRIBUTION_DATABASE_PASSWORD}
insight:
  database:
    url: 'jdbc:postgresql://${POSTGRESQL_HOST}:${POSTGRESQL_PORT}/${INSIGHT_DATABASE}'
    user: ${INSIGHT_DATABASE_USER}
    password: ${INSIGHT_DATABASE_PASSWORD}
pipelines:
  global:
    postgresql:
      user: ${PIPELINES_DATABASE_USER}
      password: ${PIPELINES_DATABASE_PASSWORD}
      host: ${POSTGRESQL_HOST}
      port: 5432
      database: ${PIPELINES_DATABASE}
      ssl: false / true

Set postgresql.enabled=false in the YAML file and provide the external database details before you run the helm install or upgrade. You must create the database and users before you run Helm install or upgrade. If you use Mission Control, you must set up databases, users, and schemas. For more information, refer to Setting up Your Postgre SQL Databases, Users, and Schemas.

Refer the Using an External Database for more information on using an external database.

Note

You can also provide the database configuration using database.secrets in the YAML file. For more information, see Kubernetes Secrets.