2007/11/22, termeau sebastien <XXXXXXXX>:
>
> Hello,
>
> I am using Slony 1.2.12 with Postgresql 8.2.5
> I have 2 nodes replicating a small database.
> The replication works fine but when I try to use failover and switchover I
> got an error.
> Failover and switchover were working perfectly before but now I can't use
> these features anymore, even I downgrade to Slony 1.2.9.
> Can you please help to find the source of this error?
> Thanks in advance
>
> #########################
> <stdin>:6: PGRES_FATAL_ERROR select "_my_cluster".failedNode(1, 2);  -
> ERROR:  relation "PartInd_my_cluster_sl_log_2-" already exists
> CONTEXT:  SQL statement "create index "PartInd_my_cluster_sl_log_2-node-2"
> on "_my_cluster".sl_log_2 USING btree(log_xid "_my_cluster".xxid_ops) whe=
re
> (log_origin =3D 2);"
> PL/pgSQL function "addpartiallogindices" line 34 at execute statement
> SQL statement "SELECT  "_my_cluster".addPartialLogIndices()"
> PL/pgSQL function "failednode" line 158 at perform
> <stdin>:8: Failure to fail node 1 over to 2
> #########################
>


Hello again,

I am glad to be able to answer to my own question ...
It seems that my cluster name is too long ( yes I replaced the name of the
cluster in the exemples above by a fake one, for confidential purpose). Then
it takes more than 64 char to write the index name PartInd_*.
I had to rebuild postgresql with NAMEDATALEN=3D128 to solve my problem.

Thanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20071122/=
1edcbcde/attachment.htm