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