[Slony1-general] upgrading from 1.x to 2.x

What does this ominous message mean When Slony-I uninstalls itself, catalog corruptions are fixed back up. Dave Cramer ___ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general

Re: [Slony1-general] upgrading from 1.x to 2.x

Thanks Jan, I see if I squint and tilt my head a certain way that it reads correctly. Is there a debian 2.x package for wheezy ? Dave Dave Cramer On 18 June 2014 18:08, Jan Wieck j...@wi3ck.info wrote: On 06/18/14 15:59, Dave Cramer wrote: What does this ominous message mean When Slony

Re: [Slony1-general] upgrading from 1.x to 2.x

Is there a script somewhere to provide a report of what slony is attempting to do ? In other words denormalize the slony config ? Dave Cramer On 19 June 2014 15:08, Steve Singer ssin...@ca.afilias.info wrote: On 06/19/2014 02:58 PM, Dave Cramer wrote: Thanks Jan, I see if I squint

[Slony1-general] sl_log_x very large due to lagging subscription

If I drop the subscription through drop set will the log file be automagically cleaned up ? If not how can I fix it ? Dave Cramer ___ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general

Re: [Slony1-general] sl_log_x very large due to lagging subscription

of one that is not lagging. One of the sl_log_x files is 16G in size. Suggestions are welcome Dave Cramer www.credativ.ca On Jun 27, 2014 4:04 PM, Dave Cramer davecra...@gmail.com wrote: If I drop the subscription through drop set will the log file be automagically cleaned up ? If not how

[Slony1-general] replicating from 9.3 to 8.4

Are there any known issues ? Dave Cramer ___ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general

[Slony1-general] replicating from 9.3 to 8.4

I'm running into http://www.slony.info/bugzilla/show_bug.cgi?id=331 The reason for copying from 9.3 to 8.4 is that an 8.4 is in the upgrade path. It will be temporary, but necessary. Dave Cramer ___ Slony1-general mailing list Slony1-general

Re: [Slony1-general] replicating from 9.3 to 8.4

I like the second solution ... and yes, I can Dave Cramer On 7 October 2014 14:14, Vick Khera vi...@khera.org wrote: can you then just set the bytea_output setting on the 9.3 server to 'escape' for this duration? or perhaps set that on the slony user only? On Tue, Oct 7, 2014 at 6:51 AM

Re: [Slony1-general] Error with Slony replication from another slony cluster slave

Jan, But as you said they all have to be in the same cluster, correct ? Dave Cramer On 9 October 2014 18:31, Jan Wieck j...@wi3ck.info wrote: On 10/09/2014 05:26 PM, Glyn Astill wrote: From: Granthana Biswas granthana.bis...@gmail.com To: Glyn Astill glynast...@yahoo.co.uk Sent: Thursday

Re: [Slony1-general] Lag time increasing but there are no events

Actually I think it is because a pg_dump of the db is going on. Can you dump a slave ? Do you have to exclude the slony clusters (which would make sense)? Thanks, Dave Dave Cramer On 16 October 2014 10:34, Glyn Astill glynast...@yahoo.co.uk wrote: From: Dave Cramer davecra...@gmail.com

Re: [Slony1-general] Lag time increasing but there are no events

Dave Cramer On 16 October 2014 11:48, Glyn Astill glynast...@yahoo.co.uk wrote: From: Glyn Astill glynast...@yahoo.co.uk To: Dave Cramer davecra...@gmail.com Cc: slony slony1-general@lists.slony.info Sent: Thursday, 16 October 2014, 16:26 Subject: Re: [Slony1-general] Lag time

Re: [Slony1-general] Lag time increasing but there are no events

So what's the best way to deal with very large databases. pg_dump just doesn't cut it. By the time we are finished dumping the data is stale anyway ! I'm thinking of using PITR instead. Rolling over once a week Dave Cramer On 17 October 2014 08:51, Jan Wieck j...@wi3ck.info wrote: On 10/16

Re: [Slony1-general] Lag time increasing but there are no events

Well replica's don't protect you from everything. Such as drop table, or delete from ... or truncate ... No one backup solution protects you from everything. Dave Dave Cramer On 17 October 2014 16:12, Vick Khera vi...@khera.org wrote: On Fri, Oct 17, 2014 at 9:00 AM, Dave Cramer davecra

Re: [Slony1-general] Lag time increasing but there are no events

backup using slony, and snapshots for disaster recovery. On Fri, Oct 17, 2014 at 4:37 PM, Dave Cramer davecra...@gmail.com wrote: Well replica's don't protect you from everything. Such as drop table, or delete from ... or truncate ... No one backup solution protects you from everything

[Slony1-general] 9.3 origin, 8.3 subscriber bytea_output =escape for the slony user doesn't seem to work

I have checked and rechecked this. The slony user on 9.3 has bytea_output set to escape, but for some reason hex encoded data is in the logs. Where in the code can I check to see how or why this is happening ? Dave Cramer ___ Slony1-general mailing

Re: [Slony1-general] 9.3 origin, 8.3 subscriber bytea_output =escape for the slony user doesn't seem to work

