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-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
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 instr

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 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 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

Re: [GENERAL] Replication with slony-I

2008-10-29 Thread Abdul Rahman
reated via 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

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. ---

Re: [GENERAL] Replication with slony-I

2008-10-28 Thread Ivano Luberti
27/08, Raymond O'Donnell /<[EMAIL PROTECTED]>/* 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, 2

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: [GEN

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 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 Sysc

[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.