Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 6995463266C for ; Wed, 9 Jun 2010 12:46:36 -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 24709-08 for ; Wed, 9 Jun 2010 15:46:29 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from bay0-omc1-s15.bay0.hotmail.com (bay0-omc1-s15.bay0.hotmail.com [65.54.190.26]) by mail.postgresql.org (Postfix) with ESMTP id E25406321AC for ; Wed, 9 Jun 2010 12:46:28 -0300 (ADT) Received: from BAY149-W30 ([65.54.190.61]) by bay0-omc1-s15.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Wed, 9 Jun 2010 08:46:25 -0700 Message-ID: Content-Type: multipart/alternative; boundary="_9b82741e-9957-42f1-8fa5-ba85d3e2bab0_" X-Originating-IP: [129.44.63.215] From: Balkrishna Sharma To: Subject: Only standby Server in Cloud(Amazon), not the primary Date: Wed, 9 Jun 2010 11:46:25 -0400 Importance: Normal MIME-Version: 1.0 X-OriginalArrivalTime: 09 Jun 2010 15:46:25.0709 (UTC) FILETIME=[EB07CDD0:01CB07EA] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.909 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201006/84 X-Sequence-Number: 34862 --_9b82741e-9957-42f1-8fa5-ba85d3e2bab0_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello=2C In PostgreSQL 9.x=2C using Streaming replication (hot standby with PITR)=2C= is it possible to have just the standby server in Cloud(Amazon) and the pr= imary database local ?What I am trying to achieve is get the backups guaran= teed in cloud=2C if I just have my standby server there ? Is it technically possible ? What are the risks and performance issues ? Thanks=2C-Bala =20 _________________________________________________________________ The New Busy is not the too busy. Combine all your e-mail accounts with Hot= mail. http://www.windowslive.com/campaign/thenewbusy?tile=3Dmultiaccount&ocid=3DP= ID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_4= --_9b82741e-9957-42f1-8fa5-ba85d3e2bab0_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello=2C

In PostgreSQL 9.x=2C using Streaming replicatio= n (hot standby with PITR)=2C is it possible to have just the standby server= in Cloud(Amazon) and the primary database local ?
What I am tryi= ng to achieve is get the backups guaranteed in cloud=2C if I just have my s= tandby server there ?

Is it technically possible ?= What are the risks and performance issues ?

Thank= s=2C
-Bala


The New Busy is not the t= oo busy. Combine all your e-mail accounts with Hotmail. Get busy. = --_9b82741e-9957-42f1-8fa5-ba85d3e2bab0_--