Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42258=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1WLyFh-0000QO-DV
 for pgsql-admin@arkaria.postgresql.org; Fri, 07 Mar 2014 17:08:05 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M42258=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1WLyFg-0005L7-T3
 for pgsql-admin@arkaria.postgresql.org; Fri, 07 Mar 2014 17:08:04 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <gsievers19@comcast.net>) id 1WLyFf-0005J4-Js
 for pgsql-admin@postgresql.org; Fri, 07 Mar 2014 17:08:03 +0000
Received: from qmta11.westchester.pa.mail.comcast.net
 ([2001:558:fe14:44:76:96:59:211])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <gsievers19@comcast.net>) id 1WLyFb-0005JJ-SJ
 for pgsql-admin@postgresql.org; Fri, 07 Mar 2014 17:08:02 +0000
Received: from omta09.westchester.pa.mail.comcast.net ([76.96.62.20])
 by QMTA11.westchester.pa.mail.comcast.net with comcast
 id ac9C1n0020SCNGk5Bh7ypj; Fri, 07 Mar 2014 17:07:58 +0000
Received: from jerry.enova.com ([38.98.177.132])
 by omta09.westchester.pa.mail.comcast.net with comcast
 id ah7n1n00l2rmZlA3Vh7po6; Fri, 07 Mar 2014 17:07:56 +0000
Received: by jerry.enova.com (Postfix, from userid 1001)
 id 5F6C37401EC; Fri,  7 Mar 2014 11:07:47 -0600 (CST)
From: Jerry Sievers <gsievers19@comcast.net>
To: pgorg_aav <kahitarich-postgresorg@yahoo.com>
Cc: "pgsql-admin\@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: streaming replication sent location not advancing - feature
 request?
References: <1394153429.37920.YahooMailNeo@web120301.mail.ne1.yahoo.com>
Date: Fri, 07 Mar 2014 11:07:47 -0600
In-Reply-To: <1394153429.37920.YahooMailNeo@web120301.mail.ne1.yahoo.com>
 (pgorg aav's message of "Thu, 6 Mar 2014 16:50:29 -0800 (PST)")
Message-ID: <86wqg6os2k.fsf@jerry.enova.com>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.4 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net;
 s=q20121106; t=1394212078;
 bh=3+qXude7tINHGVT3u2HFRG1J7IVmk5Yz5A9OeRJdEec=;
 h=Received:Received:Received:From:To:Subject:Date:Message-ID:
 MIME-Version:Content-Type;
 b=Ju+oB1Xa7rY9rQIrBJFLYrctGQ51gOWZJMhNZ6TjuoX4f9gfntFTeQ3Ke13JEe9Y3
 gIe36A8Y1SuIEjObeTHp4dN21B5LquDAh/xURDyac3iWrw3FYjLhl0SS6WvvP75bJV
 YDy3MW1x8rsSkWCDci0r4oEHqtLd04yb/0GBTciEIRY5pUpFH87vy1C4m8vCrCbaIR
 wFFgXWOCOQqCJsNarNJ1+Eq5FnIU0JpAxJXxQS6n8BA+DJjm24p13Ow24ytycNvZih
 z6oo7JkOEjeM8ap0kOmmIpyKSMRiipc0iKHAVFQLWoQNu5po4DoddOfUvGJywU0mVI
 2xdaBXfDnJVJg==
X-Pg-Spam-Score: 1.1 (+)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin