Shaun McCloud wrote:
> Hello,
> 
>  
> 
> I am trying to replicate two databases in Windows (Web Server 2008R2 to 
> be exact) using Slony-I 1.2.15 & PostgreSQL 8.3 (my hands are tied on 
> the PostgreSQL version for right now).  The guide I found to go by is 
> from the kind folks at EnterpriseDB and works great for one database.  
> If I setup separate services for each database in my pg_service.conf 
> file I get event viewer errors asking if I am using the correct database 
> when trying to subscribe the slaves to the first replication set.  I 
> know it would be easier to put the two tables (yes, that’s all I am 
> replicating total) into the same database, but if I do that then we have 
> to modify our customers data and we would like to avoid that if at all 
> possible.  Am I just trying to do something that isn’t possible?

I should say that Slony under Win32 doesn't seem to get a lot of use, so 
   I can't rule out their being unreported problems under win32.

In theory you should be able to have both databases on the same server. 
  What service names are your slons using?  sr_routing_01-slonik and 
sr_routing_02-slonik are both pointing at the same database, is this 
what you intended?  I see lots of entries in that conf file but you only 
have 2 databases (that you have told us about) so I would only expect 
you to need to slon services.



> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general


-- 
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142