Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XGqHy-0007ll-JG for pgsql-admin@arkaria.postgresql.org; Mon, 11 Aug 2014 14:09:31 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XGqHy-0003ru-32 for pgsql-admin@arkaria.postgresql.org; Mon, 11 Aug 2014 14:09:30 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XGqHw-0003ro-UH for pgsql-admin@postgresql.org; Mon, 11 Aug 2014 14:09:29 +0000 Received: from nm7-vm2.bullet.mail.ir2.yahoo.com ([212.82.96.127]) by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XGqHp-0003an-NZ for pgsql-admin@postgresql.org; Mon, 11 Aug 2014 14:09:27 +0000 Received: from [212.82.98.57] by nm7.bullet.mail.ir2.yahoo.com with NNFMP; 11 Aug 2014 14:09:19 -0000 Received: from [212.82.98.109] by tm10.bullet.mail.ir2.yahoo.com with NNFMP; 11 Aug 2014 14:09:19 -0000 Received: from [127.0.0.1] by omp1046.mail.ir2.yahoo.com with NNFMP; 11 Aug 2014 14:09:19 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 62203.15937.bm@omp1046.mail.ir2.yahoo.com Received: (qmail 19534 invoked by uid 60001); 11 Aug 2014 14:09:19 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.uk; s=s1024; t=1407766159; bh=SYZBAPOp8UAcyV2tDoGCxIhH3RTPRUbhE1aVmkzq4Vc=; h=References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=MEiDwfzpnH8oPu12xBBBb+Hes+niN82woX4m0GzFj5JX9pP4bBj1/mcnceVuDAb35nDnCN7KRZDeXNtwr5IBShXBbTALlevVJ4yY4LyK0fbfrlhCwXeIv3707QgrpuPMGHm8QlhCXNKiPMJeZsG8QAuYykMXWyp7vlz40QmBBII= X-YMail-OSG: nO.N5U4VM1n6H79qoxapLR5iclQ0yxXkErMeQfW40RKhWuu Ni_7nS3ooVfEO.FnekxQKw5QEbQ4WvbkqcWPqf8oOaI7ibEXXqKYL222WDLE dG1EGnsQaY6a3ay_ZOG2Dmg5SlJNaLspB5D0ln42UBRCojM_PCPF_i45.nsr yHPdTRqTf8FTNMGIXNCP5GPUg7vR3qClbFn3jULKQJdUjR9ahXR.qJkEVoUs F13f4wSWk11JDnPorG.OAQgx2t2N4wdULMlfERGoJ.T05k0d42u2eZz1v2QS BeT3_DGUoyzIJJ4v4lDBH2xdF7TwFgXokrlDeylCeFUh23rVQf3VoTVaBg6i QDywxewl3gq3Wzs.54UYvh.j6Xpm0JYptSaHdwcQT_uWNot6z5LRA0lJ7Rc4 VxU_Qsd9k5EZTY0m5BQm9EqFKIH258e8u6Z0sGOV6r9Fgh6ZlkcGx1JrMHZl 8HAiweeO7aCAdxR_RMJMtzsf4OdO6VnEAvHaBysAHt_HLPcJ_5e0VX8vAUuN PQFsGR_o8I6eZ6UO6HO2j7XRkcLbkcmFhFrZkGqqdOm.IRT447Jjsmu8Gw3. awflKeMpo419oiZMITP883MSDmh5XPhC5XSIksyi8UDzHePMmyLUaYwrlKw- - Received: from [194.168.202.210] by web133204.mail.ir2.yahoo.com via HTTP; Mon, 11 Aug 2014 15:09:18 BST X-Rocket-MIMEInfo: 002.001, d2lraS5wb3N0Z3Jlc3FsLm9yZyBpcyB1c3VhbGx5IGEgZ29vZCBwbGFjZSB0byBzdGFydDoKCgpodHRwczovL3dpa2kucG9zdGdyZXNxbC5vcmcvd2lraS9TdHJlYW1pbmdfUmVwbGljYXRpb24KCgoKPl9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fCj4gRnJvbTogQ3JhaWcgSmFtZXMgPGNqYW1lc0BlbW9sZWN1bGVzLmNvbT4KPlRvOiAicGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmciIDxwZ3NxbC1hZG1pbkBwb3N0Z3Jlc3FsLm9yZz4gCj5TZW50OiBNb25kYXksIDExIEF1Z3VzdCAyMDE0LCAxNDoBMAEBAQE- X-Mailer: YahooMailWebService/0.8.198.689 References: Message-ID: <1407766158.11993.YahooMailNeo@web133204.mail.ir2.yahoo.com> Date: Mon, 11 Aug 2014 15:09:18 +0100 From: Glyn Astill Reply-To: Glyn Astill Subject: Re: Replication: Latest, greatest resources? To: Craig James , "pgsql-admin@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="856002529-982945094-1407766158=:11993" 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 --856002529-982945094-1407766158=:11993 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable wiki.postgresql.org is usually a good place to start:=0A=0A=0Ahttps://wiki.= postgresql.org/wiki/Streaming_Replication=0A=0A=0A=0A>_____________________= ___________=0A> From: Craig James =0A>To: "pgsql-adm= in@postgresql.org" =0A>Sent: Monday, 11 August= 2014, 14:51=0A>Subject: [ADMIN] Replication: Latest, greatest resources?= =0A> =0A>=0A>=0A>Googling for "postgres replication" and similar terms brin= gs up too much, rather than too little, information. It's hard to know if I= 've found the most recent best-practices, tutorials, scripts, etc. The PG d= ocumentation for 9.3 and 9.4 is quite good but seems low-level. Some top hi= ts that Google returns are obviously outdated.=0A>=0A>=0A>I'd like to set u= p streaming replication between two 9.3 servers on Ubuntu. Can someone poin= t me to the most current tutorial or script to get started?=0A>=0A>=0A>Than= ks!=0A>Craig=0A>=0A>=0A>=0A>=0A> --856002529-982945094-1407766158=:11993 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
wiki.postgresql.org is usuall= y a good place to start:

https://wiki.postgresql.org/wiki/Str= eaming_Replication

From:= Craig James <cjames@emolecules.com>
To:= "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Sent: Monday, 11 August 2014, 14:51
Subject: [ADMIN] Replication: Latest, greatest resour= ces?

Googling for "postgres re= plication" and similar terms brings up too much, rather than too little, in= formation. It's hard to know if I've found the most recent best-practices, = tutorials, scripts, etc. The PG documentation for 9.3 and 9.4 is quite good= but seems low-level. Some top hits that Google returns are obviously outda= ted.
=0A
I'd like to set up streaming replication between two 9.3 = servers on Ubuntu. Can someone point me to the most current tutorial or scr= ipt to get started?

Thanks!
Craig
=0A

=0A


--856002529-982945094-1407766158=:11993--