Re: Slony in pgAdmin - Mailing list pgadmin-hackers

From Dave Page
Subject Re: Slony in pgAdmin
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E4CC2CFF@ratbert.vale-housing.co.uk
Whole thread Raw
In response to Slony in pgAdmin  (Tomasz Rybak <bogomips@post.pl>)
Responses Re: Slony in pgAdmin
List pgadmin-hackers

> -----Original Message-----
> From: pgadmin-hackers-owner@postgresql.org
> [mailto:pgadmin-hackers-owner@postgresql.org] On Behalf Of
> Tomasz Rybak
> Sent: 18 September 2005 21:58
> To: pgAdmin Hackers
> Subject: [pgadmin-hackers] Slony in pgAdmin
>
> As I might need Slony in my project, I decided to look
> at it more closely.
>
> 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!

> 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."

The Slony SQL scripts need to be somewhere that pgAdmin can find them. I
forget where off-hand, but watch the list because I was going to email
Andreas about it this morning anyway!

> I tried to look into source code, but I'm not sure where to start,
> and what should be done.
> Is there any plan of implementing Slony support in pgAdmin?
> For example:
> 1. Create code for creating, deleting and managing clusters.
> 2. -''- -''- nodes.
> 3. -''- -''- sets, adding tables and sequences.
> 4. etc.

All that was certainly there for Slony 1.0 last time I tried it. Andreas
has been working on support for 1.1/1.2 most recently.

> And, if I've seen correctly, pgAdmin doesn't use slonik,
> and creates it's own queries to do things in cluster.
> Is it right?

Yes.

> 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.

To be honest, I would keep out of there for the moment unless Andreas
has anything specific he'd like some help with.

> I think that the best place to start would be
> cluster code, located in dlgRepCluster and slCluster.
> Is that right?

Yes.

> 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.

Regards, Dave.

pgadmin-hackers by date:

Previous
From: svn@pgadmin.org
Date:
Subject: SVN Commit by andreas: r4455 - in trunk/pgadmin3/src: dlg frm include
Next
From: "Dave Page"
Date:
Subject: Slony scripts