Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WLizk-0006vn-A6 for pgsql-admin@arkaria.postgresql.org; Fri, 07 Mar 2014 00:50:36 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WLizj-0003w7-PN for pgsql-admin@arkaria.postgresql.org; Fri, 07 Mar 2014 00:50:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WLizi-0003w0-Am for pgsql-admin@postgresql.org; Fri, 07 Mar 2014 00:50:34 +0000 Received: from nm14.bullet.mail.ne1.yahoo.com ([98.138.90.77]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WLizf-0005bG-9n for pgsql-admin@postgresql.org; Fri, 07 Mar 2014 00:50:33 +0000 Received: from [98.138.100.113] by nm14.bullet.mail.ne1.yahoo.com with NNFMP; 07 Mar 2014 00:50:29 -0000 Received: from [98.138.89.166] by tm104.bullet.mail.ne1.yahoo.com with NNFMP; 07 Mar 2014 00:50:29 -0000 Received: from [127.0.0.1] by omp1022.mail.ne1.yahoo.com with NNFMP; 07 Mar 2014 00:50:29 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 510913.32778.bm@omp1022.mail.ne1.yahoo.com Received: (qmail 84012 invoked by uid 60001); 7 Mar 2014 00:50:29 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1394153429; bh=kciACTI8wl7rwgCYL6TqYhX88wbw5M9jQPSCQILzXlw=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=k0zYZkFYoZvP/u/TYcYZJmBP3byMUrwqNqTHepTa4bKvtUWwV+/OtV4NqSJhvgZteTJT1R6J70GcUBo877/FhrlsadrSS14dkimejAwrDgLMj6pPh5lKxP7Dtt2EZnyW5ebsvtOw5gGQUb5A5q/4+8vtZ28ntyzCs3kTy2e3yoA= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type; b=GRg/YQrzZIiOVAShUEmbJC1/kBMmTG2VhdUwi8vKebRqnbKWSdfJAja3tU1JM2zAZJjcEFe3q17g0ZXsb60JmhZuko1WZYc5iw+B1Gz4NXPTIzl4UlP/RYBC/0oYlxMQ99CJGW1AmjTI1L4UmCEj6WitNu+yBlBhjo0b1p1VKlI=; X-YMail-OSG: deLsjAgVM1lwUaNvdKKOrDa2mtRZAPhNRol2Cqa_GqIYERM dziZsuDVEwB3IXnz1qnLYQwfLjjUbMLWCeMg3t60WVShqY1Ux2IPTvvyillj ko4qX1EIS_sQ32xi0bjr2kpMwViT4vMY5ua4qfckKVwslfimoinQGjvtfv6B Wn9FIVs69._ITC5yIq1e35n2bLqNXgQtYl9NSq9DX87F4DitGXMKX.dX2BHW q6hxsnF2ilKd9xWk4rAn703JzUZTdbwd0j5lw4CDL4awIUKijxSSLnOw6o7K GC9pQPc.DnGSLvL81rJ_eW0IUcaKsFUyGTwtsQr7mcWkqXLzdeh4SHFAX27T 8C6rFKf7Hl.jNtUzKVx.l0B_fr.hcf9NM3KcFZfJGKBQTY9WixCaIpdG3WR7 .J4J7NdzaoFNty_VVinlP1sGiV1pyVQd6WldJhJHzNnc7xDnt1Df75DhyKME b0YNeXoiLpPZJ_DErIfTNE5A.P8ffjB4R4b9EMhPbI9llnKlEHMmKf_pd1Fd zOAUm6aw0jVoqpqvs9Kdzli9NfQkQuon5X7fyMeHgWOZ9F0gSuliNEPDWk2J U_yWkr9.bCP9rG3dCG6dKFQie Received: from [64.236.128.62] by web120301.mail.ne1.yahoo.com via HTTP; Thu, 06 Mar 2014 16:50:29 PST X-Rocket-MIMEInfo: 002.001, SGksCgpXaXRoIHdhbCBzaGlwcGluZyBpdCBpcyBwb3NzaWJsZSB0byBwdWxsIHRoZSBXQUwgZmlsZXMgaW4gYWR2YW5jZSBmcm9tIHRoZSBtYXN0ZXIuCklzIGl0IHBvc3NpYmxlIHRvIGRvIHNvbWV0aGluZyBzaW1pbGFyIGZvciBzdHJlYW1pbmcgcmVwbGljYXRpb24_CgpUaGlzIG1vcm5pbmcgZHVlIHRvIFZNIGhhcmR3YXJlIGlzc3VlcywgYSBjb3VwbGUgb2Ygc3RhbmRieXMgbGFnZ2VkIChBIExPVCkgYmVoaW5kIG1hc3RlcgoKIyBzZWxlY3QgKiBmcm9tIHBnX3N0YXRfcmVwbGljYXRpb24gOwrCoCBwaWQBMAEBAQE- X-Mailer: YahooMailWebService/0.8.177.636 References: Message-ID: <1394153429.37920.YahooMailNeo@web120301.mail.ne1.yahoo.com> Date: Thu, 6 Mar 2014 16:50:29 -0800 (PST) From: pgorg_aav Reply-To: pgorg_aav Subject: streaming replication sent location not advancing - feature request? To: "pgsql-admin@postgresql.org" MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-1415095519-1513369824-1394153429=:37920" X-Pg-Spam-Score: -0.1 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ---1415095519-1513369824-1394153429=:37920 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi,=0A=0AWith wal shipping it is possible to pull the WAL files in advance = from the master.=0AIs it possible to do something similar for streaming rep= lication?=0A=0AThis morning due to VM hardware issues, a couple of standbys= lagged (A LOT) behind master=0A=0A# select * from pg_stat_replication ;=0A= =A0 pid =A0| usesysid | usename =A0| application_name | =A0client_addr =A0|= client_hostname | client_port | =A0 =A0 =A0 =A0 backend_start =A0 =A0 =A0 = =A0 | =A0 state =A0 | sent_location | write_location | flush_location | rep= lay_location | sync_priority | sync_state=0A-------+----------+----------+-= -----------------+---------------+-----------------+-------------+---------= ----------------------+-----------+---------------+----------------+-------= ---------+-----------------+---------------+------------=0A...=3Dx8=A0snipp= ed=A0=0A=A0=A01758 | =A0 =A0 =A0 10 | postgres | walreceiver =A0 =A0 =A0| 1= 72.26.149.47 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 | =A0 =A0 =A0 34798 | 2014-0= 2-04 14:48:51.318344-05 | streaming | 1D0/C49A9BE0 =A0| 1D0/C49A9BE0 =A0 | = 1D0/C49A9BE0 =A0 | 1D0/C49A9B38 =A0 =A0| =A0 =A0 =A0 =A0 =A0 =A0 0 | async= =0A=0A=A016072 | =A0 =A0 =A0 10 | postgres | walreceiver =A0 =A0 =A0| 172.2= 6.115.48 | =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 | =A0 =A0 =A0 57152 | 2013-12-07= 09:25:21.713723-05 | streaming | 1C8/11B40000 =A0| 1C8/119A0000 =A0 | 1C8/= 11900000 =A0 | 1C8/117EDAB8 =A0 =A0| =A0 =A0 =A0 =A0 =A0 =A0 0 | async=0A(9= rows)=0A=0AThanks much in advance,=0AAmit=0A ---1415095519-1513369824-1394153429=:37920 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hi,

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

This morning due to VM hardware is= sues, a couple of standbys lagged (A LOT) behind master
# select * from pg_stat_replication ;
  pid  | usesysid |= usename  | application_name |  client_addr  | client_hostna= me | client_port |         backend_start     =     |   state   | sent_location | write_location | flus= h_location | replay_location | sync_priority | sync_state
-------+----------+-= ---------+------------------+---------------+-----------------+------------= -+-------------------------------+-----------+---------------+-------------= ---+----------------+-----------------+---------------+------------
...=3Dx8 snipped 
=   1758 |       10 | postgres | walreceiver   =    | 172.26.149.47 |                 | =       34798 | 2014-02-04 14:48:51.318344-05 | streaming | 1D= 0/C49A9BE0=0A  | 1D0/C49A9BE0   | 1D0/C49A9BE0   | 1D0/C49A9= B38    |             0 | async
&nbs= p;16072 |       10 | postgres | walreceiver     &n= bsp;| 172.26.115.48 |               &nbs= p; |       57152 | 2013-12-07 09:25:21.713723-05 | streaming= | 1C8/11B40000  | 1C8/119A0000   | 1C8/11900000   | 1C8/117= EDAB8    |             0 | async
(9 rows)

Thanks much in advance,
Amit
=
---1415095519-1513369824-1394153429=:37920--