Re: [Slony1-general] Execute script and execute only on

2007-03-17 Thread Steve Singer
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

Re: [Slony1-general] Execute script and execute only on

2007-03-17 Thread Steve Singer
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 making changes

Re: [Slony1-general] Problem with 1.2.8 and EXECUTE SCRIPT with multiple sets

2007-03-28 Thread Steve Singer
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

Re: [Slony1-general] Tutorial HeartBeat + slony

2007-06-07 Thread Steve Singer
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

Re: [Slony1-general] Soliciting ideas for v2.0

2007-07-03 Thread Steve Singer
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

Re: [Slony1-general] Abandoning Slony (was: drop-set/create-set, causes node -1 not found)

2008-04-05 Thread Steve Singer
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 how

Re: [Slony1-general] Already populated new subscriber node

2010-03-05 Thread Steve Singer
/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

Re: [Slony1-general] Slony1-2.0.2 and PostgreSQL 9.0alpha4

2010-03-12 Thread Steve Singer
://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

Re: [Slony1-general] A reality check

2010-03-21 Thread Steve Singer
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

Re: [Slony1-general] defining sets

2010-03-22 Thread Steve Singer
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 foreign keys that cross set boundaries. Steve -- Steve Singer Afilias Canada Data Services Developer

Re: [Slony1-general] [slony1-general] initial copy incomplete when using 2.0.3rc2

2010-03-22 Thread Steve Singer
n_tup_upd| 0 n_tup_del| 0 n_tup_hot_upd| 0 n_live_tup | 0 n_dead_tup | 0 last_vacuum | 2010-03-20 22:59:38.858321-05 last_autovacuum | last_analyze | 2010-03-20 22:59:38.858321-05 last_autoanalyze | 2010-03-20 13:24:02.694223-05 -- Steve Singer

Re: [Slony1-general] Diagnosing a possible problem with replication

2010-03-22 Thread Steve Singer
___ 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

Re: [Slony1-general] defining sets

2010-03-23 Thread Steve Singer
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 I don't try so hard to shoot

Re: [Slony1-general] -t and -s slon flags

2010-04-01 Thread Steve Singer
@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

[Slony1-general] Upcoming slony releases

2010-04-01 Thread Steve Singer
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 ___ Slony1

Re: [Slony1-general] truncating a table that is in a set

2010-04-04 Thread Steve Singer
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 against

Re: [Slony1-general] truncating a table that is in a set

2010-04-05 Thread Steve Singer
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.

Re: [Slony1-general] [Slony1-hackers] Upcoming slony releases

2010-04-06 Thread Steve Singer
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 is this scheduled exactly? I am

Re: [Slony1-general] [Slony1-hackers] Upcoming slony releases

2010-04-06 Thread Steve Singer
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

[Slony1-general] Slony 1.2.21 rc1 + 2.0.3 rc4 released

2010-04-06 Thread Steve Singer
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

Re: [Slony1-general] truncating a table that is in a set

2010-04-06 Thread Steve Singer
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

Re: [Slony1-general] Slony 1.2.21 rc1 + 2.0.3 rc4 released

2010-04-08 Thread Steve Singer
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... We'll try to remember to +x configure

Re: [Slony1-general] Slony 1.2.21 rc1 + 2.0.3 rc4 released

2010-04-09 Thread Steve Singer
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

[Slony1-general] Slony1 1.2.21 2.0.3 released

2010-04-09 Thread Steve Singer
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

Re: [Slony1-general] recreating a cluster when the master dies

2010-04-16 Thread Steve Singer
___ 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

Re: [Slony1-general] recreating a cluster when the master dies

2010-04-18 Thread Steve Singer
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 that haven't committed yet? -- Steve Singer Afilias Canada Data Services Developer 416-673-1142 ___ Slony1

Re: [Slony1-general] [slony-general] error adding a table

