Postgres Pro
Downloads
Home   >   mailing lists

Re: Correct query to check streaming replication lag - Mailing list pgsql-general

From Sameer Kumar
Subject Re: Correct query to check streaming replication lag
Date
Msg-id CADp-Sm7KbvuOcyGBSDvGw+3DcmtAXpBBk4kpHVVYXn3DJfKP2w@mail.gmail.com
Whole thread Raw
In response to Re: Correct query to check streaming replication lag  (Granthana Biswas <granthana@zedo.com>)
Responses Re: Correct query to check streaming replication lag  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
Tree view

On Mon, Jan 20, 2014 at 1:53 PM, Granthana Biswas <granthana@zedo.com> wrote:
Yes we already do that. Count the number of ready wal files.

I guess a better place to check would be pg_stat_replication


Check this discussion:
http://www.postgresql.org/message-id/4F13ED11.6080001@gmail.com


Another way is explained in wiki:
http://wiki.postgresql.org/wiki/Streaming_Replication
$ psql -c "SELECT pg_current_xlog_location()" -h192.168.0.10 (primary host) pg_current_xlog_location 
-------------------------- 0/2000000
(1 row)

$ psql -c "select pg_last_xlog_receive_location()" -h192.168.0.20 (standby host) pg_last_xlog_receive_location 
------------------------------- 0/2000000
(1 row)

$ psql -c "select pg_last_xlog_replay_location()" -h192.168.0.20 (standby host) pg_last_xlog_replay_location 
------------------------------ 0/2000000
(1 row)

Best Regards,
Sameer Kumar | Database Consultant
ASHNIK PTE. LTD.
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
M : +65 8110 0350 T: +65 6438 3504 | www.ashnik.com
www.facebook.com/ashnikbiz | www.twitter.com/ashnikbiz

email patch

This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s).

Attachment

pgsql-general by date:

Previous
From: bricklen
Date:
Subject: Re: Filtering queries by IP
Next
From: Michael Paquier
Date:
Subject: Re: Correct query to check streaming replication lag