Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 34BD2B5DBD9 for ; Wed, 5 Oct 2011 20:53:56 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 05106-09 for ; Wed, 5 Oct 2011 23:53:49 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from lists.commandprompt.com (host-215.commandprompt.net [207.173.203.215]) by mail.postgresql.org (Postfix) with ESMTP id D71CFB5DBC7 for ; Wed, 5 Oct 2011 20:53:49 -0300 (ADT) Received: from [192.168.1.122] (spinlock.commandprompt.com.commandprompt.com [207.173.203.215]) by lists.commandprompt.com (Postfix) with ESMTPA id 7A38C34C3A0; Wed, 5 Oct 2011 16:53:48 -0700 (PDT) Received: from 71-95-103-234.dhcp.knwc.wa.charter.com ([71.95.103.234] helo=[192.168.1.122]) by assp.commandprompt.com with ESMTP (2.0.1); 5 Oct 2011 16:53:47 -0700 Message-ID: <4E8CEDF7.8040505@commandprompt.com> Date: Wed, 05 Oct 2011 16:53:27 -0700 From: "Joshua D. Drake" Organization: Command Prompt, Inc. User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:6.0.2) Gecko/20110906 Thunderbird/6.0.2 MIME-Version: 1.0 To: Ben Ciceron CC: pgsql-admin@postgresql.org Subject: Re: pg9 replication over WAN ? References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Assp-Version: 2.0.1(3.2.15) on assp.commandprompt.com X-Assp-Client-TLS: yes X-Assp-ID: assp.commandprompt.com m1-58828-09985 X-Assp-Original-Subject: Re: [ADMIN] pg9 replication over WAN ? X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.18 tagged_above=-10 required=5 tests=BAYES_00=-1.9, SARE_SPEC_REPLICA=0.72 X-Spam-Level: X-Archive-Number: 201110/22 X-Sequence-Number: 38474 On 10/05/2011 04:34 PM, Ben Ciceron wrote: > > has anyone a positive experience using pg9.x streaming replication over WAN ? It is no different than the innertubes. Just make sure you have enough bandwidth and the proper ports directed via firewall/vpn. JD > > Cheers, > Ben- > -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services and Development The PostgreSQL Conference - http://www.postgresqlconference.org/ @cmdpromptinc - @postgresconf - 509-416-6579