Procedure for Configuring PostgreSQL Database Settings for Paradigm

This section will guide you through the necessary steps to configure your PostgreSQL instance for use with Paradigm, managed by LightOn.

Selection of the PostgreSQL Instance

• Choose between a LightOn-Managed PostgreSQL Instance or a Custom PostgreSQL Instance.
  • If you opt for the LightOn-managed instance, the database configuration will be pre-filled for optimized use.
  • If you choose the custom option, you will need to provide additional details such as the IP address and port of the PostgreSQL server.

Configuration of the Database Superuser

• Specify the name of the PostgreSQL database superuser.
  • Default Value: postgres
  • This account has full privileges on the database.

Default Database Table Name

• Set a name for the default database table.
  • Default Value: paradigm
  • A descriptive name helps to easily identify the database among others.

PostgreSQL Database Password

• Enter the database password in Base64 format.
  • Base64 encoding adds an extra layer of security during password transmission or storage.

Custom PostgreSQL Instance Configuration

• If you have selected the Custom PostgreSQL option, you will need to provide the IP address and port of the PostgreSQL server.
  • PostgreSQL Database IP Address: Enter the IP address that the Kubernetes cluster can communicate with.
  • PostgreSQL Database Port: Provide the port for communication with the database.
    • Default Port Value: 5432

Saving and Applying Settings

• After filling in all necessary fields, confirm that the information is correct.
• Save the settings to update your Paradigm instance's configuration with the PostgreSQL database details.