Re: Slony in pgAdmin - Mailing list pgadmin-hackers

From Andreas Pflug
Subject Re: Slony in pgAdmin
Date
Msg-id 432ECBF4.307@pse-consulting.de
Whole thread Raw
In response to Re: Slony in pgAdmin  ("Dave Page" <dpage@vale-housing.co.uk>)
Responses Re: Slony in pgAdmin  (Tomasz Rybak <bogomips@post.pl>)
Re: Slony in pgAdmin  ("Freddy91 (sent by Nabble.com)" <lists@nabble.com>)
List pgadmin-hackers
Dave Page wrote:

>
>
>>What's with Slony-I support in pgAdmin?
>>Is someone working on it?
>>
>>
>
>Absolutely. We (well, Andreas anyway) has to give a presentation of it
>to a large usergroup at the end of October, so it's definitely being
>worked on. We've spent a fair bit on plane tickets etc. so this one's on
>a real deadline!
>
>
I want to present it working, and have it released working in V1.4
(concurrent with pgsql 8.1), so that's the time frame.

>>When I use right-click New Object->Slony-I Cluster,
>>window appears, but on the bottom there is string:
>>"Slony-I creation scripts not available; only joining possible."
>>
>>
See Options. It used to be located over the path, has its setting now.

>>For example:
>>1. Create code for creating, deleting and managing clusters.
>>2. -''- -''- nodes.
>>3. -''- -''- sets, adding tables and sequences.
>>4. etc.
>>
>>
1), 2), 3) is working, as well as creating pgsql objects
replication-aware, i.e. using Slony-I.
4) is e.g. failover, which has to be coded yet, and some more. These
should cover the error-prone cases, and should receive a fair amount
review because taken from the slony mailing list quite a lot may go
wrong with that; lot of testing required.

>
>
>
>>I'd like to start playing a little with code.
>>If I start, I hope I won't get into someone's area,
>>so if someone is working at Slony support,
>>please let me know, and tell what's left to play with.
>>
>>
>
>
>
If you want to help, you can test, test, test.

>
>
>>And one last question.
>>There is no Slony documentation in pgAdmin, isn't?
>>
>>
>
>No. That should be failry easy to add assuming the Slony docs have the
>make htmlhelp target that pg does. I doubt Andreas has done anything on
>that if you want to look at it.
>
>
Unfortunately we'd need to write our own doc, since things are handled a
bit more abstract than with slonik. But we certainly should include the
whole slony doc as subtree in the main pgAdmin doc.
I don't know if anybody has ever tested to generate htmlhelp from slony,
whould be a good start to see if it works and can be compiled to a .CHM
with M$'s htmlhelp compiler, which would be a good start for further
integration.

Regards,
Andreas


pgadmin-hackers by date:

Previous
From: "Dave Page"
Date:
Subject: Slony scripts
Next
From: Andreas Pflug
Date:
Subject: Re: Slony scripts