DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=subject:mime-version:content-type:from:in-reply-to:date:cc
	:content-transfer-encoding:message-id:references:to:x-mailer;
	b=fY7uojVnUTEf5UAOCztGLdr6dQK6WTRk5Rk3AZRzmfNQlipTdv5pamz8Q0FD5SgU6j
	UVwkj3NwPQv6FT62+gJ+hzPeNx/L197qZzimhuiu9rIb93ZykISAZBMh0DliA/WpO5hr
	yqrkE61XGDG/Rl+eG2vTVfqIJEyPOfdXNu0PI=
Subject: Re: Hot-standby/Reporting database.
Mime-Version: 1.0 (Apple Message framework v1082)
Content-Type: text/plain; charset=us-ascii
From: Vibhor Kumar <vibhor.aim@gmail.com>
In-Reply-To: <1300483544.6860.48.camel@darkflame.weatherman.net>
Date: Wed, 23 Mar 2011 16:28:20 +0530
Cc: pgsql-admin@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <40A0B8B3-3449-4F37-A930-6F131AAA5CA9@gmail.com>
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>
To: jweatherman91@alumni.wfu.edu


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.
>=20
Yes. On Hotstandby you cannot create Tables.


> Has anyone run into this already and have an idea for a work around? =20=


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).=20

Thanks & Regards,
Vibhor Kumar
vibhor.aim@gmail.com
Blog:http://vibhork.blogspot.com