Page tree
Skip to end of metadata
Go to start of metadata

PostgreSQL Extension can be used as Diyotta External Metadata repository or as Postgresql Process Engine. Both options will configure PostgreSQL differently.

Installation Prerequisites

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.

#mkdir /app

# 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: 

Interactive Installation

Silent Installation

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
export PG_HOME=/app/dipostgres/postgres

In .kshrc set the environment variable as below.

# vi ~/.kshrc
export PG_HOME

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.

  • No labels