How to replicate PostgreSQL with Docker for beginners

[@MarcelDempers]

Checkout the full playlist for learning PostgreSQL from scratch! 💪🏽👇🏽 kzbin.info/aero/PLHq1uqvAteVsnMSMVp-Tcb0MSBVKQ7GLg&si=igTb_kMndQyxodpI

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.

[@sohansingh2022]

Recently found your channel and absoluely loved it!

[@FabianoChagas]

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

[@andreasheckel1061]

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

[@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

[@charlie64x2]

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

[@Rockshoes1]

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

[@chenyangxiong9804]

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.

[@annusingh4694]

Thanks for the helpful videos

[@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 '/mnt/server/archive/000000010000000000000001': Permission denied

[@brijeshdave]

Same issue for me

[@brijeshdave]

Have you found any workaround?

[@basketballguy17]

Late but you just have to run sudo chown 999:999 on the archive folder on your local machine

[@jonny.rubber]

Hey, Thanks for everything

[@mohameammaha99]

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?

[@stanleychukwu7424]

thank you champ!!! GOD bless you!

[@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

[@rudydotdev]

Great work!

[@nandiniachugatla932]

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

[@daniela.2349]

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

[@thodorispaparrigopoulos8542]

What do you mean by its not working at all? Can you share your project files ? What errors do you see ?

[@b2c205]

nice video mate

[@Fullflexno]

10/10 content!

[@munroegarrett]

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

[@inteliconn995]

Thanks!

[@markdabasol6707]

Lets go!

[@jricardo2012]

Top top !!

[@nandiniachugatla932]

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

[@Septumsempra8818]

🇿🇦🇿🇦🇿🇦🇿🇦🇿🇦🇿🇦

[@ukaszrzasa1980]

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