Thread: 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@ati.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@sss.pgh.pa.us]
Sent: Tuesday, June 13, 2006 20:27
To: Mark Adan
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Good examples of calling slony stored procedures
"Mark Adan" <markadan@ati.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@ati.com> To: <pgsql-sql@postgresql.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@sss.pgh.pa.us] > Sent: Tuesday, June 13, 2006 20:27 > To: Mark Adan > Cc: pgsql-sql@postgresql.org > Subject: Re: [SQL] Good examples of calling slony stored procedures > > "Mark Adan" <markadan@ati.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@contactbda.com] Sent: Wednesday, June 14, 2006 08:53 To: Mark Adan; pgsql-sql@postgresql.org Subject: Re: [SQL] Good examples of calling slony stored procedures try www.slony.info ---------- Original Message ----------- From: "Mark Adan" <markadan@ati.com> To: <pgsql-sql@postgresql.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@sss.pgh.pa.us] > Sent: Tuesday, June 13, 2006 20:27 > To: Mark Adan > Cc: pgsql-sql@postgresql.org > Subject: Re: [SQL] Good examples of calling slony stored procedures > > "Mark Adan" <markadan@ati.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@crankycanuck.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@postgresql.org [mailto:pgsql-sql-owner@postgresql.org] On Behalf Of Andrew Sullivan Sent: Wednesday, June 14, 2006 09:14 To: pgsql-sql@postgresql.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@crankycanuck.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@ati.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."