Andrew Sullivan wrote:
> On Wed, Feb 07, 2007 at 01:07:47PM +0100, Andrzej Kwiatkowski wrote:
>>> 2007-02-01 15:36:13 CET DEBUG2 remoteListenThread_2: queue event 2,17 SYNC
>>> 2007-02-01 15:36:17 CET DEBUG2 localListenThread: Received event 3,14 SYNC
>>> 2007-02-01 15:36:19 CET ERROR slon_connectdb: PQconnectdb("dbname=isp
>>> host=localhost port=5432 user=pgsql") f
>>> ailed - could not connect to server: Connection refused
>>> Is the server running on host "localhost" and accepting
>>> TCP/IP connections on port 5432?
>>>
>> Can someone help me with this problem ?
>
> Given that you can't connect, I can't understand how this could have
> been working in the first place. Note that the slon doesn't get
> reconfigured by failover. You need to run one slon per node.
Hi
If the Master listening on port 5432 is dead it is normal that slon
daemon is unable to connect.
On this lab host are 3 slon daemons:
4842 pi S+ 0:00,09 /opt/slonie/master/bin/slon test dbname=isp
host=localhost port=5432 user=pgsql
5019 pi S+ 0:00,00 /opt/slonie/master/bin/slon test dbname=isp
host=localhost port=5432 user=pgsql
4525 pj S+ 0:00,14 /opt/slonie/master/bin/slon test dbname=isp
host=localhost port=6000 user=pgsql
5021 pj S+ 0:00,00 /opt/slonie/master/bin/slon test dbname=isp
host=localhost port=6000 user=pgsql
4820 pk S+ 0:00,10 /opt/slonie/master/bin/slon test dbname=isp
host=localhost port=6001 user=pgsql
5023 pk S+ 0:00,00 /opt/slonie/master/bin/slon test dbname=isp
host=localhost port=6001 user=pgsql
In slon output on replica i've noticed:
2007-02-08 14:35:14 CET DEBUG2 start processing ACCEPT_SET
2007-02-08 14:35:14 CET DEBUG2 ACCEPT: set=1
2007-02-08 14:35:14 CET DEBUG2 ACCEPT: old origin=1
2007-02-08 14:35:14 CET DEBUG2 ACCEPT: new origin=2
2007-02-08 14:35:14 CET DEBUG2 ACCEPT: move set seq=33
2007-02-08 14:35:14 CET DEBUG2 got parms ACCEPT_SET
2007-02-08 14:35:14 CET DEBUG2 ACCEPT_SET - node not origin
And
ACCEPT_SET - MOVE_SET or FAILOVER_SET not received yet - sleep
I think that listen and store path are set correctly.
Can someone look at my initial slonik script ?
Thanks
AK
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
