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: | Raw Message | Whole Thread | 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 |