Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YRpzw-0001QX-Sb for pgsql-hackers@arkaria.postgresql.org; Sat, 28 Feb 2015 22:36:37 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YRpzw-0007Gs-89 for pgsql-hackers@arkaria.postgresql.org; Sat, 28 Feb 2015 22:36:36 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YRpzu-0007Gl-Hv for pgsql-hackers@postgresql.org; Sat, 28 Feb 2015 22:36:34 +0000 Received: from mail-yh0-x235.google.com ([2607:f8b0:4002:c01::235]) by magus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YRpzm-0006yH-8K for pgsql-hackers@postgresql.org; Sat, 28 Feb 2015 22:36:33 +0000 Received: by yhab6 with SMTP id b6so11302409yha.6 for ; Sat, 28 Feb 2015 14:36:24 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=FIGb+M74OeF47a6MF8Ff7eESOcq9XN+fAZW7+P/Vw0A=; b=LgN7bn5zUflpr8oyM5FoVyKJ7zj9ih/U4LR4d0/5cslD2LsqMW5m6lXRd1QMKxpu8b MqP6EYcam9I3ES0DFlQ0RcuLr0yQIVsfpqBqTkayeEMDzdTNIHuF5NLrXYikZ1k4D4ra gqxrqe0FKBRzAlJEiz/jgzpUBtOK9My0I1ozh2B6YjXpCOSEI7G3gNC7YE4RfELgjSLA 8fd8YRPXBp5p1GDyyrcQkRX6oh+S/7vTSF1kXK2crVrC58/KEQ073UaakCc0DdPldKMG bPMaR1gNu2en9kBBcrB6HgrQyyIcBptZ7/fTPAbG4KRqnq0RoJagVH8BJEAfSedhph59 wnoA== MIME-Version: 1.0 X-Received: by 10.170.37.86 with SMTP id 83mr20531933ykf.39.1425162983997; Sat, 28 Feb 2015 14:36:23 -0800 (PST) Received: by 10.170.199.11 with HTTP; Sat, 28 Feb 2015 14:36:23 -0800 (PST) In-Reply-To: <54949108.3030109@vmware.com> References: <548AF1CB.80702@vmware.com> <689EB259-44C2-4820-B901-4F6B1C55A1E4@simply.name> <549083D6.1000301@vmware.com> <54949108.3030109@vmware.com> Date: Sun, 1 Mar 2015 09:36:23 +1100 Message-ID: Subject: Re: Streaming replication and WAL archive interactions From: Venkata Balaji N To: Heikki Linnakangas Cc: Fujii Masao , Borodin Vladimir , PostgreSQL-development Content-Type: multipart/alternative; boundary=001a1137adcc68850905102d9d08 X-Pg-Spam-Score: -2.4 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org --001a1137adcc68850905102d9d08 Content-Type: text/plain; charset=UTF-8 > > > Here's a first cut at this. It includes the changes from your > standby_wal_archiving_v1.patch, so you get that behaviour if you set > archive_mode='always', and the new behaviour I wanted with > archive_mode='shared'. I wrote it on top of the other patch I posted > recently to not archive bogus recycled WAL segments after promotion ( > http://www.postgresql.org/message-id/549489FA.4010304@vmware.com), but it > seems to apply without it too. > > I suggest reading the documentation changes first, it hopefully explains > pretty well how to use this. The code should work too, and comments on that > are welcome too, but I haven't tested it much. I'll do more testing next > week. Patch did get applied successfully to the latest master. Can you please rebase. Regards, Venkata Balaji N --001a1137adcc68850905102d9d08 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Here's a first cut at this. It includes the changes from your standby_w= al_archiving_v1.patch, so you get that behaviour if you set archive_= mode=3D'always', and the new behaviour I wanted with archive_mode= =3D'shared'. I wrote it on top of the other patch I posted recently= to not archive bogus recycled WAL segments after promotion (http://www.postgresql.org/message-id/549489FA.4010304@v= mware.com), but it seems to apply without it too.

I suggest reading the documentation changes first, it hopefully explains pr= etty well how to use this. The code should work too, and comments on that a= re welcome too, but I haven't tested it much. I'll do more testing = next week.

Patch did get applied successful= ly to the latest master. Can you please rebase.

Re= gards,
Venkata Balaji N


=
--001a1137adcc68850905102d9d08--