
In CAS architecture, users can choose different data planes for different application workloads based on a configuration policy. Select OpenEBS storage engine #Ī storage engine is the data plane component of the IO path of a Persistent Volume. If OpenEBS is already installed, go to the next step. If OpenEBS is not installed in your K8s cluster, this can be done from here. Installing StackGres PostgreSQL Operator.Configure OpenEBS Local PV StorageClass.The recommended configuration is to have at least three nodes and one unclaimed external disk to be attached per node. If users have limited blockdevices attached to some nodes, they can use nodeSelector in the application YAML to provision applications on particular nodes where the available block device is present. No other application can use this device. The Local PV volume will be provisioned on a node where Stackgres PostgreSQL pod is getting scheduled and uses one of the matching unclaimed block devices, which will then use the entire block device for storing data.
#POSTGRES APP OPEN CONSOLE INSTALL#
We will use GKE, where we will install Stackgres PostgreSQL with OpenEBS storage engine. StackGres PostgreSQL is a StatefulSet type and the high performance of OpenEBS Local PV storage engine will be suitable for a persistent storage solution for PostgreSQL databases which can deal with heavy load. It also contains the creation of a sample database, tables and tuples. This guide explains the basic installation for StackGres PostgreSQL on OpenEBS Local PV device. The StatefulSet guarantees that each pod is always bound to its own persistent volume therefore the database instance data will be mapped to the state of a patroni instance inside kubernetes A StackGres cluster is basically a StatefulSet where each pod is a database instance. This stack is made with the help of Kubernetes operator and makes the easy way of packaging, deploying and managing PostgreSQL applications in Kubernetes ecosystem.

The StackGres stack consists of connection pooling, automatic failover and HA, monitoring, backups and DR, centralized logging, and many more.
#POSTGRES APP OPEN CONSOLE FULL#
StackGres is a full stack PostgreSQL distribution for Kubernetes, packed into an easy deployment unit.

This makes it very easy to manage and use by any person with a little knowledge in databases.

It supports a large part of the SQL standard and offers many modern features to ensure the reliability, data integrity, and correctness. PostgreSQL is a powerful, open source object-relational database system.
