How to run a basic PostGreSQL in Kubernetes!

Subscribe to show your support! goo.gl/1Ty1Q2 .
Patreon 👉🏽 / marceldempers
Checkout the source code below 👇🏽 and follow along 🤓
Also if you want to support the channel further, become a member 😎
marceldempers.dev/join
Checkout "That DevOps Community" too
marceldempers.dev/community
Source Code 🧐
--------------------------------------------------------------
github.com/marcel-dempers/doc...
If you are new to Kubernetes, check out my getting started playlist on Kubernetes below :)
Kubernetes Guide for Beginners:
---------------------------------------------------
• Kubernetes development...
Kubernetes Monitoring Guide:
-----------------------------------------------
• Kubernetes Monitoring ...
Kubernetes Secret Management Guide:
--------------------------------------------------------------
• Kubernetes Secret Mana...
Like and Subscribe for more :)
Follow me on socials!
marceldempers.dev
Twitter | / marceldempers
GitHub | github.com/marcel-dempers
Facebook | thatdevopsguy
LinkedIn | / marceldempers
Instagram | / thatdevopsguy
Music:
Track: Reckoner - lofi hip hop chill beats for study~game~sleep | is licensed under a Creative Commons Attribution licence (creativecommons.org/licenses/...)
Listen: / reckoner-lofi-hip-hop-...
Track: souKo - souKo - Parallel | is licensed under a Creative Commons Attribution licence (creativecommons.org/licenses/...)
Listen: / parallel

[@MarcelDempers]

The PostgreSQL Series -> kzbin.info/aero/PLHq1uqvAteVsnMSMVp-Tcb0MSBVKQ7GLg

[@haraldhacker]

Please continue this. Also focus for production grade setups

[@la151212511111]

Hey Marcel, Thanks :) just thanks. I didn't go that route, but your series on k8s has been instrumental in my career direction ! now wih kuber abilities !! TY sir !

[@mroshan74]

Hi Marcel, good to see you back. Always loved your delivery ❤

[@intsanerarity9689]

you are a legend, will there be the last part of this video series?

[@tmortada]

Thanks Marcel, great content!

[@azrafal]

Sir please make some videos on Cassandra. Learned a lot from your videos. Thank you very much.

[@tiagomedeiros7935]

Thank you. I would like to suggest a future video about karpenter

[@Fullflexno]

Hey, big guy, Marcel! Thanks for providing so much quality content, pleas hurry up and give us more 🥺❤

[@pigrebanto]

thanks and well done! Is the next video yet to come?

[@lior3300]

love your videos, you are a true professional and a grate tutor. waiting for your next video on the topic.

[@Fullflexno]

100% Agreed. Super videos! Waiging for more!

[@ValleJulien]

Thank you for this interesting and insightful series of videos on setting up a PostgreSQL cluster. When can we expect the next video? I need the following ! I'm currently in the process of deploying my own PostgreSQL cluster on AKS. It would be great and helpful to have and see a demonstration of how to configure replication on Kubernetes and automate the primary promotion to the replica in case of failover (along with guidance on configuring for production environments). Excellent work :) I'm looking forward to the next video, which I hope will arrive very soon.

[@bainscho3267]

These videos are incredible

[@tayyabfayyaz8837]

Great explanation sir, it would be helpful if your similar tutorial PG bouncer with a same of different namespace.

[@idouxda]

Do you have a Flyway Series?

[@dillonhansen71]

I love that you keep saying "You will lose data". People need to hear that.

[@sixwins-devops]

You just gotta love the swords.

[@RockyScenes]

Thank you for this. If you have a replica of a pod, and the main one dies, then the replica dies, are you out of luck and the data is lost? Or are replicas constantly created?

[@splashinventor]

Hello Marcel, I am one of the subscribers to your channel. Your videos are quite informative and very helpful in understanding the technology. -:) I have couple of doubts related to tools that are used. Could you please help clarify these doubts please? In REAL WORLD projects, tools such as Jenkins, ELK stack, Databases, RabbitMQ/ActiveMQ, Kafka etc. are generally provisioned on EC2s (or) Vendor provided/managed cloud environments (SaaS) (or) Cloud Provider(AWS/Azure etc.) specific provided/managed environments but not on Kubernetes/EKS? And, Only microservices are deployed on K8s clusters and they connect to these tools via K8s environment configurations? It is very confusing and struggling to understand as most of the tutorials/examples in Internet are showcasing above mentioned tools to provision on K8s along with microservices. Kindly help clarifying the doubt! Thank you.. :-)

[@JuanNicolas]

hey Marcel, thanks for these videos, they helped me a lot. Is there any update on the replication 2nd part of this? I Tried to figure out how to create the secondary pods as replication server but, I'm still stuck on the configmap and if I need to use a second statefulset yaml file for that to provide new configmap configurations.

[@Babbili]

if i have 3 replicas StatfulSet, is the data automatically replicated into the 3 pods' volumes if i created the data through a client pod connecting to the headless postgres svc

[@suhasadduri1691]

you are a gem 💎

[@rachanadesai5996]

Hi Marcel! why do i get this error "CreateContainerConfigError" instead of "Running" status when I run "kubectl -n postgresql get pods" command

[@MrGenbu]

When is the next videos coming out ?

[@MrGenbu]

can you please make one for mongodb replicaset its very frustrating

[@IIGrudge]

You most likely won't be doing this in the real world as handling stateful workload robustly is quite a challenge on K8s. Better to use an operator like Zalando to handle things like HA, backups, upgrades.

[@MarcelDempers]

It's all a double edged sword but the fundamental knowledge is crucial : 1) Most teams don't know enough about PostgreSQL (including myself) 2) Many also don't understand the nature of statefulsets in immutable hosted Kubernetes where nodes can be recreated by cloud providers. (nodes can come and go) 3) Operators often trap new folks since the abstraction is too deep for folks to unfold and since they dont understand PostgreSQL replication. If the operator fails, the engineers are scratching their heads. Therefore it's crucial to understand the boundaries and the underlying configs and how they work before commiting to something like an Operator that automates it all. Operators are something we can cover in later parts of the series when a foundation of knowledge is met With all this information I would often resort to recommending a PostgreSQL-as-a-Service with your cloud provider instead. It's fairly cheap and takes the engineering burden away from the teams. Hope that helps folks who are evaluating databases on K8s

[@zhbitjean]

how to install kind?

[@zhbitjean]

I feel like all these commands are running on my local machine, how do I push it to google Kubernetes? Anyone has similar issue?

[@lior3300]

when you want to run kubectl commands on your GCP cluster you have to "bind" to it using your cloud shell. go to the cluster page and click on the 3 dots of the cluster you want to run these commands on, then you will see a window that gives you the gcloud command to access the cluster. you can run it in the shell or on your machine.

[@KhodeCamp]

Thank you so much and can't wait for next video!