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. 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"
