Re: [pgadmin-support] Implementing Replication via pgAdmin

2007-09-21 Thread Dave Page
Daniel B. Thurman wrote: > # Set the cluster name that this instance of slon is running against > # default is to read it off the command line > cluster_name='MasterCluster' > > # Set slon's connection info, default is to read it off the command line > conn_info='host=copper.cdkkt.com port=5432 db

Re: [pgadmin-support] Implementing Replication via pgAdmin

2007-09-21 Thread Daniel B. Thurman
>> All is fine except that these slons are running as >> foreground processes and cannot be backgrounded and >> killing the command window will terminate the process! >> How can I get the slons running without resorting to >> using command windows to start the replication processes? > >Install t

Re: [pgadmin-support] Implementing Replication via pgAdmin

2007-09-21 Thread Dave Page
Daniel B. Thurman wrote: All is fine except that these slons are running as foreground processes and cannot be backgrounded and killing the command window will terminate the process! How can I get the slons running without resorting to using command windows to start the replication pr

Re: [pgadmin-support] Implementing Replication via pgAdmin

2007-09-20 Thread Daniel B. Thurman
Configuring Replication on Windows, using pgAdmin3 v8.0 Beta 5 == On Master: == 1) Adding a new Master Replication Set: a) Right-click 'Replication', and select: 'New slony-I Cluster...' b) UnCheck: Join existing cluster c) Enter: Cluster name: MasterClust

Re: [pgadmin-support] Implementing Replication via pgAdmin

2007-09-20 Thread Dave Page
On Wed, 2007-09-19 at 19:00 -0700, Daniel B. Thurman wrote: > What am I doing wrong with the slonik configuration file that so messed > it all up and is it possible to remove this configuration using pssql? > > I know I can tear everything down again and start over, but I would end > up using manu

Re: [pgadmin-support] Implementing Replication via pgAdmin

2007-09-19 Thread Daniel B. Thurman
>> >I see that my Master and Slave replication process is not >> >even running so at this point I am not sure how to start >> >them running. > >Are the slons running? They should be started from the Services control >panel applet after the engines are registered. When they are, check the >connect

Re: [pgadmin-support] Implementing Replication via pgAdmin

2007-09-19 Thread Daniel B. Thurman
As suggested by Dave, The following link is a jpeg File, size 274K, showing the pgAdmin3 setup I have so far. Note that there are a couple of problems already found: 1) The Cluster name is now: CopperMasterCluster. I think that slonik does not like '-' characters. 2) The entries for dbname

Re: [pgadmin-support] Implementing Replication via pgAdmin

2007-09-18 Thread Daniel B. Thurman
I have gone over the following document: http://www.slony.info/documentation/firstdb.html To get some idea of what is going on (at the manual level) as to how replication services works. From what I have done, was to manually start the slon for the master and server sides the following: MASTER:

Re: [pgadmin-support] Implementing Replication via pgAdmin

2007-09-18 Thread Dave Page
Daniel B. Thurman wrote: > I changed an entry in the myTest database table and I do not see this value > replicated to the slave db. Is there something more I need to do after coming > this far along? > > So far I see: > >On Master Server: >-Master-Cluster > Nodes (3) >

Re: [pgadmin-support] Implementing Replication via pgAdmin

2007-09-17 Thread Daniel B. Thurman
>> Thanks Dave. >> >> But I am having some trouble trying to get replication to work. >> >> Here is what I did: >> >> 1) On master server: >>a) I registered: lib/slevent.dll >>b) I register as a service: slon -regservice >>c) slon -listengines >> 2 engine(s) registered for serv

Re: [pgadmin-support] Implementing Replication via pgAdmin

2007-09-17 Thread Dave Page
Daniel B. Thurman wrote: > Thanks Dave. > > But I am having some trouble trying to get replication to work. > > Here is what I did: > > 1) On master server: >a) I registered: lib/slevent.dll >b) I register as a service: slon -regservice >c) slon -listengines > 2 engine(s) regis

Re: [pgadmin-support] Implementing Replication via pgAdmin

2007-09-17 Thread Daniel B. Thurman
e' since the 'Cluster Name' must have a value and 'OK' remains greyed out. So I am at loss to go any further... Any advice? >-Original Message- >From: Dave Page [mailto:[EMAIL PROTECTED] >Sent: Monday, September 17, 2007 8:58 AM >To: Da

Re: [pgadmin-support] Implementing Replication via pgAdmin

2007-09-17 Thread Dave Page
Daniel B. Thurman wrote: > I have tried to follow the pgAdmin slony support in the help sections > of pgAdmin and it seems to be inconsistent. For example, it is not > intuitively clear from the help sections how exactly to setup the master > and slave configurations. From a windows client perspe

[pgadmin-support] Implementing Replication via pgAdmin

2007-09-17 Thread Daniel B. Thurman
I have tried to follow the pgAdmin slony support in the help sections of pgAdmin and it seems to be inconsistent. For example, it is not intuitively clear from the help sections how exactly to setup the master and slave configurations. From a windows client perspective, it seems that one must us