Skip site navigation (1) Skip section navigation (2)

Re: Slony scripts

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: pgAdmin Hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Slony scripts
Date: 2005-09-19 14:38:43
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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.


In response to

pgadmin-hackers by date

Next:From: Diego GilDate: 2005-09-19 19:19:56
Subject: Re: wrong order of drop ... create ... sentences
Previous:From: Andreas PflugDate: 2005-09-19 14:32:20
Subject: Re: Slony in pgAdmin

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group