Tue Nov 27 13:08:05 PST 2007
- Previous message: [Slony1-general] Manually removing stuff from sl_log_1
- Next message: [Slony1-general] A Best Practices Question
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
We have several hundred tables in our DB and all should be replicated. Keeping the slon tools config file up to date is a bit of a worry for me. I thought that running the following sql inside the config file made the most sense, but wanted to get some consensus on how everyone manages their configs... SELECT relname FROM pg_class WHERE relkind = 'r' and relhaspkey is true and relowner = (select usesysid from pg_user where usename = 'foobar') ORDER BY relname A similar query is set to be run for sequences. I have only sequences and pkey'd tables. Does this make sense? Are there any pitfalls or caveats? Rob
- Previous message: [Slony1-general] Manually removing stuff from sl_log_1
- Next message: [Slony1-general] A Best Practices Question
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list