Sebastien Marchand smarchand at sgo.fr
Wed Oct 16 06:17:01 PDT 2013
Hi,

I want do this :

SERVER 1			SERVER 2
SCHEMA A	------->		SCHEMA A
SCHEMA B	<-------		SCHEMA B

That works in slony 2.0.7/pg 9.0

But with  slony 2.2 and postgresql 9.3 

SERVER 1			SERVER 2	
SCHEMA A	------->		SCHEMA A	=> OK
SCHEMA B	<-------		SCHEMA B	=> NOK

I've got this error 

<stdin>:55: waiting for event (101,5000000004) to be  confirmed on node 110

Pg error : 

2013-10-15 10:55:10.950 CEST >ERROR:  relation
"_sloncluster.sl_local_node_id" does not exist at character 30 
2013-10-15 10:55:10.950 CEST >STATEMENT:  select last_value::int4 from
"_sloncluster".sl_local_node_id

Sorry for my english... :(

-----Message d'origine-----
De : Steve Singer [mailto:ssinger at ca.afilias.info] 
Envoyé : mercredi 16 octobre 2013 15:07
À : Sebastien Marchand
Cc : slony1-general at lists.slony.info
Objet : Re: [Slony1-general] Problem slony 2.2 and pg 9.3 double replication

On 10/16/2013 08:29 AM, Sebastien Marchand wrote:
> Hi everybody,

You need to be a lot more specific on what it is your doing/trying to do and
how your going about doing it.

Slony normally replicates data from   schemaA.tableA on server 1 to
schemaA.tableA on server 2.



>
> I’ve got one replication server A schema A to server B schema B
>
> No probleme that works
>
> But i would like to do another replication in the same time, server B 
> schema B to server A schema A ( slony 2.0.7/pg 9.0 works )
>
> I’ve got error :
>
> Slony error : <stdin>:55: waiting for event (101,5000000004) to be 
> confirmed on node 110
>
> Pg error : < 2013-10-15 10:55:10.950 CEST >ERROR:  relation 
> "_sloncluster.sl_local_node_id" does not exist at character 30 < 
> 2013-10-15 10:55:10.950 CEST >STATEMENT:  select last_value::int4 from 
> "_sloncluster".sl_local_node_id
>
> I need some help, thanks.
>
> Cordialement,
>
> Sébastien Marchand
>
> Société SGO
>
>
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>



More information about the Slony1-general mailing list