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....@gmail.com Blog:http://vibhork.blogspot.com -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
