|
Home > Archive > Slony1 PostgreSQL Replication > July 2005 > Whether we can make database operations on Slave
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Whether we can make database operations on Slave
|
|
| Ajay Dalvi 2005-07-07, 3:30 am |
|
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?
-Ajay
| |
| Jan Wieck 2005-07-07, 7:24 am |
| 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('_clu
stername', '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- bwPqjjyvM7QAvxtiuMwx
3w@public.gmane.org #
|
|
|
|
|