Re: Replication: How to query current segments allocation relative to "Wal keep segments"?

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Edson Carlos Ericksson Richter <edsonrichter(at)hotmail(dot)com>
Cc: PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: Replication: How to query current segments allocation relative to "Wal keep segments"?
Date: 2015-01-05 04:08:17
Message-ID: CAB7nPqT=JxN+DLXfEc+q95Kanb2L3=uN=LYS-tQVEf2pFMA0Qw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, Jan 4, 2015 at 1:48 AM, Edson Carlos Ericksson Richter
<edsonrichter(at)hotmail(dot)com> wrote:
> How to query current segments allocation relative to "Wal keep segments" in
> each master server?
What is your server version? You can have a look at
pg_stat_replication on the master which contains information about the
WAL segments written, flushed and replayed on each slave:
http://www.postgresql.org/docs/devel/static/monitoring-stats.html#PG-STAT-REPLICATION-VIEW
--
Michael

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edson Carlos Ericksson Richter 2015-01-05 09:51:42 Re: Replication: How to query current segments allocation relative to "Wal keep segments"?
Previous Message Adrian Klaver 2015-01-05 03:20:48 Re: Streaming replication - slave not getting promoted