On 7/7/2005 1:48 AM, Ajay Dalvi wrote:

> Hello All,
> 
> Is there any way so that we can make database operations on slave nodes
> when they are subscribed to a set for replication.
> 
> I am having this need because, when we start slon process, replication
> goes on , on continuous basis. And when we subscribe a partcular slave
> node for replication, we can not able to make database operations on
> slave nodes except retriving data( i.e. select queries).
> 
> So is there any way so that we can make database operations( like
> insert,delete update operations) while slave node is subscribe for
> replication?

It is your database and your data, so if you feel the urgent need to 
_shoot yourself into the foot_ you can call the special function slon 
uses itself to set the session role and allow it to make updates.

     select _clustername.setSessionRole('_clustername', 'slon');

will cause the denyaccess trigger to let the changes through. This can 
only be performed by a database superuser.

Please note that the above is _NOT RECOMMENDED_ and _NOT SUPPORTED_ in 
any way.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #