Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id A9A981337C00 for ; Fri, 18 Mar 2011 18:34:08 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 53608-04 for ; Fri, 18 Mar 2011 21:33:59 +0000 (UTC) X-Greylist: delayed 00:08:12.727964 by SQLgrey-1.7.6 Received: from elasmtp-spurfowl.atl.sa.earthlink.net (elasmtp-spurfowl.atl.sa.earthlink.net [209.86.89.66]) by mail.postgresql.org (Postfix) with ESMTP id 3A85C1337BFA for ; Fri, 18 Mar 2011 18:33:58 -0300 (ADT) Received: from [66.128.249.37] (helo=[192.168.24.108]) by elasmtp-spurfowl.atl.sa.earthlink.net with esmtpa (Exim 4.67) (envelope-from ) id 1Q0hB2-00045J-Vj for pgsql-admin@postgresql.org; Fri, 18 Mar 2011 17:25:45 -0400 Subject: Hot-standby/Reporting database. From: John P Weatherman Reply-To: jweatherman91@alumni.wfu.edu To: pgsql-admin@postgresql.org In-Reply-To: References: <0515F2BB-0522-449C-848B-4E750F4D91BB@pandora.com> Content-Type: text/plain Date: Fri, 18 Mar 2011 16:25:44 -0500 Message-Id: <1300483544.6860.48.camel@darkflame.weatherman.net> Mime-Version: 1.0 X-Mailer: Evolution 2.12.3 (2.12.3-19.el5) Content-Transfer-Encoding: 7bit X-ELNK-Trace: b4d21b641634dbbe40ea0adc697db4f96818e31467099fba49f3350f7af33f00895d6a93c0fdb760350badd9bab72f9c350badd9bab72f9c350badd9bab72f9c X-Originating-IP: 66.128.249.37 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201103/202 X-Sequence-Number: 37074 All, I have recently upgraded to Postgres9 and am building a hot standby for reporting. Unfortunately, my end users are providing requirements for 1) real time data replication (which the hot standby does) and 2) the ability to create temporary tables as part of their reporting jobs (which is expressly prohibited in a hot standby. Has anyone run into this already and have an idea for a work around? I am primarily an Oracle guy and in that environment I would set up a second DB with database links to the hot standby, then they could connect somewhere they could create tables and use the links to pull the real time data...keeping them away from production with ad hoc code. I'm not sure if there is any way to do that with postgres. Thanks, John John P Weatherman Sr DBA Centerstone