Christopher Browne ha scritto:
Alessio Iannone <[email protected]> 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.
Thanks for your reply, I am now trying to test the PostgreSQL Plus
Installer wich bundle Slony 1.2.15.
After this test i will try however to use slony 2.0.0 using your suggestion.
I have a question: Slony1 2.0.0 Coulbe be considered ready for a
production site?
Best Regards Alessio Iannone
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
