Re: [Slony1-general] Re: Slony1-general Digest, Vol 16, Issue 27

2008-06-27 Thread Troy Wolf
Alexander (and others), I tested this and it works perfectly. Thanks, Chris Browne. I know a lot of people use PERL scripts, etc. I use simple bash shell scripts with the slonik commands. Here is a snippet of my subscribe code. I have my common slonik preamble stuff in a file named

Re: [Slony1-general] Re: Slony1-general Digest, Vol 16, Issue 27

2008-06-27 Thread Alexander Staubo
On Fri, Jun 27, 2008 at 4:03 PM, Troy Wolf [EMAIL PROTECTED] wrote: Alexander (and others), I tested this and it works perfectly. Thanks, Chris Browne. I know a lot of people use PERL scripts, etc. I use simple bash shell scripts with the slonik commands. Here is a snippet of my subscribe

Re: [Slony1-general] Re: Slony1-general Digest, Vol 16, Issue 27

2008-06-27 Thread Christopher Browne
Alexander Staubo [EMAIL PROTECTED] writes: On Fri, Jun 27, 2008 at 4:03 PM, Troy Wolf [EMAIL PROTECTED] wrote: Alexander (and others), I tested this and it works perfectly. Thanks, Chris Browne. I know a lot of people use PERL scripts, etc. I use simple bash shell scripts with the slonik

[Slony1-general] Replication of sequences required?

2008-06-27 Thread Alexander Staubo
Am I correct in thinking that there are cases where you don't need to set up replication of sequences at all? For example, if you're setting up Slony slaves for the sole purpose of off-loading read-only queries from the master *and* you only ever use sequences in conjunction with serial columns,

[Slony1-general] execute script doesn't work

2008-06-27 Thread Mark Steben
Very basic question from a very new slony user I am running slony 1.2.14. Very simple configuration - 1 master 1 slave Both running postgres 8.2.5. I have slony working, successfully replicating seven tables. I also have successfully run some of the monitoring scripts (E.G.

Re: [Slony1-general] Replication of sequences required?

2008-06-27 Thread Christopher Browne
Alexander Staubo [EMAIL PROTECTED] writes: Am I correct in thinking that there are cases where you don't need to set up replication of sequences at all? For example, if you're setting up Slony slaves for the sole purpose of off-loading read-only queries from the master *and* you only ever use

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

2008-06-27 Thread Shahaf Abileah
There are a couple commands that you must include in every slonik script.  I generally define a header file (some people call it preamble) and include it in all my other scripts. It's called cluster.definitions.slonik, and it looks like this: # The cluster name must be the first

[Slony1-general] Initial release candidate for Slony-I 2.0

2008-06-27 Thread Christopher Browne
We are pleased to present the first release candidate for version 2 of Slony-I. It will almost certainly not be the final for v2.0.0, but has been tested enough (by Jan and I) that it seems worthwhile to encourage others to test it and see if there are issues that we didn't notice. Differences