Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 45DFE1337999 for ; Sun, 20 Mar 2011 22:04:25 -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 55526-10 for ; Mon, 21 Mar 2011 01:04:18 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f46.google.com (mail-bw0-f46.google.com [209.85.214.46]) by mail.postgresql.org (Postfix) with ESMTP id 2E676133740B for ; Sun, 20 Mar 2011 22:04:16 -0300 (ADT) Received: by bwz15 with SMTP id 15so4686308bwz.19 for ; Sun, 20 Mar 2011 18:04:16 -0700 (PDT) Received: by 10.204.19.83 with SMTP id z19mr3098185bka.191.1300669456292; Sun, 20 Mar 2011 18:04:16 -0700 (PDT) MIME-Version: 1.0 Received: by 10.204.58.208 with HTTP; Sun, 20 Mar 2011 18:04:01 -0700 (PDT) In-Reply-To: <1300483544.6860.48.camel@darkflame.weatherman.net> References: <0515F2BB-0522-449C-848B-4E750F4D91BB@pandora.com> <1300483544.6860.48.camel@darkflame.weatherman.net> From: Jaime Casanova Date: Sun, 20 Mar 2011 20:04:01 -0500 X-Google-Sender-Auth: K52CT-j5uzmC0vGxi_C2nFXHJps Message-ID: Subject: Re: Hot-standby/Reporting database. To: jweatherman91@alumni.wfu.edu Cc: pgsql-admin@postgresql.org Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.6 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_LOW=-0.7 X-Spam-Level: X-Archive-Number: 201103/205 X-Sequence-Number: 37077 On Fri, Mar 18, 2011 at 4:25 PM, John P Weatherman wrote: > > Has anyone run into this already and have an idea for a work around? =C2= =A0I > am primarily an Oracle guy and in that environment I would set up a > second DB with database links to the hot standby, you can use the contrib module dblink for this: http://www.postgresql.org/docs/9.0/static/dblink.html --=20 Jaime Casanova=C2=A0 =C2=A0 =C2=A0 =C2=A0=C2=A0 www.2ndQuadrant.com Professional PostgreSQL: Soporte y capacitaci=C3=B3n de PostgreSQL