[Slony1-general] upgrading from 9.4 to 11.5

Good morning, We are a former user of slony and are looking to perform an upgrade from an on-prem linux server (9.4) to Azure (11.5) Can we use slony to set up master (9.4) to slave (11.5) or is that too big a jump? A prompt response would be appreciated. Thank you, -- *Mark Steben* Database

Re: [Slony1-general] running slony1 2.2.5

_first | 2018-01-26 19:13:43.434628-05 as_apply_last| 2018-02-14 11:13:51.191299-05 as_cache_prepare | 0 as_cache_hit | 0 as_cache_evict | 0 as_cache_prepare_max | 0 Thanks for your time. On Wed, Feb 14, 2018 at 12:25 PM, Mark Steben <mark.ste...@drivedominion.co

[Slony1-general] running slony1 2.2.5

s FALSE 2018-02-14 12:17:20 EST ERROR remoteWorkerThread_1: provider node -1 for set 20not found in runtime configuration 2018-02-14 12:17:20 EST CONFIG slon: child terminated signal: 9; pid: 24519, current worker pid: 24519 2018-02-14 12:17:20 EST CONFIG slon: restart of worker in 10 seconds Any ideas short

[Slony1-general] upgrading with pg_upgrade

her instance the upgrade is successful. Any help / insight appreciated. Thank you -- *Mark Steben* Database Administrator @utoRevenue <http://www.autorevenue.com/> | Autobase <http://www.autobase.net/> CRM division of Dominion Dealer Solutions 95D Ashley Ave. West Springfield, MA 0

Re: [Slony1-general] slonik_drop_table issues

this point all I want to do is for this process to stop. It apparently is trying to correct my previous screw-up and I already 'corrected' it. Any ideas, comments welcome. Thank you On Thu, Jun 23, 2016 at 1:44 PM, Mark Steben <mark.ste...@drivedominion.com> wrote: > In answer to m

Re: [Slony1-general] slonik_drop_table issues

not change the name in sl_table, hence the 'NOT FOUND' On Thu, Jun 23, 2016 at 12:00 PM, Mark Steben <mark.ste...@drivedominion.com > wrote: > Yes it does - only one replica being used. > Question - do the index names on the master and replica have to match? > > On Thu, Jun 23, 2016 at 11

Re: [Slony1-general] slonik_drop_table issues

Yes it does - only one replica being used. Question - do the index names on the master and replica have to match? On Thu, Jun 23, 2016 at 11:47 AM, Vick Khera <vi...@khera.org> wrote: > > On Thu, Jun 23, 2016 at 9:54 AM, Mark Steben < > mark.ste...@drivedominion.com>

[Slony1-general] slonik_drop_table issues

_int(integer) line 52 at PERFORM SQL statement "SELECT "_replication".setDropTable_int(p_tab_id)" PL/pgSQL function _replication.setdroptable(integer) line 40 at PERFORM :8: Could not drop table 140 for replication! Please advise. thanks! -- *Mark Steben* Databas

[Slony1-general] moving sl_log_1 and sl_log_2 tables

lun if possible. Could it be as simple as copying the tables to the new lun and creating a synonym on the old lun pointing to the copied table? Any suggestions/recommendations welcome. Thanks -- *Mark Steben* Database Administrator @utoRevenue <http://www.autorevenue.com/> | Autobase

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

tion necessary? (We are running slony 2.2.3) I did check on www.slony.info and didn't find any reference to pg_upgrade. Thanks for your time and insights -- *Mark Steben* Database Administrator @utoRevenue <http://www.autorevenue.com/> | Autobase <http://www.autobase.net/>

[Slony1-general] bloat maintenance on slony internal tables

. Is there a utility that I can run to clean this bloat out or do I need to resort to VACUUM FULL? Thank you, -- *Mark Steben* Database Administrator @utoRevenue http://www.autorevenue.com/ | Autobase http://www.autobase.net/ CRM division of Dominion Dealer Solutions 95D Ashley Ave. West Springfield, MA

Re: [Slony1-general] Wish to run altperl scripts on master rather than slave

