It is my understanding that if PostgeSQL has log shipping enabled, if for whatever reason it cannot ship the file the master server will hold it. But for how long?
Secondly, I have 2 servers I ship log files to using the following script:
#!/usr/local/bin/bash
# Slave 1
rsync -a $1 pgi@192.168.1.105:archive/$2 < /dev/null;
# Slave 2
rsync -a $1 pg@192.168.1.93:archive/$2 < /dev/null;
In this case if Slave 1 is up but Slave 2 is down. It will ship the log file to Slave 1 but not Slave 2 and move one. Thereby Slave 2 will now be out of sync, correct?
To allow both slaves to remain in sync when one is restarted I would need to modify my script to return an error or false to PostgreSQL, this way it will hold the WAL files until both Slaves are online. Correct?
Thanks,
-Joseph
