Skip site navigation (1) Skip section navigation (2)

Re: Interpreting pg_stat_replication values

From: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
To: Alexander Fortin <alexander(dot)fortin(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Interpreting pg_stat_replication values
Date: 2012-01-20 08:13:05
Message-ID: CAL_0b1uSSYvgpdeA26FiDfyXWaoBhXDU49gAzus70dWdxPiktA@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Thu, Jan 19, 2012 at 7:04 PM, Alexander Fortin
<alexander(dot)fortin(at)gmail(dot)com> wrote:
> thank you very much for your suggestion. In the meanwhile we went for a
> check on pg_stat_replication, but we'll add one as you suggest soon on the
> replicas.

You are welcome.

> By the way, maybe you know where I could find documentation about possible
> values from column "state" on view pg_stat_replication? I can see
> "streaming" when everything is ok, and once I could get just a "catchup"
> while a replica was synching.

Here it is

http://doxygen.postgresql.org/walsender__private_8h.html#a177d2f2a29adbee44a22f1e14f78d061

>
>
> --
> Alexander Fortin
> http://about.me/alexanderfortin/



-- 
Sergey Konoplev

Blog: http://gray-hemp.blogspot.com
LinkedIn: http://ru.linkedin.com/in/grayhemp
JID/GTalk: gray(dot)ru(at)gmail(dot)com Skype: gray-hemp

In response to

pgsql-admin by date

Next:From: paddy carrollDate: 2012-01-20 13:08:16
Subject: persistent locks
Previous:From: LALIT KUMARDate: 2012-01-20 07:10:41
Subject: Unable to Connect to server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group