Re: Good examples of calling slony stored procedures

Hi

I was wondering if where can I find some examples of calling the slony
stored procedures instead of using slonik? I want to be able to for
example add a table into slony. Thanks

Mark Adan

"Mark Adan" <markadan(at)ati(dot)com> writes:
> I was wondering if where can I find some examples of calling the slony
> stored procedures instead of using slonik? I want to be able to for
> example add a table into slony. Thanks

This is likely the wrong bunch to ask --- there's a slony project
mailing list where the right people to ask hang out. Don't have
the address at hand.

regards, tom lane

Hi

Can somebody direct me to the mailing list for slony. I couldn't find
it anywhere on the postgres.org website (which is where I found this
list to begin with). Thanks

Mark

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Tuesday, June 13, 2006 20:27
To: Mark Adan
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Good examples of calling slony stored procedures

"Mark Adan" <markadan(at)ati(dot)com> writes:
> I was wondering if where can I find some examples of calling the slony
> stored procedures instead of using slonik? I want to be able to for
> example add a table into slony. Thanks

This is likely the wrong bunch to ask --- there's a slony project
mailing list where the right people to ask hang out. Don't have
the address at hand.

regards, tom lane

try www.slony.info

---------- Original Message -----------
From: "Mark Adan" <markadan(at)ati(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Sent: Wed, 14 Jun 2006 08:50:23 -0700
Subject: Re: [SQL] Good examples of calling slony stored procedures

> Hi
>
> Can somebody direct me to the mailing list for slony. I couldn't find
> it anywhere on the postgres.org website (which is where I found this
> list to begin with). Thanks
>
> Mark
>
> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Tuesday, June 13, 2006 20:27
> To: Mark Adan
> Cc: pgsql-sql(at)postgresql(dot)org
> Subject: Re: [SQL] Good examples of calling slony stored procedures
>
> "Mark Adan" <markadan(at)ati(dot)com> writes:
> > I was wondering if where can I find some examples of calling the slony
> > stored procedures instead of using slonik? I want to be able to for
> > example add a table into slony. Thanks
>
> This is likely the wrong bunch to ask --- there's a slony project
> mailing list where the right people to ask hang out. Don't have
> the address at hand.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
------- End of Original Message -------

Hi Jim

I looked there already and didn't find what I needed. I saw this web
page from cbbrowne and he briefly talked about using "bare metal" slony
functions, but doesn't have any examples.

Mark

-----Original Message-----
From: Jim Buttafuoco [mailto:jim(at)contactbda(dot)com]
Sent: Wednesday, June 14, 2006 08:53
To: Mark Adan; pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Good examples of calling slony stored procedures

try www.slony.info

---------- Original Message -----------
From: "Mark Adan" <markadan(at)ati(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Sent: Wed, 14 Jun 2006 08:50:23 -0700
Subject: Re: [SQL] Good examples of calling slony stored procedures

> Hi
>
> Can somebody direct me to the mailing list for slony. I couldn't find
> it anywhere on the postgres.org website (which is where I found this
> list to begin with). Thanks
>
> Mark
>
> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Tuesday, June 13, 2006 20:27
> To: Mark Adan
> Cc: pgsql-sql(at)postgresql(dot)org
> Subject: Re: [SQL] Good examples of calling slony stored procedures
>
> "Mark Adan" <markadan(at)ati(dot)com> writes:
> > I was wondering if where can I find some examples of calling the
slony
> > stored procedures instead of using slonik? I want to be able to for
> > example add a table into slony. Thanks
>
> This is likely the wrong bunch to ask --- there's a slony project
> mailing list where the right people to ask hang out. Don't have
> the address at hand.
>
> regards, tom lane
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
------- End of Original Message -------

On Wed, Jun 14, 2006 at 08:55:21AM -0700, Mark Adan wrote:
> Hi Jim
>
> I looked there already and didn't find what I needed. I saw this web

But the mailing list link is at the top of that page:

http://gborg.postgresql.org/mailman/listinfo/slony1

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
Information security isn't a technological problem. It's an economics
problem.
--Bruce Schneier

Excellent. I will subscribe to that one. Thanks

Mark

-----Original Message-----
From: pgsql-sql-owner(at)postgresql(dot)org
[mailto:pgsql-sql-owner(at)postgresql(dot)org] On Behalf Of Andrew Sullivan
Sent: Wednesday, June 14, 2006 09:14
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Good examples of calling slony stored procedures

On Wed, Jun 14, 2006 at 08:55:21AM -0700, Mark Adan wrote:
> Hi Jim
>
> I looked there already and didn't find what I needed. I saw this web

But the mailing list link is at the top of that page:

http://gborg.postgresql.org/mailman/listinfo/slony1

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
Information security isn't a technological problem. It's an economics
problem.
--Bruce Schneier

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Martha Stewart called it a Good Thing when markadan(at)ati(dot)com ("Mark Adan") wrote:
> I looked there already and didn't find what I needed. I saw this web
> page from cbbrowne and he briefly talked about using "bare metal" slony
> functions, but doesn't have any examples.

If you look at the source code for the slonik utility, it shows how
the functions actually get used.

In most cases, slonik.c submits fairly simple requests using the
functions in slony1-funcs.sql.

For instance, the slonik MOVE SET (id=1, old origin=11, new origin=22);
command runs a bunch of C "deteriorata" that is a wrapper for:

select _slony_schema.moveset(1, 22);

Plenty of the commands are about as simple as that.

And this means that, for these "simple" operations, if you want to
submit them via SQL queries, there's a very thin veiling you need to
do to submit the functions as SQL selects.

There are more complex cases, such as FAIL OVER, SET ADD TABLE,
EXECUTE SCRIPT, UPDATE FUNCTIONS, and WAIT FOR EVENT, where there is
considerably complex logic in addition to what is in the stored procs.

Looking at slonik.c is the best thing I can suggest you do...
--
"cbbrowne","@","cbbrowne.com"
http://linuxdatabases.info/info/x.html
Signs of a Klingon Programmer #6: "Debugging? Klingons do not
debug. Our software does not coddle the weak."