anjali vyas anjali_nashpro
Mon Jan 1 04:40:49 PST 2007
Hello,

I am new to slony,
I am just trying to replicate my first database. Version of postgres is 8.0.9 and version of slony is 1.1.5 on my fedora core 6 server.I used same host but my ports are different for both  master and  slave  database.  I try to start slon process  using command- 

 /usr/local/pgsql/bin/slon cluster_c "dbname=company user=postgres host=localhost port=5434" &

output of this command --

 2007-01-01 18:04:45 IST CONFIG main: slon version 1.1.5 starting up
2007-01-01 18:04:45 IST CONFIG main: local node id = 1
2007-01-01 18:04:45 IST CONFIG main: launching sched_start_mainloop
2007-01-01 18:04:45 IST CONFIG main: loading current cluster configuration
2007-01-01 18:04:45 IST CONFIG storeNode: no_id=2 no_comment='Node 2'
2007-01-01 18:04:45 IST CONFIG storePath: pa_server=2 pa_client=1 pa_conninfo="dbname=company_slave host=localhost port=5436 user=postgres" pa_connretry=10
2007-01-01 18:04:45 IST CONFIG storeListen: li_origin=2 li_receiver=1 li_provider=2
2007-01-01 18:04:45 IST CONFIG storeSet: set_id=1 set_origin=1 set_comment='contact table'
2007-01-01 18:04:45 IST CONFIG main: configuration complete - starting threads
2007-01-01 18:04:45 IST DEBUG1 localListenThread: thread starts
NOTICE:  Slony-I: cleanup stale sl_nodelock entry for pid=11727
NOTICE:  Slony-I: cleanup stale sl_nodelock entry for pid=11727
2007-01-01 18:04:45 IST CONFIG enableNode: no_id=2
2007-01-01 18:04:45 IST DEBUG1 main: running scheduler mainloop
2007-01-01 18:04:45 IST DEBUG1 remoteWorkerThread_2: thread starts
2007-01-01 18:04:45 IST DEBUG1 cleanupThread: thread starts
2007-01-01 18:04:45 IST DEBUG1 syncThread: thread starts
2007-01-01 18:04:45 IST DEBUG1 remoteListenThread_2: thread starts
2007-01-01 18:04:45 IST DEBUG1 remoteListenThread_2: connected to 'dbname=company_slave host=localhost port=5436 user=postgres'
2007-01-01 18:04:47 IST FATAL  localListenThread: event 25: Unknown event type: 
2007-01-01 18:04:47 IST DEBUG1 slon: shutdown requested
2007-01-01 18:04:47 IST DEBUG1 syncThread: thread done
2007-01-01 18:04:47 IST INFO   remoteListenThread_2: disconnecting from 'dbname=company_slave host=localhost port=5436 user=postgres'
2007-01-01 18:04:47 IST DEBUG1 remoteListenThread_2: thread done
2007-01-01 18:04:47 IST DEBUG1 cleanupThread: thread done
2007-01-01 18:04:47 IST DEBUG1 main: scheduler mainloop returned
2007-01-01 18:04:47 IST DEBUG1 remoteWorkerThread_2: thread done
2007-01-01 18:04:47 IST DEBUG1 main: done
LOG:  unexpected EOF on client connection

so Please tell me what should I do now?
where I made mistake?


Thanks in advance.

                                                                                                              Ms. Anjali Vyas

 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20070101/628a564c/attachment.html 



More information about the Slony1-general mailing list