On Fri, Oct 8, 2010 at 3:34 AM, stefano bonnin <[email protected]> wrote: > Hi, I have to use slony in order to upgrade my 8.4.5 version to 9.0.1. > I never used slony. My database have a lot of tables and I'd like to know a > fast way for configuring slony in this case. have I to insert all tables in > the configuration file? or there is a fast way in order to achieve this > (something like myschema.* or mydatabase.*)
You have to insert them all into the config file. However nothing is forcing you to do that manually. Write a script (or find one online) that will generate the config file for you by inspecting your schema. I often use the output of the \d psql command and feed it into a short perl script to generate the repetitive bits. _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
