Search Postgresql Archives

Postgresql 9.2 has standby server lost data?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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"


Thank you,
Paula P

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux