Pgpool-II Tutorial

0:00 - Introduction
0:41 - Pgpool-II Features
3:57 - Configure Pgpool-II with Streaming Replication
5:04 - Setting up Streaming Replication
10:57 - Configuring Pgpool-II for Load Balancing
17:38 - Testing load-balancing & read/write separation
21:03 - Configure Pgpool for PostgreSQL High-Availability
22:01 - Configuring PostgreSQL Primary Server
24:34 - Configuring Pgpool-II Server
26:59 - Configuring PostgreSQL Replica Server
28:23 - Testing The Failover
30:34 - Restoring failed nodes

🐘 Want to find out MORE about Scaling PostgreSQL?
Use the link below to get 60% OFF on the Entire Course.

[ButchHammer]

Thank you for this video. It makes me more confident to join my new team !

[RobertFuszenecker]

Thank you very much for this brilliant and comprehensive tutorial.

[MrBibber]

incredibilly well done tutorial.
keep up the good work!

[arashx]

thank you for this high quality - top level programming course's

[jasminstrkonjic]

very very good job sir. you helped me a lot. keep up the good work.

[dnyandeep]

vow hatsoff you have explianed too good

[utkarshshukla]

thank you sir, can you please make complete video on postgres HA data replication with failover and load balancing using HAProxy also with latest postgres version like 14 or 15

[ashokpatil]

Very nicely explained...keep it up the good work.. it will be good if same can be explained for pgbouncer..

[lacascadaobregon]

Awesome content. I would suggest to make the sound louder, as I am using headphones and need to watch my online learning videos in silence.

Thanks!

[abhishektripathi]

Can you also create tutorial to setup two pgpool servers to pgpool HA please?

[anbiabohlam]

great tutorial video, but perhaps you can provide using VM with bridge network configuration to simulate multiple hosts for next video

thanks anyway

[emredemiralay]

wonderful !!! please share repmgr and other high availability examples. warm and hot replicas

Your video gives a great idea of HA using pgpool, congrats! I’m trying to implement this but in a more real use case where master and standby are different machines. I saw in documentation that pgpool deals with virtual IP. It’s not clear to me if pgpool manages the virtual IP itself or if I need to configure keepalived together with pgpool.

[kuliserper]

Thank you so muchh!, your video is very helpfull!!!

[AnthoninPRESSE]

Really nice tutorial !
Straghtforward and clean one ! love it.

But i still got a quick question, in case of distributed cluster (3 nodes, on 3 machines) should i setup a pgpool on each of the postgres nodes ?

Thanks !

[mysuperemecy]

Very nice tutorial, if possible make a video on citusdata

[doniyorbekrajabov]

This is amazing. Thank you for the video. Can you give me little bit explenation how to do this with remote database clusters. For example DigitalOcean Managed Database Clusters. I am having trouble with it. Please.

[kbpmowrya]

How are you stoped Pgpool not to do steaming replication as you are configuring replication manually.

[thangdm]

can you describe more details about automatic failover? i am using docker/kubernetes to deploy the database, so it would be kind of you to show me how. Thank you a lot

[puneetmathur]

Hey mate, great tutorials on Postgres & pgpool.
I have a question, if I may. I would like to run pgpool on a server separate to the one(s) running Postgres. Do I need to install Postgres server& create a cluster in the server running pgpool? When I run pgpool on a standalone server as user postgres (which gets created during install), it keeps looking for /var/run/postgres directory!Thanks.