On Sat, 17 Mar 2007, Mikko Partio wrote:
Your getting this because your EVENT_NODE is 1 but you only want to execute
the script on 2.
Slonik probably should have a check to see if you have specified an only
excecute different than your event node and just submit the script into the
queue at
On Sat, 17 Mar 2007, Steve Singer wrote:
The attached patch against 1.2 should fix this bug by not
executing your DDL on the event node.
If your DDL has errors then you won't find out about it
until slon tries to execute it on the other node (slonik won't give you an
error but maki
On Wed, 21 Mar 2007, Sven Willenberger wrote:
The other issue with DDL scripts is that they do not honor SET
subscription members; certain portions of the sequence of events during
a DDL execute attempt actions on nodes not part of the affected SET.
http://lists.slony.info/pipermail/slony1-gene
On Sat, 17 Mar 2007, Steve Singer wrote:
The attached patch replaces the one I sent last week. This version has the
only_on execute script executed directly against the subscriber node by
slonik as discussed on slony1-general.
Also per the discussion on general this patch also includes a
On Tue, 27 Mar 2007, Alan Hodgson wrote:
I don't know what workarounds are going to be options for you compared with
running a patched version of slony but if you
need a fix right away you could consider patching your version of slony.
The patched attached to
http://lists.slony.info/pipermai
On Wed, 28 Mar 2007, Alan Hodgson wrote:
Thank you for that. I will test it and consider running with it for now.
However, I actually think the intended behaviour for 1.2 is correct -
DDL scripts should execute on all nodes (working around the 1.1
behaviour was also quite tedious). It just isn
On Thu, 7 Jun 2007, Marlon Petry wrote:
I posted some instructions on this to the list a while back including a
config file (attached to the second post)
You can get them at:
http://lists.slony.info/pipermail/slony1-general/2006-September/004845.html
http://lists.slony.info/pipermail/slony1-ge
Is there anything we can do for 2.0 to improve DDL use cases?
I had sent out a patch a while back that lets EXECUTE SCRIPT take a list of
tables to lock (thus not locking everything). I never did get any feedback
on the patch. If there is interest I can try to bring it up to the current
2.
On Sat, 24 Nov 2007 [EMAIL PROTECTED] wrote:
Anyway... suppose I don't have the choice (which I have) and have to
work with rails + slony. Could you provide an opinion other than drop
rails?
You could use rails but not use the rake migrations for schema updates and
handle them manually.
I'v
On Mon, 26 Nov 2007, Jacques Caron wrote:
One thing that would actually add more complexity, but would probably be
quite useful: add options to EXECUTE SCRIPT to only lock (and
un-trigger/re-trigger) specific tables (i.e. the ones that are actually
affected, but manually specified in the opti
On Sat, 5 Apr 2008, Hannu Krosing wrote:
The sad thing about slony is that I still can't put my finger on one
thing that is wrong with slony and say "if you fix this then it is ok".
Maybe the question you/we should be asking is "What are the the list of
things that are wrong with slony and h
On Wed, 9 Apr 2008, Shoaib Mir wrote:
Shoaib,
Getting slony 1.2.13 to build with cc on OpenSolaris just requires a small
change to the src/slonik/Makefile.
A patch is attached. (Just add -I. to the slonik CFLAGS).
HEAD seems to build fine with sun studio as is.
Steve
ahh just got around
eneral@lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
___
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general
_
> Slony1-general mailing list
> Slony1-general@lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
___
Slony1-general mail
On Sun, 21 Mar 2010, Philippe Clérié wrote:
So I cannot just restart Node1, restart Slony on both nodes and do MOVE SET?
If I get the docs correctly, FAILOVER assumes the original node is not
coming back up. Actually it's up but I haven't reconnected it to the
internet pending a solution to the
can also be sent from node A to node B before node B
receives the original chance from node C.
When does something cross the line from being unmanageable to
unworkable? Rather than debating that point you are probably better off
spending time trying to find a way to do what you want without having
> last_analyze | 2010-03-20 22:59:38.858321-05
> last_autoanalyze | 2010-03-20 13:24:02.694223-05
>
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
___
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general
row)
>
> select count(*) from _dbprod_cluster.sl_log_2;
>
> count
> ---
> 0
> (1 row)
>
> select st_lag_num_events from _dbprod_cluster.sl_status;
>
> st_lag_num_events
> ---
> 16130
> (1 row)
>
> Could anybod
Ben Chobot wrote:
> On Mar 22, 2010, at 7:10 PM, Steve Singer wrote:
> Right, if we make the origins on different nodes, that's clearly asking for
> problems. But if we keep all set origins to be on the same node? I understand
> slony doesn't enforce that, but assuming
(feel
free to post any benchmarks you collect during your testing of this)
> ___
> Slony1-general mailing list
> Slony1-general@lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
--
Steve
Slony1-general mailing list
> Slony1-general@lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
___
Slony1-general mailing list
Slony1-general@lists.slony.in
lied a few this week).
I'd also encourage people to grab the code from CVS to do some
pre-release testing, though we will tag release candidates before
tagging the actual release.
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
___
On Sat, 3 Apr 2010, Guillaume Lelarge wrote:
>
> Well, the limitation was understandable when PostgreSQL didn't have
> TRUNCATE trigger. Now that it has (8.4 new capacity), it should probably
> get added to Slony.
Slony 2.0.x currently also supports 8.3. Is the thinking that if you
compile agai
On Sun, 4 Apr 2010, Jaime Casanova wrote:
Slony 2.0.x currently also supports 8.3.
what about a 2.1.x version? :)
Putting new features into 2.1.x over 2.0.x might make some sense. Do we
(the community of slony users) want to require 8.4+ for 2.1.x? I think that
is open for discussion. My
Devrim GÜNDÜZ wrote:
> On Thu, 2010-04-01 at 10:30 -0400, Steve Singer wrote:
>> We are planning on tagging and packing some new slony releases in the
>> next little while (early next week maybe?). The plan is for a point
>> release for both 1.2 and 2.0
>
> When i
think it needs
another RC before an actual release.
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
___
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general
We have posted release candidates for
Slony1 1.2.21 rc1
Slony1 2.0.3 rc4
to http://www.slony.info.
See the website for changes in these releases.
Please try them out.
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
On Mon, 5 Apr 2010, Jaime Casanova wrote:
well my main preocupation is to avoid developers to execute truncate,
but maybe the answer is to revoke that privilege in 8.4
You could maybe also accomplish this by installing your own TRUNCATE trigger
that prevents the truncate with an error.
At s
Devrim GÜNDÜZ wrote:
> On Tue, 2010-04-06 at 17:49 -0400, Steve Singer wrote:
>> Slony1 1.2.21 rc1
>
> Another thing:
>
> ./configure : Permission denied
>
> Could you please make it executable before preparing tarball? I know it
> is not executable in CVS..
in the cvs repo on the server? That why future
checkouts/exports will have configure with +x ?
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
___
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general
Source packages for Slony1 1.2.21 and 2.0.3 have been posted in the
download section of the website.
Release notes can be found on the main slony page (http://www.slony.info)
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
is working flawlessly, are you
saying that you always get them?
> Could anyone please help me understand what might be going wrong?
>
> Thanks
> Albert
>
>
>
>
> ___
> Slon
aiting for stuff to replicate?)
select pg_locks.*, pg_class.relname FROM pg_locks, pg_class where
pg_locks.relation=pg_class.oid;
or something similar can show you that.
Do you have any transactions that were started before you subscribed the
set tha
eve
>
> I am using slony version 1.2.20
>
> thanks in advance,
> Brian Fehrle
>
>
> ___
> Slony1-general mailing list
> Slony1-general@lists.slony.info
> http://lists.slony.info/m
.. ideas?
http://bugs.slony.info/bugzilla/show_bug.cgi?id=111 mentions this 'node
-1' error, I tried to reproduce this with the 2.0 branch a while back
but wasn't able to figure out exactly what steps I need to perform to
reproduce
How do people feel about moving the slony source tree to git?
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
___
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general
xactly what the right fix for this bug is. My first gut
> feeling is to ignore the ENABLE_SUBSCRIPTION and generate another
> UNSUBSCRIBE_SET event just to clear out any sl_subscribe row existing in
> the cluster. Since I am in Toronto right now, I can discuss this with
> Steve Singer to
Jaime Casanova wrote:
> On Mon, Apr 26, 2010 at 3:46 PM, Steve Singer wrote:
>
>> I'm inclined to say that 2 is the correct solution. However, if you do
>> a subscribe and your copy set fails (as happened to Jamie) there is no
>> easy way to not subscribe.
>
&
cvsimport) on github at http://github.com/ssinger/slony (The 1.2 and 2.0
branches are included) but there are no automatic syncs between that and
the slony cvs repo.
> Does that repo track all the branches? [Possibly a lazy question! :-)]
> It would seem like a keen idea to have
be the same)
> ___
> Slony1-general mailing list
> Slony1-general@lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
___
it to print the SQL statement that caused the error.
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
___
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general
Joseph S wrote:
> Steve Singer wrote:
>> Joseph S wrote:
>>
>>> I'm not sure how to do that. I think the multiple updates are done in
>>> one statement and I'm not sure how to figure out which one slony is
>>> trying when it gets the error.
&g
lly reproduces this (if one takes the time to look at the
output, which I should have been doing).
However, this only seems to be a problem with 8.4, it works fine when I
run it against 8.3
I have created bug 118
(http://www.slony.info/bugzilla/show_bug.cgi?id=118) to track this
--
St
o's seen the issue)
___
> Slony1-general mailing list
> Slony1-general@lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
___
Slony1-gen
Leon Mergen wrote:
> Hello Steve,
>
> On Fri, Apr 30, 2010 at 5:39 PM, Steve Singer wrote:
>>> I will try to find out what log entry is causing the trouble.
>>>
>> Do the tables that these errors come from typically get large insert/update
>> statements or
plied can be obtained at
http://github.com/ssinger/slony/tarball/REL2_0_PROPOSED_ssinger
Leon Mergen
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
Index: src/slon/remote_worker.c
===
RCS file: /home/cvsd/s
>
> Jan
>
>
>
>
> ___
> Slony1-patches mailing list
> slony1-patc...@lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-patches
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
___
Slo
arwin)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
>
> iD8DBQFL0cRHUu+jZtP2Zf4RAsnSAJ4maF/yIT91PJpthfhIu8vrCNReeACdFJ4m
> R3rBemZQat1rugKfwf+kMqM=
> =7d4U
> -END PGP SIGNATURE-
>
>
> --------
>
> _
On Mon, 3 May 2010, sowjanya v wrote:
> Hi,
How are you getting the error? Is it from the slon process or the slonik
process? If it is from slonik can you send the slonik script your
executing, if it is from slon then can you send the slon command line + conf
file.
Somewhere in one of them y
Jan Wieck wrote:
On 5/1/2010 5:26 PM, Steve Singer wrote:
David Fetter wrote:
Folks,
I think the intention of the patch is to look for a suitable size_t and
fallback to int if none was found.
The patch seemed to address 1 things
1) Support for newer autoconfs, which seems to not break
can replace our direct use of yyleng with calls to yyget_len()
to avoid this issue
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
___
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman
Steve Singer wrote:
David Fetter wrote:
I think I can replace our direct use of yyleng with calls to yyget_len()
to avoid this issue
David, does this patch (in addition to the autoconf changes) get things
working on your version of OSX? I've replaced uses of yyleng with
yyget_len(
On Mon, 10 May 2010, sowjanya v wrote:
> Hi,
>
> I have two databases db1 and db2. db2 is replica of db1. Now i have added a
> column in a table in db1. Since schema changes do not propogate by itself to
> db2, need to execute execute script. But the input for that is a sql file
> with all differ
at must exist.
> Fernando
>
>
>
>
> ___
> Slony1-general mailing list
> Slony1-general@lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
On Wed, 12 May 2010, sowjanya v wrote:
> Hi,
>
> I am not able create replication set for a table not having private key. Is
> there anything that can be done?
If by 'private key' you mean 'primary key' then what you need to do is add a
primary key to your table. It can be a serial datatype tha
be88b8e.60c6 19009LOG:
> could not send data to client: Broken pipe
>
> Looks like it was stuck in prepareTableForCopy function. Replication
> setup succeeded when the operation was repeated. Has anyone seen this
> before? Any ideas about what could cause this?
>
> Regards,
>
On Wed, 12 May 2010, Jaime Casanova wrote:
Hi,
Is it possible to add a node with certain ip (ej: 10.1.0.1) and then
move it to another network with other ip (ej: 10.1.1.1)?
i guess it's simply a matter of fixing the ip in the sl_path, no?
Yes, if you issue a new 'store path' command with the
ninfo = ' dbname=postgres host=172.16.44.142 port=5432
> user=postgres';
> DROP NODE ( ID = 3, EVENT NODE = 1 );
> _EOF_
>
> I am running on a CentOS 5, postgres 8.4.2, and slony 1.2.20 environment
> on all three nodes.
>
> Thanks in advance,
> Brian Fe
h_gurjeet
Mail sent from my BlackLaptop device
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
diff --git a/doc/adminguide/triggers.sgml b/doc/adminguide/triggers.sgml
index a46d5e2..4f8f74f 100644
--- a/doc/adminguide/triggers.sgml
+++ b/doc/adminguide/triggers.sgml
@@ -126,
; singh.gurj...@{ gmail | yahoo }.com
> Twitter/Skype: singh_gurjeet
>
> Mail sent from my BlackLaptop device
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
___
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general
On Tue, 18 May 2010, Ben Chobot wrote:
> Anybody?
>
> On May 12, 2010, at 10:22 AM, Ben Chobot wrote:
>
>> I currently have 5 nodes in my slony 1.2 cluster: A, B, C, D, and E.
>> Nodes A and B take turns being the origin. Node C will always be a
>> subscriber but is also a provider to nodes D an
Trout
> http://www.stuarthamm.net/
> http://www.dellsmartexitin.com/
>
>
>
> ___
> Slony1-general mailing list
> Slony1-general@lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
; That is what got removed and that is what I think we should put back.
I'm inclined to agree, I have opened a bug on this.
http://bugs.slony.info/bugzilla/show_bug.cgi?id=127
Though I'm not sure if we want to change this in 1.2.x or just look into
changing this in 2.0
>
>
&
On Fri, 21 May 2010, Gurjeet Singh wrote:
> This is exactly the kind of Slony black magic I want to understand. Do we
> have someplace where we can get these internals of Slony, or design specs;
> or would you suggest diving into code?
The original design document is available
http://developer.p
On Fri, 21 May 2010, Sam Nelson wrote:
It would be useful to know
1) What version of slony are you using (I'm guessing 1.2.x since other folks
from consistent state have mentioned that)
2) What paths have you created.
'could not connect to server: Connection refused' makes me think that you
On Sun, 23 May 2010, David Fetter wrote:
> Folks,
>
> What exactly is it that might keep someone from deploying 2.0.3, apart
> from features not promised in 2.0x?
See this thread
http://lists.slony.info/pipermail/slony1-general/2010-April/010596.html
(fixed in cvs). Note that this problem isn'
On Sun, 23 May 2010, David Fetter wrote:
> On Sun, May 23, 2010 at 10:30:44AM -0400, Jan Wieck wrote:
>> On 5/23/2010 10:28 AM, David Fetter wrote:
>>
>>> Whatever it is, how can people help get it out sooner?
>>
>> Testing, reporting and/or fixing bugs.
>
> What are the gating issues as you see t
On Mon, 24 May 2010, Brendan Hill wrote:
> Hi all,
>
>
> How can I configure Slony to send some notification - an email, call a URL,
> run a program, flash something red on the screen, anything whatsoever - if
> it encounters a replication problem?
If you write a script/program (in perl,python,ja
On Mon, 24 May 2010, David Fetter wrote:
> Hello,
>
> What's the minimum change needed from 2.0.3? Specifically, is
> replacing the slon binary enough, or does everything need to go?
>From 2.0.3 to what is in cvs today you would want to replace
a) The slon binary for the data corruption bug
b
___
> Slony1-general mailing list
> Slony1-general@lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
___
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general
olution.
>
> wbr / Alexander
> ___
> Slony1-general mailing list
> Slony1-general@lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1
;log_parsing_script"
> SLONY "dbname=$SLAVEDBNAME port=$SLAVEPORT host=$SLAVEHOST
> user=$REPUSER" > /usr/local/pgsql/log/slon.node2.log 2>&1 &
>
> slony version 1.2.20
> master PostgreSQL version 8.4.1
> slave PostgreSQL version 8.4.2
>
>
>
Brian Fehrle wrote:
> Steve Singer wrote:
>> Brian Fehrle wrote:
>>
>> > Hi all,
>>
> All entries between sl_event and sl_confirm match exactly (each
> con_seqno from sl_confirm matches an ev_seqno from sl_event)
It sounds like your cluster is caught up.
aiwan...@instytut.com.pl wrote:
> On Tue, May 25, 2010 at 09:49:19AM -0400, Steve Singer wrote:
>>> segfault at 273936 ip 7f359f4f4c40 sp 7f359b982698 error 4 in
>>> libc-2.9.so[7f359f474000+168000]
>> Can you rub gdb against a core file, or start slony up insid
--
>
> ___
> Slony1-general mailing list
> Slony1-general@lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
__
ssful test reports we can then do an official 2.0.4 release.
http://lists.slony.info/downloads/2.0/source/slony1-2.0.4.rc1.tar.bz2
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
___
Slony1-general mailing list
Slony1-ge
ntry
>> consisting of a reference to the release notes, a description
>> generated out of the release number, and the timestamp
>>
>> The pieces then get assembled into an RSS file.
>>
>
> It seems way better to me. I'm all for automatic maintena
nd downloads/1.2/source
directories on the webserver. It does not appear to be in cvs (but
probably should be in the slony1-www project).
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
___
Slony1-general mailing list
Slony1-genera
om
> Twitter/Skype: singh_gurjeet
>
> Mail sent from my BlackLaptop device
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
___
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general
Gurjeet Singh wrote:
> On Fri, May 28, 2010 at 2:55 PM, Steve Singer One of our customers is looking to deploy this in an almost unattended
> environment, and having memory leaks in Slon will most definitely hurt
> their ability to deploy it with confidence.
>
> I would prefer t
On Mon, 31 May 2010, Scott Marlowe wrote:
> I have a slave db that has a corrupted data store, and it may or may
> not start up and / or run slony commands reliably.
>
> How do I remove it from the cluster? I know of failover commands that
> make a slave take over for a failed master, but I'm not
t;
> Bye
>
> Lorenzo
>
>
>
> --------
>
> ___
> Slony1-general mailing list
> Slony1-general@lists.slony.info
> http://lists.slony.info/mai
Steve Singer wrote:
> Lorenzo Bolzani wrote:
>> Hi all,
>> What I'd like slony to do is to handle missing columns (with defaults if
>> not null), extra columns (ignoring), and for big changes transform data
>> through a custom script.
>>
>> Can this b
en you
swap the schema out to one that only has support for the newer version
of the application.
This sounds like a lot of extra work
> A
>
>
>
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
___
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general
Jan Wieck wrote:
> On 5/28/2010 6:57 PM, Steve Singer wrote:
>>
>> (A version of 2.0.4 RC1 + these changes can be found at
>> http://github.com/ssinger/slony/tree/203_memfixes_UlrichWeber)
>
> Is that the memory leak from not freeing notifications? If so, let's
I have tagged Slony-I 2.0.4 RC2
This is like 2.0.4 RC1 plus the memory leak fixes discussed on the list.
http://lists.slony.info/downloads/2.0/source/slony1-2.0.4.rc2.tar.bz2
It would be nice if people could test it and report back to the list.
--
Steve Singer
Afilias Canada
Data Services
ger | not null
> Indexes:
> "company_zip_updated_pkey" PRIMARY KEY, btree (id)
> "company_zip_updated_company_id_key" UNIQUE, btree (company_id)
> Foreign-key constraints:
> "company_zip_updated_company_id_fkey" FOREIGN KEY (company_id) REFERENCES
> company(id) ON DELETE CASCADE
> "company_zip_updated_zipcode_id_fkey" FOREIGN KEY (zipcode_id) REFERENCES
> zipcode(zip) ON DELETE CASCADE
> Triggers:
> _mc_cluster_logtrigger_161 AFTER INSERT OR DELETE OR UPDATE ON
> company_zip_updated FOR EACH ROW EXECUTE PROCEDURE
> _mc_cluster.logtrigger('_mc_cluster', '161', 'kvv')
>
>
>
> ___
> Slony1-general mailing list
> Slony1-general@lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
___
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general
ny() trigger won't fire)
>
> I goal is to avoid replicating the whole database again.
> Jason
>
> On Jun 1, 2010, at 9:48 AM, Steve Singer wrote:
>
>> Jason Culverhouse wrote:
>>> I have a problem where my replication is hung, I don't really know wh
1-general@lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
___
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general
> should do to fix it?
>
> Regards
>
> Karl
>
>
> --------
>
> ___
> Slony1-general mailing list
> Slony1-general@lists.slony.info
>
Karl Lehenbauer wrote:
> On Thu, Jun 3, 2010 at 7:59 AM, Steve Singer <mailto:ssin...@ca.afilias.info>> wrote:
>
> Does your initial subscribe (the COPY) ever finish? You don't seem
> to say.
>
>
> In a prior message I just said I didn't kn
log rows in the segment that need to be replicated.
>>
>> or
>>
>> 2) transactions that were in progress when the logswitch started are
>> still in progress.
>>
>> In case 2) it is possible that such transaction actually did create new log
>>
/libpthread.so.0
> #7 0x7fcfd5e9cfcd in clone () from /lib/libc.so.6
> #8 0x00000000 in ?? ()
> (gdb)
> ===
>
>
>
>
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
___
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general
Is there anyone out there that is using the slony_logshipper utility
program that is included in the shared distribution.
If so, are you using it in daemon mode or foreground mode? how well do
you find it works in practice? Which version of slony have you been
using it with?
--
Steve
user=slony password=slony
9994 9023 0.0 0.0 196016 1452 pts/0Sl Jun09 0:03 \_
/usr/local/pgsql84/bin/slon -d4 disorder_replica dbname=test2
host=localhost user=slony password=slony
x86_64 will tend to give a bit bigger memory footprint due to the larger
pointer size. I am wond
-Ubuntu SMP Thu Jan 28 02:39:34 UTC
2010 x86_64 GNU/Linux
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
___
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general
status: creating Makefile.global
config.status: WARNING: 'Makefile.global.in' seems to ignore the
--datarootdir setting
config.status: creating GNUmakefile
config.status: creating slony1.spec
config.status: creating Makefile.port
config.status: creating config.h
> 10.06.2
ny1-general@lists.slony.info <mailto:Slony1-general@lists.slony.info>
> http://lists.slony.info/mailman/listinfo/slony1-general
>
>
>
>
> --
> HeCSa
>
>
>
>
> _______
e the million individual SQL
statements that will be otherwise performed.
> HeCSa.
>
>
>
>
> >
> > On Mon, Jun 14, 2010 at 6:01 PM, Steve Singer
> > mailto:ssin...@ca.afilias.info>> wrote:
> > Hernan
be a good time to let us know.
--
Steve Singer
Afilias Canada
Data Services Developer
416-673-1142
___
Slony1-general mailing list
Slony1-general@lists.slony.info
http://lists.slony.info/mailman/listinfo/slony1-general
1 - 100 of 638 matches
Mail list logo