Vick Khera vivek at khera.org
Fri Oct 8 07:47:46 PDT 2010
On Fri, Oct 8, 2010 at 3:34 AM, stefano bonnin <stefano.bonnin at gmail.com> 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.


More information about the Slony1-general mailing list