Production grade Postgres with Docker | Docker Athens | 24 Jan 2024

Presentation of ‪@ParisKasidiaris‬ the Docker Athens User Group (https://docker.gr) on how to set up "Production grade Postgres with Docker" with high availability, fault tolerance and load balancing with about 100 lines of code.

Slide deck is available at https://withlogic.co/decks/2024-01-24....

Open source code available at https://github.com/withlogicco/postgres.

---

If you need help in adopting Docker and DevOps practices, or save infrastructure (cloud) costs in your organization, we at LOGIC (https://withlogic.co/devops), would love to help. Just send us an email at [email protected] and we will get back to you by the next working day maximum.

#postgres #postgresql #docker #devops #platformengineering #cloud #meetup

The world with LOGIC:
Website - https://withlogic.co
X - https://x.com/withlogicco
Instagram -   / withlogicco  
LinkedIn -   / withlogic  

Chapters:
00:00:00 Production grade Postgres with Docker | Docker Athens | 24 Jan 2024
00:00:04 Introduction to Docker Athens, a community for Docker users
00:03:17 Discussing drawbacks of managed database services like RDS and Aurora
00:06:34 Requirements for Postgres setup: easy deployment, scalability, high availability
00:10:51 High availability: minimal user impact during server failures
00:14:14 Explaining Point-in-Time recovery for Postgres databases
00:21:59 Maintaining a fault-tolerant setup and upgrade considerations
00:25:09 Explaining how PgPool || is stateless and aware of connections
00:31:24 Introduction and overview of the setup
00:35:26 Configuring and setting up the servers
00:40:10 Exploring the use of Dockerfile and target naming
00:41:34 Setting up initialization scripts for Docker image
00:53:20 The advantages of running secondary servers on separate machines
01:00:03 Primary and secondary servers successfully connected and running
01:02:13 Run test SQL queries
01:03:48 Testing load balancing with PgPool ||
01:06:46 Running on secondary: Consistent behavior
01:07:16 Amazing efficiency of Postgres, PgPool ||, and Docker developers
01:10:26 Stopping the primary server and checking status
01:14:25 Exploring running the setup on multiple machines
01:14:45 Restarting the primary server has no effect
01:18:17 Introduction and thanking the audience