Alessio Iannone <alessio.iannone at nextant.it> writes:
> Hi all,
> I am new about slony. I am reading the documentation about slony1
> 2.0.0 release, and i am trying to be able to run the first example the
> one that is using pgbench.
>
> I have tried to launch the scripts founded in section 2.3.1 of
> "Replicating Your First Database" chapter of the guide
>
> i get  this error: <stdin>:32: ERROR: syntax error at or near table.
>
> I also noticed that the compilation of slony doesn't create any
> xxid.so library.
>
> Any hints?

A downside to the example there is that, by embedding generation of
the Slonik code into a shell script, that makes it more difficult to
track down exactly where the error occurred :-(.

Probably the easiest way of setting up replication from a "keeping the
errors simple to track down" perspective is the shell script,
tools/configure-replication.sh, documented in
tools/configure-replication.txt

That generates a series of slonik scripts, which should make it easier
to pin down exactly where something broke, and the first time around,
there's a lot of value to that.  Any little configuration error will
make something break, and it's not much fun tracing things down
remotely based on guessing the output of things :-(.

The one thing I *can* point to is that it is not an error that xxid.so
is not there.  In Slony-I version 2.0, xxid.so is no longer necessary
because the built-in data type "txid" (new in PostgreSQL 8.3) replaces
its functionality.
-- 
output = reverse("ofni.sesabatadxunil" "@" "enworbbc")
http://linuxdatabases.info/info/spreadsheets.html
"Moebius strippers only show you their back side." -- Unknown