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

Re: Slony in pgAdmin

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Tomasz Rybak" <bogomips(at)post(dot)pl>,"pgAdmin Hackers" <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: Slony in pgAdmin
Date: 2005-09-19 07:24:34
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E4CC2CFF@ratbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-hackers
 

> -----Original Message-----
> From: pgadmin-hackers-owner(at)postgresql(dot)org 
> [mailto:pgadmin-hackers-owner(at)postgresql(dot)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.

Responses

pgadmin-hackers by date

Next:From: Dave PageDate: 2005-09-19 07:27:41
Subject: Slony scripts
Previous:From: svnDate: 2005-09-18 21:23:34
Subject: SVN Commit by andreas: r4455 - in trunk/pgadmin3/src: dlg frm include

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