Postgres Pro
Downloads
Home   >   mailing lists

streaming replication sent location not advancing - feature request? - Mailing list pgsql-admin

From pgorg_aav
Subject streaming replication sent location not advancing - feature request?
Date
Msg-id 1394153429.37920.YahooMailNeo@web120301.mail.ne1.yahoo.com
Whole thread Raw
Responses Re: streaming replication sent location not advancing - feature request?  (Jerry Sievers <gsievers19@comcast.net>)
List pgsql-admin
Tree view
Hi,

With wal shipping it is possible to pull the WAL files in advance from the master.
Is it possible to do something similar for streaming replication?

This morning due to VM hardware issues, a couple of standbys lagged (A LOT) behind master

# 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
-------+----------+----------+------------------+---------------+-----------------+-------------+-------------------------------+-----------+---------------+----------------+----------------+-----------------+---------------+------------
...=x8 snipped 
  1758 |       10 | postgres | walreceiver      | 172.26.149.47 |                 |       34798 | 2014-02-04 14:48:51.318344-05 | streaming | 1D0/C49A9BE0  | 1D0/C49A9BE0   | 1D0/C49A9BE0   | 1D0/C49A9B38    |             0 | async
 16072 |       10 | postgres | walreceiver      | 172.26.115.48 |                 |       57152 | 2013-12-07 09:25:21.713723-05 | streaming | 1C8/11B40000  | 1C8/119A0000   | 1C8/11900000   | 1C8/117EDAB8    |             0 | async
(9 rows)

Thanks much in advance,
Amit

pgsql-admin by date:

Previous
From: David Johnston
Date:
Subject: Re: Enhancement Request
Next
From: Jerry Sievers
Date:
Subject: Re: streaming replication sent location not advancing - feature request?