How to replicate PostgreSQL with Docker for beginners

Checkout the source code below 👇🏽 and follow along 🤓

Also if you want to support the channel further, become a member 😎

Checkout "That DevOps Community" too

Source Code 🧐
--------------------------------------------------------------

Like and Subscribe for more :)

Follow me on socials!

Music:

[MarcelDempers]

Checkout the full playlist for learning PostgreSQL from scratch! 💪🏽👇🏽

Hey Marcel. It took a time to this Video I waited for. So Great Explantation - thank you so much. Looking forward to the 4th one in this Season. Well done - pls keep going in this way - I Like it very much.

[FabianoChagas]

You just saved my day, mate.
I’m looking for this solution for while and you solved it so easily
Thanks for sharing
🙏🏻

[sohansingh]

Recently found your channel and absoluely loved it!

[andreasheckel]

Great Work and fantastic explanation ! ... can't wait to see the next part on how to run that Postgres setup within Kubernetes 👍

[Rockshoes]

YOU ARE GREAT, i was able to set up my Immich DB in HA thanks to you.

[charliex]

Hey Marcel. Thank you for your videos. I love them. Keep on going!

[oldcmputer]

I copied your repo exactly except I turned your docker run command into a docker-compose yml file. Does the same thing. I am creating the archive, config & data folders as my user which is a member of the docker group and in my own home dir. When I run docker-compose up on postgres-1, the archive folder is owned by root and in the postgres logs, I see:
2024-03-08 16:39:47.235 UTC [1] LOG: database system is ready to accept connections
cp: cannot create regular file Permission denied

[Shubham__Saroj]

Your videos are awesome as always and very helpful. Can we please have some video on using operators in Kubernetes considering some datastore like mongodb. Covering basic of CRDs

[chenyangxiong]

The postgres-1 exposes the port on 5000:5432. When connecting postgres-1 from postgres-2, which port should I use? I think it should be 5000 instead of 5432.

[mohameammaha]

Thank you so much for this video. What about BDR(multi masters) replication on Docker or Kubernetes are there any open sources solutions for data sync?

[zhbitjean]

anyone know how to start the command line as bash? Did I miss something? I have been using cmd in windows and might have miss some steps. I ended up keep getting: pg_basebackup: error: connection to server at "postgres-1" (172.20.0.2), port 5432 failed: FATAL: no pg_hba.conf entry for replication connection from host "172.20.0.3", user "replicationUser", no encryption after I added host replication replicationUser 172.20.0.2/32 trust to pg_hba.conf

[daniela.]

Unfortunately the replication is not working at all. I've tried everything I could but no

[munroegarrett]

I have been wrestling with replicating Supabase with automatic promotion. This is excellent timing. Thank you.

[nandiniachugatla]

After promoting server 2 to create table the data replication is stopped .
How to acheive data replication after promoting server 2 to create table.

[nandiniachugatla]

Great Tutorial. Here we did data replication from server 1 to server2 how can we do vice versa -- server2 to server 1 replication
??

[ukaszrzasa]

dislike due to "chapter X" instead of list of content...