From: Vibhor Kumar <vibhor.aim@gmail.com>
To: jweatherman91@alumni.wfu.edu
Cc: pgsql-admin@postgresql.org
Subject: Re: Hot-standby/Reporting database.
Date: Wed, 23 Mar 2011 16:28:20 +0530
Message-ID: <40A0B8B3-3449-4F37-A930-6F131AAA5CA9@gmail.com> (raw)
In-Reply-To: <1300483544.6860.48.camel@darkflame.weatherman.net>
References: <0515F2BB-0522-449C-848B-4E750F4D91BB@pandora.com>
<AANLkTimA6_Ai_pd2fmg5OHQYhiG8-4WAKXpBeA_3Muvv@mail.gmail.com>
<A71C2574-38E9-4EC4-A118-20E11546B7C8@pandora.com>
<1300483544.6860.48.camel@darkflame.weatherman.net>
On Mar 19, 2011, at 2:55 AM, John P Weatherman wrote:
> 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.
>
Yes. On Hotstandby you cannot create Tables.
> Has anyone run into this already and have an idea for a work around?
Looking your requirement, I would recommend to use Slony Replication, which replicate data from mater to slave and also, gives ability to create temporary table, without allowing user to tamper/modify the data of Replicated Tables of (Master).
Thanks & Regards,
Vibhor Kumar
vibhor.aim@gmail.com
Blog:http://vibhork.blogspot.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: vibhor.aim@gmail.com, jweatherman91@alumni.wfu.edu
Subject: Re: Hot-standby/Reporting database.
In-Reply-To: <40A0B8B3-3449-4F37-A930-6F131AAA5CA9@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox