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: (view raw, whole thread or download thread mbox)
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

> --
> Alexander Fortin

Sergey Konoplev

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-2017 The PostgreSQL Global Development Group