Christopher Browne cbbrowne at afilias.info
Tue May 22 10:12:14 PDT 2012
On Tue, May 22, 2012 at 11:36 AM, Shaun McCloud <smccloud at geo-comm.com> wrote:
> Is it possible/feasible to use the Slony-I Creation scripts designed for use
> in pgAdmin III outside of pgAdmin III?  I need to write a utility to make it
> easier for our installers to setup Slony-I and I’d like to use the official
> scripts to do it but I’m unsure how to go about it right now.

The last discussion I had (if memory serves, with Dave Page, almost
exactly a year ago, at PGcon...  If my memory isn't entirely correct,
then it's still Dave Page, still PGcon, but it would be *TWO* years
ago...) indicated that pgAdmin III hasn't been tracking Slony
functionality for a *long* time now.

What pgAdmin III *had* been doing was to run some of the Slony stored
procedures, effectively duplicating parts of what is implemented in
Slonik (<http://git.postgresql.org/gitweb/?p=slony1-engine.git;a=tree;f=src/slonik;h=819d809475fdd45b3d2d58107ae39d7eb7c77a5d;hb=HEAD>).
 Now, what they last duplicated was most likely code from Slony 1.2.
(Hence looking like
<http://git.postgresql.org/gitweb/?p=slony1-engine.git;a=tree;f=src/slonik;h=92406ed729c6418b779134fd177f54aaae038174;hb=refs/heads/REL_1_2_STABLE>.)

There have been rather a lot of changes since version 1.2, and
functionality of slonik varies, in ways that sometimes matter, from
version to version to version, and the pgAdmin III devs stopped
tracking things way back.

The recommendation in these "modern days" is that cluster management
should be done using Slonik scripts, and for Slony 2.1 and later,
that's really rather crucial, as slonik has functionality that
wouldn't be terribly appropriate to even attempt to integrate into
pgAdmin III.


More information about the Slony1-general mailing list