Re: Slony scripts - Mailing list pgadmin-hackers

From Andreas Pflug
Subject Re: Slony scripts
Date
Msg-id 432ECD73.9040408@pse-consulting.de
Whole thread Raw
In response to Slony scripts  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgadmin-hackers
Dave Page wrote:

>Hi Andreas
>
>I was thinking about including the Slony scripts with the
>pgAdmin/pgInstaller packaging. To save me rooting through the code to
>find it, where does we look for them at the moment? Also, how do we
>handle different Slony versions? Scripts in a subdirectory someplace, or
>do we rename them so they don't clash. Or do we say you can only create
>clusters in the version that you have installed the scripts for?
>
>

See slony path in options.
We don't maintain different versions, but assume that we're always using
the latest. When joining a cluster or upgrading a cluster (not the
first), all ddl info is extracted from existing clusters, so no scripts
are needed.
dlgRepClusterUpgrade implementation still to be coded; dlgRepCluster
schema reengineering code needs to be extracted to a standalone class.
It's also needed for initial schema creation as duplicate from an
existing source db, e.g. for new replication slaves. Should be a context
menu option opening the Query Tool with the ddl script for review.

Regards,
Andreas


pgadmin-hackers by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: Slony in pgAdmin
Next
From: Diego Gil
Date:
Subject: Re: wrong order of drop ... create ... sentences