. On Thu, Feb 19, 2015 at 3:05 PM, Christopher Browne cbbro...@afilias.info wrote: On Thu, Feb 19, 2015 at 11:59 AM, Mark Steben mark.ste...@drivedominion.com wrote: Good morning, We are running the following on both master and slave: (a simple 1 master to 1 slave configuration

[Slony1-general] Wish to run altperl scripts on master rather than slave

. -- *Mark Steben* Database Administrator @utoRevenue http://www.autorevenue.com/ | Autobase http://www.autobase.net/ CRM division of Dominion Dealer Solutions 95D Ashley Ave. West Springfield, MA 01089 t: 413.327-3045 f: 413.383-9567 www.fb.com/DominionDealerSolutions www.twitter.com

[Slony1-general] Fwd: slony init_cluster problem

*Sorry for redundancy: forgot to include the slony1-general list in my first response * -- Forwarded message -- From: Mark Steben mark.ste...@drivedominion.com Date: Fri, Oct 5, 2012 at 9:22 AM Subject: Re: [Slony1-general] slony init_cluster problem To: Raghav ragavendra

[Slony1-general] slony init_cluster problem

from the slave. The admin user referenced in the slon_tools is slony and is defined as a superuser. Any help appreciated. Any other info you need, please let me know. Mark Steben DBA at AutoRevenue* # # Author: Christopher Browne # Copyright 2004-2009 Afilias Canada # Revised

Re: [Slony1-general] change the listening port on master node

Got this to work - just had to put fully qualified slonik program As the first line in the shell script, then preamble, then STORE PATH Command, etc, etc, etc Mark Steben Database Administrator @utoRevenue | Autobase | AVV The CRM division of Dominion Dealer Solutions 95D Ashley Avenue West

[Slony1-general] change the listening port on master node

'); add_node(node=2, host = '192.168.1.221', dbname = 'mavmail', port =5432, user='slony', password='elephant1234'); Obviously would like to change the port on server 192.168.1.222 to 5433 without dropping and redefining everything. Any help appreciated. Thanks. Mark

Re: [Slony1-general] change the listening port on master node

' );' Something very obvious I'm sure - just not familiar enough with the slony Language. Any help appreciated. Thank you Mark Steben Database Administrator @utoRevenue | Autobase | AVV The CRM division of Dominion Dealer Solutions 95D Ashley Avenue West Springfield, MA 01089 t: 413.327.3045

[Slony1-general] ERROR: duplicate key value violates unique constraint sl_nodelock-pkey error - bugzilla # 132

, Mark Steben | Database Administrator http://www.autorevenue.com @utoRevenueR - Keeping Customers Close 95D Ashley Ave, West Springfield, MA 01089 413.243.4800 x1512 (Phone) |413.732-1824 (Fax) http://www.dominionenterprises.com @utoRevenue is a registered trademark and a division of Dominion

[Slony1-general] server crash on slave: slon-start to do catch-up VS re-subscribe

EST 2010 x86_64 x86_64 x86_64 GNU/Linux Thank you, Mark Steben | Database Administrator  @utoRevenue® - Keeping Customers Close  95D Ashley Ave, West Springfield, MA 01089 413.243.4800 x1512 (Phone) |413.732-1824 (Fax) @utoRevenue is a registered trademark and a division of Dominion

Re: [Slony1-general] install instruction

Mark Steben | Database Administrator  @utoRevenue® - Keeping Customers Close  95D Ashley Ave, West Springfield, MA 01089 413.243.4800 x1512 (Phone) |413.732-1824 (Fax) @utoRevenue is a registered trademark and a division of Dominion Enterprises    From

Re: [Slony1-general] install instruction

-- 1 root root 72296 Nov 24 13:12 slony_logshipper.o -rw-r--r-- 1 root root 4728 Nov 24 13:12 y.tab.h Mark Steben | Database Administrator @utoRevenueR - Keeping Customers Close 95D Ashley Ave, West Springfield, MA 01089 413.243.4800 x1512 (Phone) |413.732-1824 (Fax) @utoRevenue

[Slony1-general] install instruction

to doc, or give me some insights relative To slony1-2 and how installation is different from slony1-1. I previously Had that successfully installed. Thank you, Mark Steben | Database Administrator http://www.autorevenue.com @utoRevenueR - Keeping Customers Close 95D Ashley Ave, West

[Slony1-general] VMWARE question

2010 x86_64 x86_64 x86_64 GNU/Linux 32 GB total memory SLAVE Linux ar-db4 2.6.18-194.8.1.el5 #1 SMP Thu Jul 1 19:04:48 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux 32 GB total memory Thank you, Mark Steben | Database Administrator  @utoRevenue® - Keeping Customers Close  95D Ashley Ave

[Slony1-general] recommendations for removing bloat

play nice with slony? Thank you for your time, Mark Steben | Database Administrator  @utoRevenue® - Keeping Customers Close  95D Ashley Ave, West Springfield, MA 01089 413.243.4800 x1512 (Phone) |413.732-1824 (Fax) @utoRevenue is a registered trademark and a division of Dominion Enterprises

[Slony1-general] 32 BIT vs 64 BIT architecture

to Creating @utoEnthusiasts. Please provide us with your feedback. Mark Steben│Database Administrator│ @utoRevenueT 95 Ashley Ave. West Springfield, MA., 01089 413-243-4800 x1512 (Phone) │ 413-732-1824 (Fax) A Division of Dominion Enterprises

[Slony1-general] MIXED VERSIONS OF POSTGRES

mailto:[EMAIL PROTECTED] Committed to Creating @utoEnthusiasts. Please provide us with your feedback. _ Mark Steben│Database Administrator│ http://www.autorevenue.com/ @utoRevenueT 95 Ashley Ave. West Springfield, MA., 01089 413-243-4800 x1512 (Phone) │ 413-732-1824 (Fax

[Slony1-general] Slony over a WAN?

Springfield that I will be operating out of. I plan on employing Slony-1 To provide replication between these 2 'not so long distance' locations. Any comments welcome. Thanks Mark Steben│Database Administrator│ @utoRevenueT 480 Pleasant Street, Suite B200, Lee, MA 01238 413-243-4800 x1512

RE: [Slony1-general] RE: node -1 error after restarting servers

To: Mark Steben Cc: 'chris'; slony1-general@lists.slony.info Subject: Re: [Slony1-general] RE: node -1 error after restarting servers Hi Mark - I have had this problem myself. The only way I solved it was to remove all reference to the set merge/creation (set 99 in your case) from my sl_events

RE: [Slony1-general] RE: node -1 error after restarting servers

. Mark From: chris [mailto:[EMAIL PROTECTED] Sent: Monday, August 11, 2008 10:56 AM To: Mark Steben Cc: slony1-general@lists.slony.info Subject: Re: [Slony1-general] RE: node -1 error after restarting servers Mark Steben [EMAIL PROTECTED] writes: I messed up and sent this originally as HTML

[Slony1-general] node -1 error after restarting servers

) as well? Any help would be appreciated. thanks . _ Mark Steben│Database Administrator│ http://www.autorevenue.com/ @utoRevenueT 480 Pleasant Street, Suite B200, Lee, MA 01238 413-243-4800 x1512 (Phone) │ 413-243-4809 (Fax) A Division of Dominion Enterprises

RE: [Slony1-general] provider I/P address has been changed

or without www.slony.info that has basic 'how to' administrative tasks that I can refer to? Thanks for your time. __ Mark Steben│Database Administrator│ @utoRevenueT 480 Pleasant Street, Suite B200, Lee, MA 01238 413-243-4800 x1512 (Phone) │ 413-243-4809 (Fax

[Slony1-general] provider I/P address has been changed

, client=1, conninfo='dbname=slony_practice host=192.168.1.29 user=postgres'); # echo successful store paths store listen (origin=1, provider=1, receiver=2); store listen (origin=2, provider=2, receiver=1); # echo successful store listens Thanks for your help, Mark

RE: [Slony1-general] execute script doesn't work

Thanks Chris - that worked Mark Steben│ Database Administrator│ @utoRevenue™ 480 Pleasant Street, Suite B200 │ Lee, Ma 01238 413.243.4800 ' │ 413.243.4809 Ê The problem here is that every slonik script needs to start with the preamble portion, that is, it must

[Slony1-general] execute script doesn't work

. Also any 'getting started ' tutorials would help. Thank you, mailto:[EMAIL PROTECTED] Committed to Creating @utoEnthusiasts. Please provide us with your feedback. _ Mark Steben│ Database Administrator│ http://www.autorevenue.com/ @utoRevenueT 480 Pleasant Street

RE: [Slony1-general] trying to run test_slony_state.pl

Thank you - will post in MS Word plain vanilla from now on. Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax [EMAIL PROTECTED] Visit our new website