Log Shipping
| От | Joseph Kregloh |
|---|---|
| Тема | Log Shipping |
| Дата | |
| Msg-id | CAAW2xfcjjTUeTzytQ9r9OY=LMMByrLodeN78DLcgDAGJR55D4w@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Log Shipping
|
| Список | pgsql-general |
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
В списке pgsql-general по дате отправления: