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".

  • 1
    Since the server is running Ubuntu 10.04, I'm stuck with Postgres version 8.4 and Slony 1.2. No, you aren't. Please use apt.postgresql.org . 8.4 is end-of-life, outdated, unsupported. You can pg_upgrade from 8.4 to 9.3. – Craig Ringer Aug 15 '14 at 1:19
  • If you're new to databases, Slony is not the way to go. It's complicated and fiddly. Use PostgreSQL's built-in streaming replication and a hot standby read replica. – Craig Ringer Aug 15 '14 at 1:26
  • Okay, I'll discuss upgrading the DB with my team. @CraigRinger, would you say that the native replication is worth the upgrade from 8.4 to 9.3? – zymhan Aug 15 '14 at 19:47
  • Most of the core replication features were in 8.4, so not for replication alone. It's a good idea to plan and prepare for an upgrade every 5 versions or so just because they drop out of community support - no OS compatibility fixes, bug fixes, etc, and nobody remembers them well enough to provide as much help. There are also lots of other improvements since 8.4; check the release highlights for each version. You'll be more excited by 9.5 in terms of replication. – Craig Ringer Aug 17 '14 at 12:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.