2010-04-21 Thread Steve Singer
, with the data in the sl_* tables) and somehow send it to us off-list we wouldn't mind taking a look at it. -- Steve Singer Afilias Canada Data Services Developer 416-673-1142 ___ Slony1-general mailing list Slony1-general@lists.slony.info http

[Slony1-general] git ?

2010-04-23 Thread Steve Singer
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

Re: [Slony1-general] [slony-general] error adding a table

2010-04-26 Thread Steve Singer
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 tomorrow morning. The approaches that come to mind are: 1) When slon

Re: [Slony1-general] [slony-general] error adding a table

2010-04-26 Thread Steve Singer
Jaime Casanova wrote: On Mon, Apr 26, 2010 at 3:46 PM, Steve Singer ssin...@ca.afilias.info 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. why is that? Say

Re: [Slony1-general] git ?

2010-04-27 Thread Steve Singer
idea to have a repo or two up, and track them for a while, before deciding to change anything. -- Steve Singer Afilias Canada Data Services Developer 416-673-1142 ___ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info

Re: [Slony1-general] encoding problems

2010-04-28 Thread Steve Singer
@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

Re: [Slony1-general] encoding problems

2010-04-28 Thread Steve Singer
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

Re: [Slony1-general] encoding problems

2010-04-29 Thread Steve Singer
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. Can you find this out from the postgresql log on the replica? You

Re: [Slony1-general] [slony1-general] initial copy incomplete when using 2.0.3rc2

2010-04-29 Thread Steve Singer
, 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 -- Steve Singer Afilias Canada Data Services Developer 416-673-1142 ___ Slony1-general mailing list Slony1-general

Re: [Slony1-general] encoding problems

2010-04-30 Thread Steve Singer
Leon Mergen wrote: Hello Steve, On Fri, Apr 30, 2010 at 5:39 PM, Steve Singer ssin...@ca.afilias.info 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 small ones

Re: [Slony1-general] encoding problems

2010-04-30 Thread Steve Singer
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/slony1

Re: [Slony1-general] Need Help very urgent.ERROR: Slony-I: Node is uninitialized - cluster _sql_cluster2

2010-05-03 Thread Steve Singer
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

Re: [Slony1-general] [rangerr...@befunk.com: slony patch for osx]

2010-05-05 Thread Steve Singer
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/listinfo/slony1-general

Re: [Slony1-general] [Slony1-patches] [rangerr...@befunk.com: slony patch for osx]

2010-05-05 Thread Steve Singer
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

Re: [Slony1-general] Need Urgent Help

2010-05-10 Thread Steve Singer
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 difference

Re: [Slony1-general] how run test_slony_state on windows

2010-05-11 Thread Steve Singer
___ 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

Re: [Slony1-general] unable to create replication set for a table not having private key

2010-05-12 Thread Steve Singer
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 that

Re: [Slony1-general] Replication subscriber setup failure

2010-05-12 Thread Steve Singer
the operation was repeated. Has anyone seen this before? Any ideas about what could cause this? Regards, Venkat ___ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general -- Steve

Re: [Slony1-general] [slony-general] changing ip of a node

2010-05-12 Thread Steve Singer
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

Re: [Slony1-general] Slony triggers included in pg_dump

2010-05-17 Thread Steve Singer
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

Re: [Slony1-general] [Slony1-bugs] An old event not confirmed: A possible bug?

2010-05-22 Thread Steve Singer
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

Re: [Slony1-general] Failover with more than two nodes

2010-05-22 Thread Steve Singer
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

Re: [Slony1-general] Slony 2.0.3 caveats?

2010-05-23 Thread Steve Singer
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't

Re: [Slony1-general] Sending notification on replication problem

2010-05-24 Thread Steve Singer
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,java

Re: [Slony1-general] [Slony1-bugs] Slony triggers included in pg_dump

2010-05-25 Thread Steve Singer
/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

Re: [Slony1-general] child terminated status: 11 - restart of worker in 10 seconds

