I don't get it. Can you explain a bit more. =


As i have 1 master and 1 slave. Then i run a toggle script that changes my =
slave to master and my master to slave. =


Therefore, My previous slave is a new master. =


Now, I want to toggle again. And it is giving me an error. What is wrong in=
 it ? =


- Owais

-----Original Message-----
From: Melvin Davidson [mailto:melvin6925 at yahoo.com]
Sent: Monday, June 8, 2009 08:08 AM
To: slony1-general at lists.slony.info, 'owais'
Subject: RE: [Slony1-general] How to shut-down slony replication

owais, =


>when I togglefrom slave to master, it gives me error.

>"_OAK_CLUSTER".getMaxXid(); - ERROR: Slony-I: set 1 doesnot originate on l=
ocal node =


The purpose of the switchover is to change the master to the slave and slav=
e to master. But you cannot switch from a slave to a master. There is no po=
int in that.

Melvin Davidson =





--- On Mon, 6/8/09, owais <owais at preceptglobalaccess.com> wrote:

From: owais <owais at preceptglobalaccess.com>
Subject: RE: [Slony1-general] How to shut-down slony replication
To: "'Melvin Davidson'" <melvin6925 at yahoo.com>, slony1-general at lists.slony.=
info
Date: Monday, June 8, 2009, 1:39 AM

Toggling from master to slave is working fine. But when I togglefrom slave =
to master, it gives me error.

<stdin>:19: PGRES_FATAL_ERROR select"_OAK_CLUSTER".lockSet(1); select"_OAK_=
CLUSTER".getMaxXid(); - ERROR: Slony-I: set 1 doesnot originate on local no=
de

Kindly help me

-Owais

From: Melvin Davidson[mailto:melvin6925 at yahoo.com] =

Sent: Tuesday, June 02, 2009 7:18 PM
To: slony1-general at lists.slony.info; owais
Subject: Re: [Slony1-general] How to shut-down slony replication


To temporarily stop replication, I issue pkill slon on the master and all s=
lave. =


 To toggle a master and slave, I use a slonik script like one below:
 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
 slonik <<_EOF_

 #--
 # define the namespace the replication system uses in our example it is
 # slony_example
 #--
 CLUSTER NAME =3D $PTS_META_REP;

 #--
 # admin conninfo's are used by slonik to connect to the nodes one for each
 # node on each side of the cluster, the syntax is that of PQconnectdb in
 # the C-API
 # --
 node 1 admin conninfo=3D'dbname=3D$MASTERDBNAME host=3D$MASTERHOST port=3D=
$PGPORT user=3D$REPLICATIONUSER';
 node 101 admin conninfo=3D'dbname=3D$MASTERDBNAME host=3D$SLAVEHOST1 port=
=3D$JCIPORT user=3D$REPLICATIONUSER';

 # ----
 # Switchover to node 101, make node 1 the slave
 # ----

 lock set (id =3D 1, origin =3D 1);
 wait for event (origin =3D 1, confirmed =3D 101);
 move set (id =3D 1, old origin =3D 1, new origin =3D 101);
 wait for event (origin =3D 1, confirmed =3D 101);

 _EOF_
 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

 Likewise to switch back, I use:

 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
 slonik <<_EOF_

 #--
 # define the namespace the replication system uses in our example it is
 # slony_example
 #--
 CLUSTER NAME =3D $PTS_META_REP;

 #--
 # admin conninfo's are used by slonik to connect to the nodes one for each
 # node on each side of the cluster, the syntax is that of PQconnectdb in
 # the C-API
 # --
 node 1 admin conninfo=3D'dbname=3D$MASTERDBNAME host=3D$MASTERHOST port=3D=
$PGPORT user=3D$REPLICATIONUSER';
 node 101 admin conninfo=3D'dbname=3D$MASTERDBNAME host=3D$SLAVEHOST1 port=
=3D$JCIPORT user=3D$REPLICATIONUSER';

 # ----
 # Switchover to node 1, make node 101 the slave
 # ----

 lock set (id =3D 1, origin =3D 101);
 wait for event (origin =3D 101, confirmed =3D 1);
 move set (id =3D 1, old origin =3D 101, new origin =3D 1);
 wait for event (origin =3D 101, confirmed =3D 1);

 _EOF_

 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Melvin Davidson =




 --- On Tue, 6/2/09, owais <owais at preceptglobalaccess.com> wrote:

 From: owais <owais at preceptglobalaccess.com>
 Subject: [Slony1-general] How to shut-down slony replication
 To: slony1-general at lists.slony.info
 Date: Tuesday, June 2, 2009, 7:17 AM
Hi guys, I just start looking in to slony1 project. The project has impress=
ed me a lot. I have successfully manage to start the replication between tw=
o databases (one the same machine). I have used the following article to se=
tup slony replication (http://www.linuxjournal.com/article/7834). =


Now, I have the following questions:

1)What is the procedure to stop replication process? Can anyone present me =
a sample shell script?

2)Is it possible to toggle master and slave? I only have 1 master database =
and 1 slave. Can I change slave to master?

-Regards

Owais



 -----Inline Attachment Follows-----
_______________________________________________
 Slony1-general mailing list
Slony1-general at lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general






-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20090608/=
9b37114e/attachment-0001.htm