http://blog.gmane.org/gmane.comp.db.postgresql.slony1.general hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://comments.gmane.org/gmane.comp.db.postgresql.slony1.general/10722 <pre>The slony.info website will be taken offline for maintenance on: Wednesday, May 23 starting at 7:30pm * The website - www.slony.info * The slony bugzilla instance * All slony mailing lists will be offline, this is expected to last a few hours. Thanks </pre> Steve Singer 2012-05-22T21:23:59 http://comments.gmane.org/gmane.comp.db.postgresql.slony1.general/10717 <pre>Is it possible/feasible to use the Slony-I Creation scripts designed for use in pgAdmin III outside of pgAdmin III? I need to write a utility to make it easier for our installers to setup Slony-I and I'd like to use the official scripts to do it but I'm unsure how to go about it right now. Shaun McCloud, MCDST | Associate Software Developer Geo-Comm Inc. | www.geo-comm.com&lt;http://www.geo-comm.com/&gt; 601 W. Saint Germain St., St. Cloud, MN, 56301 Office: 320.240.0040 or 888.436.2666 Fax: 320.240.2389 _______________________________________________ Slony1-general mailing list Slony1-general-8kkgcvHRObyz5F2/bZa4Fw&lt; at &gt;public.gmane.org http://lists.slony.info/mailman/listinfo/slony1-general </pre> Shaun McCloud 2012-05-22T15:36:13 http://comments.gmane.org/gmane.comp.db.postgresql.slony1.general/10712 <pre>I wrote an upstart script for starting slony on ubuntu 10.04+. If there's any interest in including it in the slony distro, you can find it here: https://github.com/pgexperts/upstart-scripts/blob/master/etc/init/slony.conf </pre> Jeff Frost 2012-05-15T21:52:44 http://comments.gmane.org/gmane.comp.db.postgresql.slony1.general/10711 <pre>Not sure what I'm missing but I get this error when I try to run the slony config. I'm running this at postgres. I ran the config earlier this week and we had to stop slony. Try to run it today but fails $ ./slony-conf.sh &lt;stdin&gt;:21: PGRES_FATAL_ERROR load '$libdir/slony1_funcs'; - ERROR: could not access file "$libdir/slony1_funcs": No such file or directory &lt;stdin&gt;:21: Error: the extension for the Slony-I C functions cannot be loaded in database 'dbname=canvas_db host=harv user=postgres' It all looks correct but can't find slony1_funcs when running conf $ find /opt/postgres -name slony1_funcs.so /opt/postgres/9.0.3-pgdg/lib/slony1_funcs.so $ pg_config --libdir /opt/postgres/9.0.3-pgdg/lib $ pg_config --pkglibdir /opt/postgres/9.0.3-pgdg/lib $ ll /opt/postgres/9.0.3-pgdg/lib/slony1_funcs.so -rwxr-xr-x 1 postgres postgres 39K Apr 9 14:28 /opt/postgres/9.0.3-pgdg/lib/slony1_funcs.so 0___ Wolfgang Schwurack c/ /'_ SA/DBA - UEN (*) \(*) 801-587-9444 wol</pre> Wolf Schwurack 2012-05-12T01:42:38 http://comments.gmane.org/gmane.comp.db.postgresql.slony1.general/10699 <pre>Hey all! I successfully setup my first slony replication - however quite a few conceptual questions raised on the way: I have the following setup (taken from slon_tools.conf): add_node(node =&gt; 1, host =&gt; 'master.foo', dbname =&gt; 'foo', port =&gt; 5432, user =&gt; 'slony', password =&gt; 'XXX'); add_node(node =&gt; 11, host =&gt; 'slave1.foo', dbname =&gt; 'foo', port =&gt; 6254, user =&gt; 'slony', password =&gt; 'XXX'); add_node(node =&gt; 12, host =&gt; 'slave2.foo', dbname =&gt; 'foo', port =&gt; 2254, user =&gt; 'slony', password =&gt; 'XXX'); This config got deployed on every node, every pg_hba.conf-file contained a line which allowed all other servers to connect as user slony. Everything was working - until I tried to optimize. I thought, well, there needs to be a connection between the master and the slaves but no direct connection between the slaves - </pre> Mirko Vogt 2012-04-24T14:40:08 http://comments.gmane.org/gmane.comp.db.postgresql.slony1.general/10697 <pre>I am getting this error..i dont know where to change..can anyone say.. &lt;stdin&gt;:8: loading of file /usr/local/pgsql/share//slony1_funcs.sql: PGRES_FATAL_ERROR ERROR: Slonik version: 2.0.6 != Slony-I version in PG build 2.1.1 ERROR: Slonik version: 2.0.6 != Slony-I version in PG build 2.1.1 _______________________________________________ Slony1-general mailing list Slony1-general-8kkgcvHRObyz5F2/bZa4Fw&lt; at &gt;public.gmane.org http://lists.slony.info/mailman/listinfo/slony1-general </pre> Lakshmi Priya 2012-04-12T10:39:38 http://comments.gmane.org/gmane.comp.db.postgresql.slony1.general/10696 <pre>When i specify UPDATE FUNCTIONS ( ID = 3 # Update functions on node 3 ); I am getting event node error,even i specified event node as 2 or 3. Event node function will not work in update node. Can anyone help me.. _______________________________________________ Slony1-general mailing list Slony1-general-8kkgcvHRObyz5F2/bZa4Fw&lt; at &gt;public.gmane.org http://lists.slony.info/mailman/listinfo/slony1-general </pre> Lakshmi Priya 2012-04-12T06:11:10 http://comments.gmane.org/gmane.comp.db.postgresql.slony1.general/10694 <pre>Hi, I've recently come across a situation where slony logshipping files were being written incorrectly. Normally, the files are written in this order: - Begin transaction - Set archive tracking index - INSERTs/UPDATEs/DELETEs - Set sequences - Vacuum - Commit I noticed that in my particular instance, the files were being written as such: - Begin transaction - Set archive tracking index - Vacuum - Commit - INSERTs/UPDATEs/DELETEs - Set sequences Obviously, this sounds pretty dangerous, and I actually encountered the situation where my logship destination got corrupted, and needed to rebuild that node. Would anyone have any insight into why this happens? Using 2.0.6 on CentOS, with Postgres 8.4.5 Thanks! --Richard _______________________________________________ Slony1-general mailing list Slony1-general-8kkgcvHRObyz5F2/bZa4Fw&lt; at &gt;public.gmane.org http://lists.slony.info/mailman/listinfo/slony1-general </pre> Richard Yen 2012-04-11T13:24:37 http://comments.gmane.org/gmane.comp.db.postgresql.slony1.general/10688 <pre>Can any one say what this error meant..?? &lt;stdin&gt;:8: loading of file /usr/local/pgsql/share//slony1_funcs.sql: PGRES_FATAL_ERROR ERROR: Slonik version: 2.0.6 != Slony-I version in PG build 2.1.1. _______________________________________________ Slony1-general mailing list Slony1-general-8kkgcvHRObyz5F2/bZa4Fw&lt; at &gt;public.gmane.org http://lists.slony.info/mailman/listinfo/slony1-general </pre> Lakshmi Priya 2012-04-11T07:24:46 http://comments.gmane.org/gmane.comp.db.postgresql.slony1.general/10685 <pre> If I am replicating from one database to another, can I delete rows from the slave database and not have Slony re-populate those rows (provided the rows in the master database have not been updated)? </pre> NewToSlony 2012-04-11T03:59:20 http://comments.gmane.org/gmane.comp.db.postgresql.slony1.general/10683 <pre>How do you change the cleanup_interval option on a Windows cluster? I have tried adding it to the engine file and that doesn't change anything and everything I've found online shows how to do it in a *NIX cluster, not a Windows one. Shaun McCloud - Associate Software Developer Geo-Comm, Inc 601 W. Saint Germain St., Saint Cloud, MN 56301 Office: 320.240.0040 Fax: 320.240.2389 Toll Free: 888.436.2666 click here to visit www.geo-comm.com&lt;http://www.geo-comm.com/&gt; [cid:image001.jpg-6jK/KXen6uTyw+Oj8IRwQDRmByFHzeGd&lt; at &gt;public.gmane.org]&lt;http://www.linkedin.com/companies/geocomm&gt; [cid:image002.jpg-6jK/KXen6uTyw+Oj8IRwQDRmByFHzeGd&lt; at &gt;public.gmane.org] &lt;http://twitter.com/_geocomm&gt; P Think before you print! Microsoft Certified Desktop Support Technician (MCDST) _______________________________________________ Slony1-general mailing list Slony1-general-8kkgcvHRObyz5F2/bZa4Fw&lt; at &gt;public.gmane.org http://lists.slony.info/mailman/listinfo/slony1-general </pre> Shaun McCloud 2012-04-10T20:49:30 http://comments.gmane.org/gmane.comp.db.postgresql.slony1.general/10681 <pre>Yesterday I set up a DB to replicate. It was previously set up with slony 1.2 but the backup server died, so I took the opportunity to move to 2.1. I did the dropnode and uninstallnode to clean up the master. I followed my normal, init, create set, subscribe sequence that has always worked. I had done the same thing about a week ago with the other DB on this same server pair. When I left work yesterday, it was dutifully copying the DB. This morning I went to check and the master has not generated an event since 2012-04-10 05:35:49.782917-04. The sl_status on the master shows this: -[ RECORD 1 ]-------------+------------------------------ st_origin | 20 st_received | 31 st_last_event | 5000008023 st_last_event_ts | 2012-04-10 05:35:49.782917-04 st_last_received | 5000008023 st_last_received_ts | 2012-04-10 05:35:50.00566-04 st_last_received_event_ts | 2012-04-10 05:35:49.782917-04 st_lag_num_events | 0 st_lag_time </pre> Vick Khera 2012-04-10T14:24:15 http://comments.gmane.org/gmane.comp.db.postgresql.slony1.general/10672 <pre>Hello, I'm wondering if its possible to query any of the databases in my cluster to see when Slony is done replicating changes to a single node. I was going to use the Acks Outstanding statistic but then realized that the slave nodes that my controller service is waiting to update (and do not have Slony running on) will keep adding to that count. If there is no statistic to query, is my assumption that tables are replicated in the order they are added to the replication set correct? As for why I can't just let the changes replicate to all slaves at once, it is because of a no single point of failure for the web app that is reading the replicated data. Shaun McCloud - Associate Software Developer Geo-Comm, Inc 601 W. Saint Germain St., Saint Cloud, MN 56301 Office: 320.240.0040 Fax: 320.240.2389 Toll Free: 888.436.2666 click here to visit www.geo-comm.com&lt;http://www.geo-comm.com/&gt; [cid:image001.jpg-HfuTfBXPlMx1/i14CW9yTzRmByFHzeGd&lt; at &gt;public.gmane.org]&lt;http://www.linkedin.com/companies/geocomm&gt; [cid:image002</pre> Shaun McCloud 2012-04-03T17:51:58 http://comments.gmane.org/gmane.comp.db.postgresql.slony1.general/10668 <pre>Can someone fix the manual for clone finish: http://main.slony.info/documentation/stmtclonefinish.html The synopsis is still using "Clone prepare" instead of "Clone finish"_______________________________________________ Slony1-general mailing list Slony1-general-8kkgcvHRObyz5F2/bZa4Fw&lt; at &gt;public.gmane.org http://lists.slony.info/mailman/listinfo/slony1-general </pre> Brian Trudal 2012-03-30T02:44:36 http://comments.gmane.org/gmane.comp.db.postgresql.slony1.general/10667 <pre>I have been trying to compile slony1-2.1.1 on solaris 10 but fails. I got this error on make: "gcc: unrecognized option `-pthread'" So I removed the -pthread from the configure file Now getting: misc.c: In function `slon_log': misc.c:183: warning: int format, pid_t arg )arg 3) misc.c: In function `slon_scanint64' misc.c 268 warning: integer constant is too large for "long" type OS = Solaris 10 slony = slony1-2.1.1 GCC = 3.4.6 Postgres = 9.1.2 0___ Wolfgang Schwurack c/ /'_ SA/DBA - UEN (*) \(*) 801-587-9444 wolf-OzwJb8Xg5oY&lt; at &gt;public.gmane.org </pre> Wolf Schwurack 2012-03-29T15:42:33 http://comments.gmane.org/gmane.comp.db.postgresql.slony1.general/10666 <pre>Hi there I couldn't get much info from docs; can someone explain what CLONE PREPARE does ? Essentially I wanted to clone a subscriber1 to new subscriber3; but wanted to confirm; after the clone prepare; does the first subscriber1 will stop replicating from origin or it will continue to replicate ? What happens to other subscribers in the origin node if there are more than one subscribers already ? Also, do we need to skip the dumping of slony schema (_{clustername}) during the dump + restore while cloning new subscriber ? -- brian _______________________________________________ Slony1-general mailing list Slony1-general-8kkgcvHRObyz5F2/bZa4Fw&lt; at &gt;public.gmane.org http://lists.slony.info/mailman/listinfo/slony1-general </pre> Brian Trudal 2012-03-27T20:48:14 http://comments.gmane.org/gmane.comp.db.postgresql.slony1.general/10664 <pre>(I am sending this to both the PostGIS and Slony support lists as I am not sure of the correct location). I have run into a problem with how PostGIS and Slony are reacting with each other. Let me say upfront, I am a PostGIS newbee and know just about nothing about Slony. And I know this email is long, but I want to make sure I included everything. This is on a Posgtres 8.3.1, PostGIS 1.3, and Slony 1.2.20 I created a PostGIS table like this: create table b_temp as select 11459815 as msg_no, 0 as rev_no, GeometryFromText('POLYGON((1 1, 2 2, 3 3, 1 1))') as geom1, GeometryFromText('POLYGON((1 1, 2 2, 3 3, 3 3, 1 1))') as geom2; Notice that geom2 has a repeated point of geom1, but other than that they are the same: select geom1 = geom2, ST_Equals(geom1, geom2), ST_OrderingEquals(geom1, geom2) from b_temp; ?column? | st_equals | st_orderingequals ----------+-----------+------------------- t | t | f I then slon'd this table to another node, but didn't start slony on the other </pre> Brian Peschel 2012-03-27T11:59:26 http://comments.gmane.org/gmane.comp.db.postgresql.slony1.general/10659 <pre>Hi there We have 3 nodes in cluster. After moving a set from one node (node-1) to another (node-2), whats the best way to reset the origin in another subscriber (node-3) as it still talking to node-1 as node-1 is doing forward of node-2 changes to node-3 ; rather I want node-3 directly talk to node-2 (new origin) without sub_forward by node-1. The sl_subscribe looks like this: engine_db=# select * from sl_subscribe where sub_set=1;  sub_set | sub_provider | sub_receiver | sub_forward | sub_active ---------+--------------+--------------+-------------+------------        1 |            1 |            3 | f           | t        1 |            2 |            1 | t           | t (3 rows) Rather, after moveset, I expected, line 1 to go away and line-2 to have direct replication to 3 instead of forward through 1. Thanks for help Brian _______________________________________________ Slony1-general mailing list Slony1-general-8kkgcvH</pre> Brian Trudal 2012-03-19T21:04:36 http://comments.gmane.org/gmane.comp.db.postgresql.slony1.general/10651 <pre>Hello, We are Master students from Cologne University of Applied Sciences Germany. We are building a prototype for a biogas plant and we are having some problems implementing the structure We want do a Master-Slave replication between ubuntu(Master) and windows(Slave) in PostgreSQL 9.1 using Slony2.1. we have problems in installing slony 2.1 in windows. We have downloaded the source files. unlike previous versions slony 2.1 doesn't have a .exe file. So can you help us with the steps to install slony 2.1 in windows xp. We are looking forward for your support. Thanks &amp; Regards Esli _______________________________________________ Slony1-general mailing list Slony1-general-8kkgcvHRObyz5F2/bZa4Fw&lt; at &gt;public.gmane.org http://lists.slony.info/mailman/listinfo/slony1-general </pre> ESLI george 2012-03-19T12:04:04 http://comments.gmane.org/gmane.comp.db.postgresql.slony1.general/10646 <pre>Hello, We are Master students from Cologne University of Applied Sciences Germany. We are building a prototype for a biogas plant and we are having some problems implementing the structure We want do a Master-Slave replication between ubuntu(Master) and windows(Slave) in PostgreSQL 9.1 using Slony2.1. we have problems in installing slony 2.1 in ubuntu. The problem is after configuring(./configure) and then compiling using command 'make' the file in slony1-2.1.1/src/backend/slony1_funcs.c. The header file Miscadmin.h is not found and most of the header files(nodes/makefuncs.h, etc.,) are not found. We have attached the screenshot of the error for Miscadmin.h. We need to know where we can find these header files and what is the problem in it. We are looking forward for your support. Thanks &amp; Regards Esli _______________________________________________ Slony1-general mailing list Slony1-general-8kkgcvHRObyz5F2/bZa4Fw&lt; at &gt;public.gmane.org http://lists.slony.info/mailman/listinfo/slony1-general </pre> ESLI george 2012-03-16T15:34:06 http://comments.gmane.org/gmane.comp.db.postgresql.slony1.general/10644 <pre>Looks like a odd situation; I have 2 sets, and one set with 3 tables and another with 50+ tables. Both the sets are replicated to two subscribers; one set has correct data, but second set two tables are off. And both the subscribers are up2date with origin; but 2 tables out of 3, has wrong number of rows (way off) in subscriber-1; So, whats the best way to re-copy or re-initiate these two tables copy only to subsriber-1 without subsriber-2 (it shares the set) as subscriber-2 is prod read facing. Thanks for the help Brian _______________________________________________ Slony1-general mailing list Slony1-general-8kkgcvHRObyz5F2/bZa4Fw&lt; at &gt;public.gmane.org http://lists.slony.info/mailman/listinfo/slony1-general </pre> Brian Trudal 2012-03-16T01:52:22 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.db.postgresql.slony1.general