2010-05-25 Thread Steve Singer
@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

Re: [Slony1-general] Table not replicating, but no errors reported by slony.

2010-05-25 Thread Steve Singer
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. On both the master and the slave, there are zero

Re: [Slony1-general] child terminated status: 11 - restart of worker in 10 seconds

2010-05-26 Thread Steve Singer
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 inside of gdb, so we can get a stack

[Slony1-general] 2.0.4 RC1

2010-05-28 Thread Steve Singer
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-general

Re: [Slony1-general] Having a version.rss would be great

2010-05-28 Thread Steve Singer
, 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 maintenance of this kind :) Any volunteers to write this makefile/script? -- Steve Singer Afilias Canada Data Services

Re: [Slony1-general] Having a version.rss would be great

2010-05-28 Thread Steve Singer
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-general@lists.slony.info http

Re: [Slony1-general] 2.0.4 RC1

2010-05-28 Thread Steve Singer
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

Re: [Slony1-general] corrupted slave

2010-05-31 Thread Steve Singer
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

Re: [Slony1-general] Slony with different schemas

2010-05-31 Thread Steve Singer
://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

Re: [Slony1-general] Slony with different schemas

2010-05-31 Thread Steve Singer
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 be achieved? I think so, if your careful about

Re: [Slony1-general] 2.0.4 RC1

2010-06-01 Thread Steve Singer
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 test it with bombarding a slon

[Slony1-general] 2.0.4 RC2

2010-06-01 Thread Steve Singer
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

Re: [Slony1-general] Replication Hung

2010-06-01 Thread Steve Singer
') ___ 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

Re: [Slony1-general] Replication Hung

2010-06-01 Thread Steve Singer
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 where to start This table is in set 38, most everything is in set 1, it looks like set 38 isn't caught up

Re: [Slony1-general] Known issues with Slony-I 2.0.3

2010-06-03 Thread Steve Singer
!! With regards, Vivek Gupta ___ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general -- Steve Singer Afilias

Re: [Slony1-general] getting log switch to sl_log_2 still in progress - tried everything

2010-06-03 Thread Steve Singer
://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

Re: [Slony1-general] getting log switch to sl_log_2 still in progress - tried everything

2010-06-03 Thread Steve Singer
Karl Lehenbauer wrote: On Thu, Jun 3, 2010 at 7:59 AM, Steve Singer ssin...@ca.afilias.info 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 know if it was finishing

Re: [Slony1-general] getting log switch to sl_log_2 still in progress - tried everything

2010-06-03 Thread Steve Singer
of course will need to be replicated. Jan -- Anyone who trades liberty for security deserves neither liberty nor security. -- Benjamin Franklin -- Steve Singer Afilias Canada Data Services Developer 416-673-1142 ___ Slony1-general mailing

[Slony1-general] slony_logshipper utility

2010-06-08 Thread Steve Singer
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

Re: [Slony1-general] huge virtual memory size of slony1 proccess

2010-06-10 Thread Steve Singer
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 wondering if the 4GB your seeing is somehow vps related. 10.06.2010 10:32, Alexander V Openkin пишет: -- Steve Singer Afilias Canada Data Services

Re: [Slony1-general] huge virtual memory size of slony1 proccess

2010-06-10 Thread Steve Singer
Alexander V Openkin wrote: Can you do the same test on a x86_64 server that isn't vps? yes, i'll test it tomorrow, show me please *uname -a * from your laptop uname -a Linux ssinger 2.6.31-19-generic #56-Ubuntu SMP Thu Jan 28 02:39:34 UTC 2010 x86_64 GNU/Linux -- Steve Singer

Re: [Slony1-general] huge virtual memory size of slony1 proccess

2010-06-10 Thread Steve Singer
: '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.2010 17:40, Steve Singer пишет: Alexander V Openkin wrote: Can you do the same

