Re: streaming replication sent location not advancing - feature request?

pgorg_aav <kahitarich-postgresorg@yahoo.com> writes:

> 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?

wal_keep_segments  <something higher>

Otherwise just use the already supported hybrid of WAL archiving and
streaming.

> 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
>

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800