Re: Implementing Replication via pgAdmin

>> >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
>connections on each server to ensure they have actually connected. If
>not, check the log files/event log for error messages to see
>why not. If
>required, modify the config files or pgpass files are required and
>restart the slons.
>
>If they are connected and running, check that you have listens defined
>on each node in the cluster for every other node in the cluster (except
>the admin node).
>
>Regards, Dave.
>

Sigh, I am not getting anywhere, so it seems.

1) I have been able to completely reconstruct the replication  structure using pgAdmin3
2) I was able to manually run on the Master server, in a command window:  slon MasterCluster dbname=MyTest
user=postgreshost=copper.cdkkt.com 
  But I noticed the error:  "2007-09-19 17:42:39 Pacific Daylight Time ERROR  remoteWorkerThread_2:   "select
"_MasterCluster".setAddTable_int(1,3, '"public"."cars"',   'cars_pkey', ''); " PGRES_FATAL_ERROR ERROR:  Slony-I:
setAddTable_int:  table id 3 has already been assigned!" 
   Ignoring this error for now,

3) I was able to manually run on the Slave server, in a command window:  slon MasterCluster dbname=MyTest user=postgres
host=copper.cdkkt.com [No errors reported] 

4) Changed a value in MyTest.cars and it was successfully replicated to slave

5) Feeling that all was working, I proceeded on the master to run slonik:  > slonik slonyReplication.txt    [No errors
reported]
  [File configuration is:   #--  This defines which namespace the replication system uses   cluster name =
MasterCluster;
   #-- Admin conninfo's are used by the slonik program to connect   #-- to the node databases.  So these are the
PQconnectdbarguments   #-- that connect from the administrators workstation (where   #-- slonik is executed).   node 1
adminconninfo = 'dbname=MyTest host=copper.cdkkt.com user=postgres';   node 2 admin conninfo = 'dbname=MyTest
host=raider.cdkkt.comuser=postgres'; 
   #-- Node 2 subscribes set 1   subscribe set ( id = 1, provider = 1, receiver = 2, forward = yes);  ]

6) Proceeded on the slave to run slonik:  > slonik slonyReplication.txt  [No errors reported]
  [Same file configuration as above]

7) Restared master and slave services

8) Ran pgAdmin3 and noticed:
  on MASTER:  a) Master Node: Running PID: not running  b)  Slave Node: Running PID: administrative node
  on SLAVE:  a) Master Node: Running PID: not running  b)  Slave Node: Running PID: not running
  And of course, replication failed when a value is changed in MyTest.cars

9) So, I tried testing to see if the manually running slon on both  servers would work showing:
  on MASTER:  a) Master Node: Running PID: 1528  b)  Slave Node: Running PID: administrative node
  on SLAVE:  a) Master Node: Running PID: 1528  b)  Slave Node: Running PID: 1752
  And of course, replication still fails.
  Seems that my running of slonik messed up the configuration  as is shown where the slave Running PID =
'administrativenode' 

So -- what now?

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 manual slons.  Perhaps I do not have a good handle as to the
proper configuration files for slonik?

Thanks -
Dan

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.487 / Virus Database: 269.13.22/1015 - Release Date: 9/18/2007 11:53 AM