| From: | Joseph Kregloh <jkregloh(at)sproutloud(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Log Shipping |
| Date: | 2016-05-31 19:58:59 |
| Message-ID: | CAAW2xfcjjTUeTzytQ9r9OY=LMMByrLodeN78DLcgDAGJR55D4w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)192(dot)168(dot)1(dot)105:archive/$2 < /dev/null;
# Slave 2
rsync -a $1 pg(at)192(dot)168(dot)1(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2016-05-31 20:12:15 | Re: Log Shipping |
| Previous Message | Jean-Marc Lessard | 2016-05-31 19:42:56 | postgres_fdw and Kerberos authentication |