PostgreSQL

PostgreSQL Server Deployment

This guide provides instructions to install PostgreSQL Server on the Kubernetes cluster. However, if you already have PostgreSQL server installed, or are using Cloud hosted Postgres, then you may skip the server installation. The instructions to initialize OpenG2P component databases are provided as part of the component installation instructions.

Databases

Module/component-wise listing of databases is given below

Module/Component	Database Name
PBMS	openg2pdb
Keycloak	keycloakdb
ODK	odkdb
SPAR	spardb
G2P Bridge	gctbdb
MOSIP Key Manager	mosip_keymgr

Prerequisites

• The following utilities/tools must be present on the user's machine.

  • kubectl, istioctl, helm, jq, curl, wget, git, bash, envsubst.

Installation

• Clone the https://github.com/openg2p/openg2p-deployment repo and navigate to kubernetes/postgresql directory.

• Run:

  ./install.sh