Re: Hot-standby/Reporting database.

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(dot)aim(at)gmail(dot)com
Blog:http://vibhork.blogspot.com