Thread: Replication using slony-I
| 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. |
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 bitmore 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> pgbench -i -U postgres masterGlyn 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> |
> 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 everynode 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> |
> 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 seethem 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 selectingnew 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 |