Pgpool-II Tutorial

[@ButchHammer]

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

[@MrBibber]

incredibilly well done tutorial. keep up the good work!

[@RobertFuszenecker]

Thank you very much for this brilliant and comprehensive tutorial.

[@vinothj1649]

Its so clear and crystal.

[@marccawood]

This video saved my life.

[@arashx404]

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

[@jesseinit]

This is high quality.

[@m.imranzaheer1368]

Nice explanation... appreciated 👏👏

[@utkarshshukla2448]

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

[@jasminstrkonjic]

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

[@ashokpatil4027]

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

[@dnyandeep11]

vow hatsoff you have explianed too good

[@abhishektripathi27]

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

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

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

[@anbiabohlam5468]

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

[@414121]

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!!!

[@wolfganghaemmer]

Thank you!🙂

[@emredemiralay2675]

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

[@kbpmowrya]

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

[@mysuperemecy]

Very nice tutorial, if possible make a video on citusdata

[@pclokcer]

this is very well

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

[@vitache1276]

Thanks!!

[@medAmineRg]

thankyou

[@doniyorbekrajabov3104]

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.

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

[@ZarkoAjdukovic-lz5fr]

Executed exactly as shown and postgresql.conf is missing in the replica (postgresql 15.1, Debian 11.5)

[@Ash-td4sx]

pgpool2 is repeatedly searching for primary node and has only detected standby node i have already tried restarting pgpool what should i do

[@rammurthy05]

is streaming replication mandatory for automatic failover?

[@KuyaJeffGamingChannelOfficial]

@high-performance programming, on 15:03 of your video. how can I enter in pgpool.conf (backend_data_directory0) the path of the “data” folder of my pgsql if it is in windows environment? I am your one of your student in udemy.

[@ciurlizzaascencio1501]

👏

[@medAmineRg]

guys i have a question, how i can download pgpool in windows ?

[@Delicatamente]

man you are awesome! thank you!

[@MrBibber]

After watching it multiple times: Please next time make it a bit louder. Also a transcript would be nice, to be able to copy the commands for example.

[@Piyushmishrabanaras]

Kindly help, have configured standby in pgpool.conf as you explained, but its not detecting. What could be the possibility. 2023-01-02 20:39:12.466: main pid 2971668: DETAIL: socket(::) failed: "Address family not supported by protocol" 2023-01-02 20:39:12.474: main pid 2971668: LOG: find_primary_node_repeatedly: waiting for finding a primary node 2023-01-02 20:39:12.479: main pid 2971668: LOG: find_primary_node: primary node is 0 2023-01-02 20:39:12.480: main pid 2971668: LOG: pgpool-II successfully started. version 4.3.3 (tamahomeboshi) 2023-01-02 20:39:12.480: main pid 2971668: LOG: node status[0]: 1 2023-01-02 20:39:12.480: main pid 2971668: LOG: node status[1]: 0 2023-01-02 20:39:12.481: pcp_main pid 2971705: LOG: PCP process: 2971705 started 2023-01-02 20:39:12.481: sr_check_worker pid 2971706: LOG: process started 2023-01-02 20:39:12.481: health_check pid 2971707: LOG: process started

[@aissabilek2094]

i have the same probleme did u find a solution?

[@mahditayeb1046]

incredibilly well done tutorial. keep up the good work!