Day 11 Postgres DB Service Using EKS Storage.

(1) Introduction:

• We are going to create a Postgres database with persistence storage using AWS EBS Volumes.

(2) Create the following Kubernetes manifests.

• Reference: https://github.com/m3pratik/31daysofEKS/tree/main/day-11-postgres-db-service-using-eks-storage/kube-configs

(i) Create a Storage Class manifest.

• Reference: https://docs.aws.amazon.com/eks/latest/userguide/storage-classes.html

(ii) Create Persistent Volume Claims manifest.

# Create Storage Class & PVC
kubectl apply -f kube-configs/

# List Storage Classes
kubectl get sc

# List PVC
kubectl get pvc 

# List PV
kubectl get pv

(iii) Create ConfigMap manifest

• We are going to create a railsv1 database during the postgres pod creation. we will use it when we deploy Application Microservice.

(iv) Create Postgres Deployment.

• Environment Variables

• Volumes

• Volume Mounts

(v) Create Postgres ClusterIP Service manifest.

• At any point in time, we are going to have only one postgres pod in this design so ClusterIP: None will use the Pod IP Address instead of creating or allocating a separate IP for Postgres Cluster IP service.

(3) Create Postgres Database with all the above Kube-configs.

# Create Postgres Database
kubectl apply -f kube-manifests/

# List Storage Classes
kubectl get sc

# List PVC
kubectl get pvc 

# List PV
kubectl get pv

# List pods
kubectl get pods 

# List pods based on  label name
kubectl get pods -l app=postgres

(4) Connect to Postgres Database.

kubectl exec -it pod-name -- psql -U postgres

(5) Verify 'railsv1' DB is created.

Made with ♥ by Pratikkumar Panchal