So I changed the bytea_output at the cluster level and it now works ??? This is not consistent with my understanding of how pg should handle user level config settings ? Dave Cramer On 24 December 2014 at 10:20, Christopher Browne cbbro...@afilias.info wrote: I'll bet the log trigger (C/SPI

Re: [Slony1-general] 9.3 origin, 8.3 subscriber bytea_output =escape for the slony user doesn't seem to work

Dave Cramer On 26 December 2014 at 17:31, Steve Singer st...@ssinger.info wrote: On Wed, 24 Dec 2014, Dave Cramer wrote: So I changed the bytea_output at the cluster level and it now works ??? This is not consistent with my understanding of how pg should handle user level config settings

Re: [Slony1-general] Lots of data in sl_log_? but sl_status shows lag of 0

Hi Jeff, Pretty sure this is a pg_dump blocking the cleanup. Thanks, Dave Cramer On 21 January 2015 at 11:02, Jeff Frost j...@pgexperts.com wrote: On Jan 21, 2015, at 06:24, Dave Cramer davecra...@gmail.com wrote: How is this possible ? Cleanup hasn't run? Is the slon

[Slony1-general] Lots of data in sl_log_? but sl_status shows lag of 0

How is this possible ? Dave Cramer ___ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general

Re: [Slony1-general] replicating execute script

Actually I think it has been fixed in bug 349 (Thanks Chris) However I'd like to integrate schema changes into something like flyway. https://github.com/flyway/ Not sure how this best plays out yet. Dave Cramer On 19 March 2015 at 05:47, Glyn Astill glynast...@yahoo.co.uk wrote: From: Dave

Re: [Slony1-general] replicating execute script

On 19 March 2015 at 09:51, Steve Singer ssin...@afilias.info wrote: On 03/19/2015 06:32 AM, Dave Cramer wrote: Actually I think it has been fixed in bug 349 (Thanks Chris) However I'd like to integrate schema changes into something like flyway. https://github.com/flyway/ Not sure how

Re: [Slony1-general] replicating execute script

Dave Cramer On 19 March 2015 at 11:50, Steve Singer ssin...@afilias.info wrote: On 03/19/2015 09:57 AM, Dave Cramer wrote: On 19 March 2015 at 09:51, Steve Singer ssin...@afilias.info mailto:ssin...@afilias.info wrote: On 03/19/2015 06:32 AM, Dave Cramer wrote: Actually I

Re: [Slony1-general] Slony error when insert data

We will require more information than this. Server logs ?? On 15 May 2015 at 06:42, Дмитрий Воронин carriingfat...@yandex.ru wrote: Hello, I am using Slony1-2.2.4, PostgreSQL 9.4.1. I set replication system by documentation. I have I replicated table named 'test'. When I start replication,

[Slony1-general] Dropping a node when the node is gone ?

Drop node always wants to connect to the node ?? Dave Cramer ___ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general

Re: [Slony1-general] Dropping a node when the node is gone ?

Yes, but the node is no longer physically there ?? Even worse it is a provider for another node Dave Cramer On 24 August 2015 at 14:19, Greg Sabino Mullane g...@endpoint.com wrote: On Sun, Aug 23, 2015 at 05:56:34PM -0400, Dave Cramer wrote: Drop node always wants to connect to the node

Re: [Slony1-general] using slony to go from 8.4 to 9.4

That's a bit of a nightmare... in a very connected system ! Dave Cramer On 30 June 2015 at 14:02, Vick Khera vi...@khera.org wrote: On Tue, Jun 30, 2015 at 1:58 PM, Dave Cramer davecra...@gmail.com wrote: this is on debian and the master is 2.2.2 and the slave is 2.2.4. How much grief

Re: [Slony1-general] using slony to go from 8.4 to 9.4

Yes, it would appear to be an issue of versions. this is on debian and the master is 2.2.2 and the slave is 2.2.4. How much grief is there to upgrade the master ? Will all the slons have to be restarted and do all of the nodes have to be upgraded ? Dave Cramer On 30 June 2015 at 13:48, Steve

[Slony1-general] using slony to go from 8.4 to 9.4

I'm trying to replicate from 8.4 to 9.4 Getting the following error on the store node could not access file $libdir/slony1_funcs.2.2.2 This is occurring when trying to install the functions into the 9.4 node Dave Cramer ___ Slony1-general mailing list

[Slony1-general] how to remove an event

I managed to create a path which had a user which was wrong, then executed a subscribe set on that path. I tried unsubscribe set but the event is still in the logs ? Dave Cramer ___ Slony1-general mailing list Slony1-general@lists.slony.info http

Re: [Slony1-general] Dropping a node when the node is gone ?

