Postgresql 9.2 has standby server lost data?

From: Paula Price <pj8abug(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgresql 9.2 has standby server lost data?
Date: 2015-06-19 00:45:49
Message-ID: CAL3+i0cfPm1BRYvqv-c5ETWfvoerHLbQm23yxyuAM_+MdhH_-w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sameer Kumar 2015-06-19 01:31:29 Re: pg_xlog on a hot_stanby slave
Previous Message Douglas Stetner 2015-06-19 00:26:32 Re: pg_dump 8.4.9 failing after upgrade to openssl-1.0.1e-30.el6_6.11.x86_64 on redhat linux