That script works fine for me and the output looks good, although unless I missed something I had to modify it slightly to allow setting of the postgres host,user,port and database name for the varioous psql commands, ie making them things like:
RESULTSET=`psql $pgargs -qtA -F ":" -R " " -c "${QUERY}" $pgdb`
where pgargs="-h hostname -U username -p port"
and pgdb="dbname"
Mark
On Mon, 2009-08-10 at 11:39 -0400, Christopher Browne wrote:
> Mark Hagger <[email protected]> writes:
> > Just to clarify, your plan would mean that I would be able to:<BR>
> > <BR>
> > 1) run a script that dumps enough information to re-create the cluster from
> > its current state<BR>
> > 2) do the various unsubscribes/uninstalls of slony 1.x bits<BR>
> > 3) Install new slony 2.x code<BR>
> > 4) run this dumped script (more or less) to bring my cluster back to
> > life<BR>
> > <BR>
> > For me the key bit is (1), since my cluster configurations (I have several
> > created over a long period of time) means that my heart sinks at the idea
> > of<BR>
> > having to re-create all the clusters from scratch, plus the OMIT COPY bit
> > looks like a huge win.<BR>
> > <BR>
>
> That sounds about right!
>
> Here's the script to "dump enough information"...
>
> <http://main.slony.info/viewcvs/viewvc.cgi/slony1-engine/tools/slonikconfdump.sh?revision=1.1.2.4&view=markup&sortby=date>
>
> You should be able to run that script against your existing cluster;
> I'd urge that you try it out, to see what output you get, and to
> validate that it agrees with what you'd expect.
---
Mark Hagger
Senior Software Engineer
mxData Ltd
Incorporating m-spatial
Head Office: Alderley House, Alderley Road, Wilmslow, Cheshire, SK9 1AT
Technology Centre: St John’s Innovation Centre, Cowley Road, Cambridge,
CB4 0WS
Marketing & PR: 85 Tottenham Court Road, London, W1T 4TQ
[email protected]
www.mxdata.co.uk
M: +44(0)7814 020931
T: +44 (0)1223 421534
________________________________________________________________________
This e-mail and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed. The
opinions expressed in this e-mail are those of the author and do not
necessarily represent the views of m-spatial Ltd, mxData Ltd or any affiliates.
No reliance may be placed on this e-mail without the written confirmation from
an expressed representative of m-spatial Ltd or mxData Ltd. Any prices or terms
expressed within this e-mail are subject to contract. If you are not the
intended recipient of this email, please notify the [email protected].<<attachment: mxdata.jpg>>
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
