Alessio Iannone alessio.iannone at nextant.it
Tue Jan 20 00:44:07 PST 2009
Christopher Browne ha scritto:
> 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.
>   
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


More information about the Slony1-general mailing list