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

From: Edson Carlos Ericksson Richter <edsonrichter(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Replication: How to query current segments allocation relative to "Wal keep segments"?
Date: 2015-01-05 09:51:42
Message-ID: BLU436-SMTP166099D4BDAD8C0C36CBECDCF580@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 05-01-2015 02:08, Michael Paquier wrote:
> 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

In production servers, 9.3.5.
In development servers, 9.4.0.

I had a quick look at this view before:

Example (on 9.3.5):
postgres=# select * from pg_stat_replication;
pid | usesysid | usename | application_name | client_addr |
client_hostname | client_port | backend_start | state |
sent_location | write_location
| flush_location | replay_location | sync_priority | sync_state
------+----------+----------+------------------+-------------+-----------------+-------------+------------------------------+-----------+---------------+---------------
-+----------------+-----------------+---------------+------------
2808 | 10 | postgres | walreceiver | 10.68.73.1
| | 36075 | 2015-01-03 20:17:48.53706-02 |
streaming | 22/F94D1A90 | 22/F94D1A90
| 22/F94D1A90 | 22/F94D1A90 | 0 | async
(1 registro)

but in either case (9.3.5, 9.4.0), I get lots of info, but not the count
of wal_segments consumed.
Would this kind of count being recorded somewhere else?
How does the server knows that the wal_segments have been exhausted?

Thanks,

Edson

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2015-01-05 12:02:25 Re: Replication: How to query current segments allocation relative to "Wal keep segments"?
Previous Message Michael Paquier 2015-01-05 04:08:17 Re: Replication: How to query current segments allocation relative to "Wal keep segments"?