Re: [Slony1-general] Huge lagging time

2010-06-14 Thread Steve Singer
___ 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

Re: [Slony1-general] Huge lagging time

2010-06-15 Thread Steve Singer
performed. HeCSa. On Mon, Jun 14, 2010 at 6:01 PM, Steve Singer ssin...@ca.afilias.info mailto:ssin...@ca.afilias.info wrote: Hernan Saltiel wrote: How can I meassure how much is too much use of my

[Slony1-general] 2.0.4 release?

2010-06-16 Thread Steve Singer
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

Re: [Slony1-general] 2.0.4 RC2

2010-06-17 Thread Steve Singer
Joseph S wrote: Should I blow away my old slave database and rereplicate from scratch? Or can I just upgrade slony and start it up? Steve Singer wrote: 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

Re: [Slony1-general] High memory usage in 'Slon' process

2010-06-17 Thread Steve Singer
? ___ 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

Re: [Slony1-general] 2.0.4 RC2

2010-06-17 Thread Steve Singer
those files in the next tarfile (technically this means we should have a rc3 but I'd like to see what else people find) Thanks There is a scan.c under src/slonik/ Steve Singer wrote: Joseph S wrote: Should I blow away my old slave database and rereplicate from scratch? Or can I just

Re: [Slony1-general] 2.0.4 RC2

2010-06-17 Thread Steve Singer
connection How can I break it out of this loop? Steve Singer wrote: Joseph S wrote: I can't compile 2.0.4 rc2 make[2]: *** [scan.o] Error 1 make[2]: Leaving directory `/local/download/src/slony1-2.0.4.rc2/src/slony_logshipper' make[1]: *** [all] Error 2 make[1]: Leaving directory `/local

Re: [Slony1-general] High memory usage in 'Slon' process

2010-06-18 Thread Steve Singer
/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

Re: [Slony1-general] Reasons to upgrade to Slony 2.0

2010-06-18 Thread Steve Singer
a pg_dump from a replica -OMIT COPY and CLONE NODE allow you to populate your replicas through non slony means (ie pg_dump) -- Steve Singer Afilias Canada Data Services Developer 416-673-1142 ___ Slony1-general mailing list Slony1-general

Re: [Slony1-general] Replication time with 2.0.4rc2

2010-06-18 Thread Steve Singer
___ 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

Re: [Slony1-general] [slony-general] dropping a table from a set

2010-06-19 Thread Steve Singer
On Sat, 19 Jun 2010, Jaime Casanova wrote: Hi, Someone drop a FK constraint without using slonik (in slony1 1.2.20) and inserted some rows in that table... some of those rows violate the dropped constraint and obviously the replica can't insert the data because in the replica the constraint

Re: [Slony1-general] Does Slony 1 support PostgreSQL 8.4?

2010-06-22 Thread Steve Singer
fine, but I don't want to deploy an unsupported configuration.) Sincerely, Aleksey ___ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general -- Steve Singer Afilias Canada Data

Re: [Slony1-general] trouble building slony1 1.2.21 for EnterpriseDB Postgres 8.4.2

2010-06-23 Thread Steve Singer
, -at ___ 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

Re: [Slony1-general] trouble building slony1 1.2.21 for EnterpriseDB Postgres 8.4.2

2010-06-23 Thread Steve Singer
Steve Singer wrote: Aleksey Tsalolikhin wrote: Find the exact error your getting in config.log If I Download the EDB installer on and try to build slony against it I get the following: configure:5192: gcc -o conftest -g -O2 -L/opt/PostgreSQL/8.4/lib/ conftest.c -lpq 5 /usr/bin

[Slony1-general] Slony-I 2.0.4 released

2010-06-24 Thread Steve Singer
issues with large rows (introduced in 2.0.3) * Fixed syntax script error (Bug # 108) * Various documentation updates * Supports newer versions of flex * Fixes for CLONE NODE FINISH (Bug # 119) -- Steve Singer Afilias Canada Data Services Developer 416-673-1142

Re: [Slony1-general] Performance issues with slony-2.0.4.rc2

2010-06-28 Thread Steve Singer
Ian Lea wrote: Use the released version of 2.0.4. I don't know if anything changed or not, but always best to use released versions where possible. The only changes between 2.0.4rc2 and 2.0.4 where documentation and packaging related (no code changes). -- Steve Singer Afilias Canada Data

Re: [Slony1-general] Upgrade Question

2010-07-06 Thread Steve Singer
. (The perl script should loop through each of the nodes in your .conf file and update them). Thanks and kind regards Frank Jansen -- Steve Singer Afilias Canada Data Services Developer 416-673-1142 ___ Slony1-general mailing list Slony1-general

Re: [Slony1-general] Drop column issue using Slonik_execute_script

2010-07-07 Thread Steve Singer
-- 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] slony + win32

2010-07-08 Thread Steve Singer
Has anyone compiled a recent version of slony on win32? Do we still compile against win32? If so with what compiler? I have no way of testing if we build against win32 but I'm hoping someone else has periodically been doing this. -- Steve Singer Afilias Canada Data Services Developer 416

Re: [Slony1-general] Updating huge table in Slony-I

2010-07-10 Thread Steve Singer
On Fri, 9 Jul 2010, Waldo Nell wrote: I need to run an update statement pretty much like: update XXX set Y = 'Y' where Z = 1; but table XXX contains approximately 130 million rows. This will translate to 130 million update statements via Slony-I to the other replicated node. Any more

Re: [Slony1-general] autovacuum cannot vacuum sl_event

2010-07-13 Thread Steve Singer
/ ___ 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

Re: [Slony1-general] Hurray, there's a git repository!

2010-07-15 Thread Steve Singer
Christopher Browne wrote: http://git.postgresql.org/gitweb?p=slony1-engine.git;a=summary It's empty, at the moment. Steve Singer has been working on a fresh repository to push into it based on a recent copy of CVS, so hopefully the repo will be a little bit less empty quite soon. The git

[Slony1-general] SCM: commit messages

2010-07-16 Thread Steve Singer
://git.postgresql.org/gitweb?p=slony1-engine.git;a=rss and use their own RSS readers or RSS to email gateways for notifications. Thoughts? I'm leaning towards 2. -- Steve Singer Afilias Canada Data Services Developer 416-673-1142 ___ Slony1-general mailing list

Re: [Slony1-general] having trouble building slony on ubuntu 10.04 with pgsql 8.3.8

2010-07-21 Thread Steve Singer
. I think I'll just try source compiling both pgsql and slony1 -- 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

Re: [Slony1-general] having trouble building slony on ubuntu 10.04 with pgsql 8.3.8

2010-07-21 Thread Steve Singer
the same. -- 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

Re: [Slony1-general] having trouble building slony on ubuntu 10.04 with pgsql 8.3.8

2010-07-21 Thread Steve Singer
Scott Marlowe wrote: On Wed, Jul 21, 2010 at 12:04 PM, Steve Singer ssin...@ca.afilias.info wrote: Scott Marlowe wrote: Note that this is with Ubuntu 10.04 with the karmic repo enabled to get pgsql 8.3 from there. Do you have the postgresql-server-dev-8.3 package installed? The ubuntu 9.x

Re: [Slony1-general] having trouble building slony on ubuntu 10.04 with pgsql 8.3.8

2010-07-22 Thread Steve Singer
-version installations is broken. It seems to put the 8.4 files in include/postgresql but the 8.3 files (minus the libpq headers) in include/postgresql/8.3 On Wed, Jul 21, 2010 at 12:04 PM, Steve Singer ssin...@ca.afilias.info wrote: Scott Marlowe wrote: Note that this is with Ubuntu

  1   2   3   4   5   6   >