Slony1 PostgreSQL Replication - slony not working

Author

slony not working

Joseph Shraibman

2005-09-25, 8:24 pm

I tried to get slony set up to replicate from one machine to the other.
I followed the example to set up my cluster, but when I start slon on
my slave machines I get these messages printed out every 10 seconds:

2005-09-25 17:33:41 EDT ERROR remoteListenThread_1
: db_getLocalNodeId()
returned 2 - wrong database?
2005-09-25 17:33:43 EDT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 5
2005-09-25 17:33:43 EDT DEBUG2 localListenThread: Received event 2,5 SYNC

What does that mean?

Jan Wieck

2005-09-26, 11:24 am

On 9/25/2005 5:49 PM, Joseph Shraibman wrote:

> I tried to get slony set up to replicate from one machine to the other.
> I followed the example to set up my cluster, but when I start slon on
> my slave machines I get these messages printed out every 10 seconds:
>
>
> 2005-09-25 17:33:41 EDT ERROR remoteListenThread_1
: db_getLocalNodeId()
> returned 2 - wrong database?
> 2005-09-25 17:33:43 EDT DEBUG2 syncThread: new sl_action_seq 1 - SYNC 5
> 2005-09-25 17:33:43 EDT DEBUG2 localListenThread: Received event 2,5 SYNC
>
>
>
> What does that mean?

Check the conninfo strings on all your paths. This message means that
slon tries to connect to the database of node 1 but the conninfo string
leads it to the postmaster of node 2. These are NOT the conninfo's of
the admin connections for slonik, but the ones for the STORE PATH stuff.

Jan

> ____________________
____________________
_______
> Slony1-general mailing list
> Slony1-general- AuKwsB3Fm+ugFIWk8tvy
RWD2FQJk+8+b@public.gmane.org
> http://gborg.postgresql.org/mailman.../slony1-general

--
#===================
====================
====================
===========#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#===================
====================
=========== JanWieck- bwPqjjyvM7QAvxtiuMwx
3w@public.gmane.org #

Sponsored Links