Replication using slony-I

Abdul Rahman wrote:

Hi all,

I am following the steps present in this link:

http://people.planetpostgresql.org/dpage/index.php?/archives/51-Setting-up-Slony-I-with-pgAdmin.html

But failed to complete step # 13. Here I am unable to get CREATE NEW
SUBSCRIPTION. Can any body guide me plz.

What does happen - do you get an error? Is there anything in the
postgresql logs?

--
Richard Huxton
Archonet Ltd

I am not getting the "New Subscription" option when do right click on subscription (0) on the master node.

On 29/09/2008 08:49, Abdul Rahman wrote:

I am not getting the "New Subscription" option when do right click on
subscription (0) on the master node.

It sounds like you're using pgAdmin - IIRC you need to have some parts
at least of Slony installed on the machine on which pgAdmin is running.

There are separate lists for both Slony and pgAdmin - you might get more
useful information there, but you'll need to post a good bit more
information about your setup, what you did and what you're getting back.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

I am not getting the "New Subscription"

option when do right click on

subscription (0) on the master node.

It sounds like you're using pgAdmin - IIRC you need to
have some parts
at least of Slony installed on the machine on which pgAdmin
is running.

Personally I prefer to use slonik, pgAdmin for slony based tasks is too unpolished to be used in my opinion, it needs a bit more work.

The whole problem with having clicky menus is that it allows you do do things without full knowledge of what's going off, and that can never be the case with slony.

For example here's a scenario using pgadmin to add a table into a set:

clicky: new replication set
clicky: add table to set
clicky: subsctribe to set
clicky: merge set

Did pgAdmin force you to wait until the subscription had completed before merging? No, and now you have a mess.

On 29/09/2008 14:23, Glyn Astill wrote:

The whole problem with having clicky menus is that it allows you do
do things without full knowledge of what's going off, and that can
never be the case with slony.

I agree, and I prefer to use Slonik as well. The example given in the
docs was good enough to get me started.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

Thanks a lot for replying!

Here is complete information for consideration:
In order to perform replication. I am following the steps present in

http://people.planetpostgresql.org/dpage/index.php?/archives/51-Setting-up-Slony-I-with-pgAdmin.html

and successfully reached to step # 13. I have Slony-I pgAdmin-III included in postgresql-8.2 and the platform is WindowsXp. But here I am not getting the "NewSubscription" option when do right click on Subscription Set.

I also worked and found that the command  in step # 4

psql -U postgres slave1 < schema.sql

is not working because I am not getting the tables in either slave. So, I suppose I have to run the command in step # 2

pgbench -i -U postgres master

for slave1 and slave2 instead of making sql script and running it. I am going to restart my work in this way. Glyn Astill you may explore slonik in detail that I may use it now. So many Thanks Again.

Dear All,

I worked again from very start and faced the same problem which encountered earlier. 
In order to perform replication. I am following the steps present in

http://people.planetpostgresql.org/dpage/index.php?/archives/51-Setting-up-Slony-I-with-pgAdmin.html

and
successfully reached to step # 13. I have Slony-I pgAdmin-III included
in postgresql-8.2 and the platform is WindowsXp. But here I am not
getting the "NewSubscription" option when do right click on
Subscription Set.

--- On Tue, 9/30/08, Abdul Rahman <abr_ora@yahoo.com> wrote:
From: Abdul Rahman <abr_ora@yahoo.com>
Subject: Re: [GENERAL] Replication using slony-I
To: pgsql-general@postgresql.org
Cc: rod@iol.ie, glynastill@yahoo.co.uk
Date: Tuesday, September 30, 2008, 9:55 AM

Thanks a lot for replying!

Here is complete information for consideration:
In order to perform replication. I am following the steps present in

http://people.planetpostgresql.org/dpage/index.php?/archives/51-Setting-up-Slony-I-with-pgAdmin.html

and successfully reached to step # 13. I have Slony-I pgAdmin-III included in postgresql-8.2 and the platform is WindowsXp. But here I am not getting the "NewSubscription" option when do right click on Subscription Set.

I also worked and found that the command  in step # 4

psql -U postgres slave1 < schema.sql

is not working because I am not getting the tables in either slave. So, I suppose I have to run the command in step # 2

pgbench -i -U postgres master

for slave1 and slave2 instead of making sql script and running it. I am
going to restart my work in this way. Glyn Astill you may explore slonik in detail that I may use it now. So many Thanks Again.

From: Abdul Rahman <abr_ora@yahoo.com>
Dear All,

I worked again from very start and faced the same problem
which encountered earlier. 
In order to perform replication. I am following the steps
present in

http://people.planetpostgresql.org/dpage/index.php?/archives/51-Setting-up-Slony-I-with-pgAdmin.html

and
successfully reached to step # 13. I have Slony-I
pgAdmin-III included
in postgresql-8.2 and the platform is WindowsXp. But here I
am not
getting the "NewSubscription" option when do
right click on
Subscription Set.

Are all the slons running, and do you see the connections on each node. Under the pgAdmin replication->nodes tab on every node do you see every node listed allong with it's paths and listens.

How will I get know that all slons are running? However in the replication "pgbench" properties the value of Slon PID is Not Running in each node. Yes, every node is listed with its path and listen. And what do you mean by "do you see the connections on each node".

Thanks Glyn Astill.

--- On Tue, 9/30/08, Glyn Astill <glynastill@yahoo.co.uk> wrote:
From: Glyn Astill <glynastill@yahoo.co.uk>
Subject: Re: [GENERAL] Replication using slony-I
To: pgsql-general@postgresql.org, abr_ora@yahoo.com
Cc: rod@iol.ie
Date: Tuesday, September 30, 2008, 1:36 PM

From: Abdul Rahman <abr_ora@yahoo.com>
Dear All,

I worked again from very start and faced the same problem
which encountered earlier. 
In order to perform replication. I am following the steps
present in

http://people.planetpostgresql.org/dpage/index.php?/archives/51-Setting-up-Slony-I-with-pgAdmin.html

and
successfully reached to step # 13. I have Slony-I
pgAdmin-III included
in postgresql-8.2 and the platform is WindowsXp. But here I
am not
getting the "NewSubscription" option when do
right click on
Subscription Set.

Are all the slons running, and do you see the connections on each node. Under
the pgAdmin replication->nodes tab on every node do you see every node listed
allong with it's paths and listens.

From: Abdul Rahman <abr_ora@yahoo.com>
Subject: Re: [GENERAL] Replication using slony-I
To: pgsql-general@postgresql.org
Cc: glynastill@yahoo.co.uk
Date: Tuesday, 30 September, 2008, 9:51 AM
How will I get know that all slons are running? However in
the replication "pgbench" properties the value of
Slon PID is Not Running in each node. Yes, every node is
listed with its path and listen. And what do you mean by
"do you see the connections on each node".

Do you see connections into postgres for your slony user from each other node. If you're on windows you'll be able to see them in task manager and in the status tab of pgAdmin "Server Status".

Is there anything odd in the slony logs?

I presume you hace created a replication set with some tables in it, and you're right clicking on the origin and selecting new object, art the other objects in the list or are you just missing subscribe?

Dear all,

Due to personal reason (to celebrate EID) I will rejoin my work from 06-Oct-2008.

Regards,
Abdul Rehman