Re: [GENERAL] Replication with slony-I

2008-10-29 Thread Abdul Rahman
pgbench tool (accounts, history, branches, tellers). whats going on! --- On Tue, 10/28/08, Abdul Rahman [EMAIL PROTECTED] wrote: From: Abdul Rahman [EMAIL PROTECTED] Subject: Re: [GENERAL] Replication with slony-I To: [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Date: Tuesday, October 28

Re: [GENERAL] Replication with slony-I

2008-10-29 Thread Raymond O'Donnell
On 29/10/2008 11:00, Abdul Rahman wrote: But, the implementation on existing database is not working for the tables already exists in the database. The replication is being only among four tables created via pgbench tool (accounts, history, branches, tellers). whats going on! You'll need

Re: [GENERAL] Replication with slony-I

2008-10-29 Thread Abdul Rahman
The link of the document, entitled Replicating Your First Database is as under: http://slony1.projects.postgresql.org/slony1-1.2.6/doc/adminguide/firstdb.html

Re: [GENERAL] Replication with slony-I

2008-10-29 Thread Abdul Rahman
Ok Ray! I will send the detail of my work soon. Thanks to All participants.

Re: [GENERAL] Replication with slony-I

2008-10-29 Thread Abdul Rahman
The detail of my work is as under:   As I mentioned earlier that platform is windows xp and using postgres 8.2 in which Slony- I is included. And all databases are at localhost.   After reading the document entitled “Replicating Your First Database” which is for Linux I optimized the

Re: [GENERAL] Replication with slony-I

2008-10-29 Thread Raymond O'Donnell
On 29/10/2008 12:55, Abdul Rahman wrote: 11. Got SUCCESS up to this point. Now I think this is *pgbench *which is responsible for replicating tables. No - it's Slony which is responsible for the replication. pgbench is just executing lots of SQL commands - SELECTs, UPDATEs, INSERTs,

Re: [GENERAL] Replication with slony-I

2008-10-29 Thread Abdul Rahman
TOO MANY THANKS RAY! I have got success in doing replication to an existing database. I did test on a dummy databases. But I am sure that I can implement to live project. Regards, Abdul Rehman.

Re: [GENERAL] Replication with slony-I

2008-10-28 Thread Ivano Luberti
]/* wrote: From: Raymond O'Donnell [EMAIL PROTECTED] Subject: Re: [GENERAL] Replication with slony-I To: [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Date: Monday, October 27, 2008, 7:17 PM On 27/10/2008 11:17, Abdul Rahman wrote: May any one support step

Re: [GENERAL] Replication with slony-I

2008-10-28 Thread Raymond O'Donnell
On 28/10/2008 07:52, Ivano Luberti wrote: Can you please publicly share a link to this document ? Surely - the docs are here: http://www.slony.info/documentation/ and the one you want ought to be listed in the table of contents. Ray.

[GENERAL] Replication with slony-I

2008-10-27 Thread Abdul Rahman
May any one support step by step procedure for the replication with slony-I in windows xp.

Re: [GENERAL] Replication with slony-I

2008-10-27 Thread postgres Emanuel CALVO FRANCO
http://slony.blogspot.com/ sorry is in spanish, but is an exelent resource, i hope it will be useful reggards 2008/10/27 Abdul Rahman [EMAIL PROTECTED]: May any one support step by step procedure for the replication with slony-I in windows xp. -- Emanuel Calvo Franco Syscope

Re: [GENERAL] Replication with slony-I

2008-10-27 Thread Raymond O'Donnell
On 27/10/2008 11:17, Abdul Rahman wrote: May any one support step by step procedure for the replication with slony-I in windows xp. There's a pretty good step-by-step guide in the Slony documentation - I haven't it to hand, but it's entitled Replicating your first database or something like

Re: [GENERAL] Replication with slony-I

2008-10-27 Thread Abdul Rahman
Thanks a lot  Ray! I have found the document and going to follow this. If I face any difficulty then will prompt to archive. Regards, Abdul. --- On Mon, 10/27/08, Raymond O'Donnell [EMAIL PROTECTED] wrote: From: Raymond O'Donnell [EMAIL PROTECTED] Subject: Re: [GENERAL] Replication

Re: [GENERAL] Replication using slony-I

2008-09-30 Thread Abdul Rahman
: [GENERAL] Replication using slony-I To: pgsql-general@postgresql.org Cc: [EMAIL PROTECTED], [EMAIL PROTECTED] 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

Re: [GENERAL] Replication using slony-I

2008-09-30 Thread Glyn Astill
From: Abdul Rahman [EMAIL PROTECTED] 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

Re: [GENERAL] Replication using slony-I

2008-09-30 Thread Abdul Rahman
, 9/30/08, Glyn Astill [EMAIL PROTECTED] wrote: From: Glyn Astill [EMAIL PROTECTED] Subject: Re: [GENERAL] Replication using slony-I To: pgsql-general@postgresql.org, [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Date: Tuesday, September 30, 2008, 1:36 PM From: Abdul Rahman [EMAIL PROTECTED] Dear All

Re: [GENERAL] Replication using slony-I

2008-09-30 Thread Glyn Astill
From: Abdul Rahman [EMAIL PROTECTED] Subject: Re: [GENERAL] Replication using slony-I To: pgsql-general@postgresql.org Cc: [EMAIL PROTECTED] 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

Re: [GENERAL] Replication using slony-I

2008-09-30 Thread Abdul Rahman
Dear all, Due to personal reason (to celebrate EID) I will rejoin my work from 06-Oct-2008. Regards, Abdul Rehman

Re: [GENERAL] Replication using slony-I

2008-09-29 Thread Richard Huxton
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.

Re: [GENERAL] Replication using slony-I

2008-09-29 Thread Abdul Rahman
I am not getting the New Subscription option when do right click on subscription (0) on the master node.

Re: [GENERAL] Replication using slony-I

2008-09-29 Thread Raymond O'Donnell
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

Re: [GENERAL] Replication using slony-I

2008-09-29 Thread Glyn Astill
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,

Re: [GENERAL] Replication using slony-I

2008-09-29 Thread Raymond O'Donnell
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

Re: [GENERAL] Replication using slony-I

2008-09-29 Thread Abdul Rahman
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

[GENERAL] Replication using slony-I

2008-09-28 Thread Abdul Rahman
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.