I'm extremely green when it comes to databases, so forgive my ignorance. I've been researching ways to replicate our production Postgres DB, and I've decided to try out Slony. Since the server is running Ubuntu 10.04, I'm stuck with Postgres version 8.4 and Slony 1.2. I've been using this guide, which has proven extremely helpful, but I don't fully understand all of what I'm doing.
My issue is that I'm not sure what I need to put in the slon_tools.conf file in the section "pkeyedtables". I listed all of the tables in our current database, and there are a total of 205. Do I need to specify each one in the "pkeyedtables" section? And if so, what format do I need to write them in? Some of the table names are like "AO_60DB71_SUBQUERY", while others are like "userassociation".