| From: | pgorg_aav <kahitarich-postgresorg(at)yahoo(dot)com> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | streaming replication sent location not advancing - feature request? |
| Date: | 2014-03-07 00:50:29 |
| Message-ID: | 1394153429.37920.YahooMailNeo@web120301.mail.ne1.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jerry Sievers | 2014-03-07 17:07:47 | Re: streaming replication sent location not advancing - feature request? |
| Previous Message | David Johnston | 2014-03-04 16:24:15 | Re: Enhancement Request |