replication behind high lag

From: AI Rumman <rummandba(at)gmail(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: replication behind high lag
Date: 2013-03-25 19:37:59
Message-ID: CAGoODpd_OA3C1syfdU+gT8pnaXpat024QfGuNqfhF4t5kW+cyQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have two 9.2 databases running with hot_standby replication. Today when I
was checking, I found that replication has not been working since Mar 1st.
There was a large database restored in master on that day and I believe
after that the lag went higher.

SELECT pg_xlog_location_diff(pg_current_xlog_location(), '0/0') AS offset

431326108320

SELECT pg_xlog_location_diff(pg_last_xlog_receive_location(), '0/0') AS
receive, pg_xlog_location_diff(pg_last_xlog_replay_location(), '0/0')
AS replay

receive | replay
--------------+--------------
245987541312 | 245987534032
(1 row)

I checked the pg_xlog in both the server. In Slave the last xlog file
-rw------- 1 postgres postgres 16777216 Mar 1 06:02
00000001000000390000007F

In Master, the first xlog file is
-rw------- 1 postgres postgres 16777216 Mar 1 04:45
00000001000000390000005E

Is there any way I could sync the slave in quick process?

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lonni J Friedman 2013-03-25 19:40:11 Re: replication behind high lag
Previous Message Emanuel Araújo 2013-03-25 16:57:48 Acess Oracle with dbi-link (PostgreSQL) Error Compile