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 !
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.
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.
@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.
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.
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
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
Thank you for this video. It makes me more confident to join my new team !
Thank you very much for this brilliant and comprehensive tutorial.
incredibilly well done tutorial.
keep up the good work!
This video saved my life.
Its so clear and crystal.
thank you for this high quality - top level programming course's
very very good job sir. you helped me a lot. keep up the good work.
Nice explanation... appreciated 👏👏
vow hatsoff you have explianed too good
Can you also create tutorial to setup two pgpool servers to pgpool HA please?
This is high quality.
Very nicely explained...keep it up the good work.. it will be good if same can be explained for pgbouncer..
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 !
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!
Thank you so muchh!, your video is very helpfull!!!
great tutorial video, but perhaps you can provide using VM with bridge network configuration to simulate multiple hosts for next video
thanks anyway
wonderful !!! please share repmgr and other high availability examples. warm and hot replicas
thankyou
Thank you!🙂
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.
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.
How are you stoped Pgpool not to do steaming replication as you are configuring replication manually.
Very nice tutorial, if possible make a video on citusdata
this is very well
@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.
man you are awesome! thank you!
Thanks!!
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.
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)
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
guys i have a question, how i can download pgpool in windows ?
is streaming replication mandatory for automatic failover?
👏
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!