pgpool-online-recovery

pgpool-online-recovery copied to clipboard

Hello ,

I followed every step you wrote, but I have one confusion you use /tmp/postgres_master file in if condition in online-recovery.sh but you have not created it any script you wrote, i have question is system create it automatically or what but as per me system don't create any such file if the file is not present there script will not work. Can you help in this?

Hi Swapnil, You are right. fixed here.

I do the same thing in the instructions, but I have not created the file /tmp/postgres_master

root@XAlpha:/etc/pgpool2# cat /etc/pgpool2/pgpool.conf | grep follow_master_command
follow_master_command = 'echo %M > /tmp/postgres_master'

root@XAlpha:/etc/pgpool2# /etc/init.d/pgpool2 restart
[ ok ] Restarting pgpool-II: pgpool.

root@XAlpha:/etc/pgpool2# netstat -lnpt | grep 5431
tcp        0      0 0.0.0.0:5431            0.0.0.0:*               LISTEN      2355/pgpool

root@XAlpha:/etc/pgpool2# ls -la /tmp/
total 8
drwxrwxrwt  2 root root 4096 Dec 23 13:42 .
drwxr-xr-x 23 root root 4096 Dec 19 16:19 ..