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
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 !
@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.
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.
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
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.
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.
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
incredibilly well done tutorial.
keep up the good work!
Thank you very much for this brilliant and comprehensive tutorial.
Its so clear and crystal.
This video saved my life.
Thank you for this video. It makes me more confident to join my new team !
Nice explanation... appreciated 👏👏
thank you for this high quality - top level programming course's
Can you also create tutorial to setup two pgpool servers to pgpool HA please?
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
very very good job sir. you helped me a lot. keep up the good work.
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 !
@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.
vow hatsoff you have explianed too good
This is high quality.
regarding failover , postgres16 and pgpoolII 4.5 change the behaviours
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.
Very nicely explained...keep it up the good work.. it will be good if same can be explained for pgbouncer..
How are you stoped Pgpool not to do steaming replication as you are configuring replication manually.
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!
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
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.
Very nice tutorial, if possible make a video on citusdata
great tutorial video, but perhaps you can provide using VM with bridge network configuration to simulate multiple hosts for next video
thanks anyway
is streaming replication mandatory for automatic failover?
pgpool2 is repeatedly searching for primary node and has only detected standby node i have already tried restarting pgpool what should i do
Executed exactly as shown and postgresql.conf is missing in the replica (postgresql 15.1, Debian 11.5)
this is very well
Thank you!🙂
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.
guys i have a question, how i can download pgpool in windows ?
Thank you so muchh!, your video is very helpfull!!!
Thanks!!
thankyou
👏
man you are awesome! thank you!
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.
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
i have the same probleme did u find a solution?
incredibilly well done tutorial.
keep up the good work!