PostgreSQL Extension can be used as Diyotta External Metadata repository or as Postgresql Process Engine. Both options will configure PostgreSQL differently.
Follow the system requirements guide to see minimum hardware configuration to install PostgreSQL.
Create a dedicated user for installation and setup home directory under "/app". If the installation is being done on the same server as Controller then add the user to the "diyotta" group.
# useradd -d /app/dipostgres -g diyotta dipostgres
# passwd dipostgres
Note: You are free to create the directories and dedicated user names of your own choice. However, the standard approach is mentioned in the commands above and is recommended as best practice.
Download the installer from the Diyotta release site as described in the page - Download Installer.
PostgreSQL extension can be installed in two modes:
Post installation setup
Setup the environment variables
Set the PG_HOME environment variable in .bash_profile / .bashrc / .kshrc of the user under which PostgreSQL extension is installed. PG_HOME should be set to <your postgreSQL extension installation folder>/postgres.
If the PostgreSQL extension is installed under /app/dipostgres then, the PG_HOME must be set to /app/dipostgres/postgres.
In .bash_profile or .bashrc set the environment variable as below.
# vi ~/.bash_profile
In .kshrc set the environment variable as below.
# vi ~/.kshrc
Start the PostgreSQL service
Start the PostgreSQL Database using below command.
Refer Restoring PostgreSQL Metadata Repository to restore Diyotta metadata from another repository.
Refer Backing up PostgreSQL Metadata Repository to schedule regular backup of Diyotta metadata repository.