On 06/18/2015 05:45 PM, Paula Price wrote:
I have Postgresql 9.2.10 streaming replication set up with log shipping in case the replication falls behind. I discovered that the log-shipping had been disabled at some point in time. I enabled the log shipping again. If at some point in time the streaming replication fell behind and the standby server was not able to retrieve the necessary WAL file(s) from the primary, would the standby server continue to function normally? Do I need to rebuild the standby server? I have restarted the standby server and it is up and running with no issues.
Well that seems at odds with it being unable to retrieve the WAL files. This leads to these questions:
1) What makes you think it did not retrieve the WAL files via streaming? 2) What does the postgres log show at the time you restarted the standby? I need to know if the
data integrity has been compromised. I have run this query to determine the lag time for the standby(in case this tells me anything): "SELECT now(), now() - pg_last_xact_replay_timestamp() AS time_lag; RESULT: "2015-06-19 00:40:48.83701+00";"00:00:01.078616" Thank you, Paula P
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
