Step 12: Create a slon.conf File

Had a couple of people ask me about the slon.conf file I mentioned in my [http://people.planetpostgresql.org/xzilla/index.php?/archives/200-Alpha-testing-Slony-on-win32-Crib-Notes.html slony win32 crib notes]. My theory is that people don’t know about this since, on Linux, you just never really needed to use it. Maybe if you were doing something unique with slony, but I tend to find the defaults work pretty well. Anyway the best place to find a sample slony.conf file is [http://gborg.postgresql.org/cgi-bin/cvsweb.cgi/slony1-engine/share/slon.conf-sample?cvsroot=slony1 right in the cvs]. In fact the one I used was darn near a direct copy of that, except that on Windows you need to uncomment out the #cluster_name='sloncluster' and #conn_info='host=/tmp port=5432 user=slony' settings and modify them appropriately. Not too big of a deal but it kind of trips you up if you’re not familiar with it.