On 24 August 2015 at 17:13, Steve Singer ssin...@ca.afilias.info wrote: On 08/24/2015 05:06 PM, Dave Cramer wrote: and a slonik script like --- cluster name=mycluster; node 1 admin conninfo='...' node 4 admin conninfo='...' resubscribe node(origin

Re: [Slony1-general] Dropping a node when the node is gone ?

On 24 August 2015 at 17:03, Steve Singer ssin...@ca.afilias.info wrote: On 08/24/2015 04:58 PM, Dave Cramer wrote: On 24 August 2015 at 16:57, Steve Singer ssin...@ca.afilias.info mailto:ssin...@ca.afilias.info wrote: On 08/24/2015 04:12 PM, Dave Cramer wrote: I am currently

Re: [Slony1-general] Dropping a node when the node is gone ?

On 24 August 2015 at 17:23, Steve Singer ssin...@ca.afilias.info wrote: On 08/24/2015 05:17 PM, Dave Cramer wrote: On 24 August 2015 at 17:13, Steve Singer ssin...@ca.afilias.info mailto:ssin...@ca.afilias.info wrote: On 08/24/2015 05:06 PM, Dave Cramer wrote

Re: [Slony1-general] Dropping a node when the node is gone ?

I am currently waiting on a resubscribe event. How does slony get this event through all the backlog events ? Dave Cramer On 24 August 2015 at 15:38, Scott Marlowe scott.marl...@gmail.com wrote: Note that the node will still show up in sl_nodes and sl_status for a while, until slony does

Re: [Slony1-general] Dropping a node when the node is gone ?

On 24 August 2015 at 16:57, Steve Singer ssin...@ca.afilias.info wrote: On 08/24/2015 04:12 PM, Dave Cramer wrote: I am currently waiting on a resubscribe event. How does slony get this event through all the backlog events ? Usually pretty quickly. Slonik waits for the provider

Re: [Slony1-general] Dropping a node when the node is gone ?

On 24 August 2015 at 17:35, Steve Singer ssin...@ca.afilias.info wrote: On 08/24/2015 05:29 PM, Dave Cramer wrote: Now I assume the only at (2,5003478340 tel:5003478340) number is staying the same and it isn't going up. IF it is then you actually have progress being made

Re: [Slony1-general] Dropping a node when the node is gone ?

Dave Cramer On 24 August 2015 at 17:42, Steve Singer ssin...@ca.afilias.info wrote: On 08/24/2015 05:40 PM, Dave Cramer wrote: On 24 August 2015 at 17:35, Steve Singer ssin...@ca.afilias.info mailto:ssin...@ca.afilias.info wrote: On 08/24/2015 05:29 PM, Dave Cramer wrote

Re: [Slony1-general] Dropping a node when the node is gone ?

Apparently patience is a virtue I don't possess. This morning the resubscribe had completed overnight. I was able to drop the node and everything is well Thanks for your help! Dave Cramer On 24 August 2015 at 17:44, Dave Cramer davecra...@gmail.com wrote: Dave Cramer On 24 August 2015

Re: [Slony1-general] upgrade slony master / slave using pg_upgrade

You would need to install the new slony libs and upgrade slony, but yes it should work On 29 September 2015 at 17:23, Mark Steben wrote: > Good evening > > Fairly simple question (I think) > Can I use the pg_upgrade contrib module to upgrade from postgres 9.2 to >

Re: [Slony1-general] Slony with Amazon's RDS service?

Dave Cramer On 21 December 2015 at 19:53, Jan Wieck <j...@wi3ck.info> wrote: > On 12/21/2015 05:44 PM, David Fetter wrote: > > On Fri, Dec 18, 2015 at 11:45:04AM -0300, "Gonzalo Vásquez @ Waypoint" > wrote: > >> Is it actually possible to somehow use Slon

Re: [Slony1-general] UPDATE syncs but not from Java app

I don't see how that is possible java doesn't do anything magic with updates. Dave Cramer On 25 May 2016 at 17:57, William Widener <william.wide...@readytalk.com> wrote: > Hello there, > > Our company has used an older version of slony for years successfully. > We have embar

Re: [Slony1-general] removing old slony triggers

Yes, safe to drop the schema. Although I have had instances where it won't drop cleanly. In which case you will have to do it manually Dave Cramer On 26 May 2016 at 11:15, Mike James <mike.ja...@clutch.com> wrote: > I attached to the db with pgAdmin and when I tried to open

Re: [Slony1-general] removing old slony triggers

You have to go through each table and drop all of the slony triggers Dave Cramer On 26 May 2016 at 15:01, Mike James <mike.ja...@clutch.com> wrote: > I was trying to delete the unused slony replication cluster and of course, > it hung up and I ended up blocking our prod db for

[Slony1-general] is there an easy way to resyncronize a table

Dave Cramer ___ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general

Re: [Slony1-general] what is the solution to Bug 111 – node -1 not found in runtime configuration - Slony-I

On 13 January 2017 at 13:52, Christopher Browne <cbbro...@gmail.com> wrote: > On 13 January 2017 at 08:42, Dave Cramer <davecra...@gmail.com> wrote: > > Unfortunately bugzilla is down > > http://www.slony.info/bugzilla/show_bug.cgi?id=111 > > You can actually

[Slony1-general] what is the solution to Bug 111 – node -1 not found in runtime configuration - Slony-I

Unfortunately bugzilla is down http://www.slony.info/bugzilla/show_bug.cgi?id=111 Dave Cramer ___ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general