Use an External PostgreSQL Database in the JFrog Platform Installation

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

Create a 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 command. You must create the database and users before you run the Helm install or upgrade command.

For more information about using an external database, see Using an External Database.