-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I need know if somebody here has installed/configured a postgresql
replication where gentoo is a master host. I'm trying to make it using
slony1, but have some mismatch configuration, look:
/
USER=postgres
CLUSTER=slave.host
DBUSER=snort
DBNAME=snort_log
DBHOST=master.host
LOGFILE=/var/lib/postgresql/data/slony1.log
LOGLEVEL=4 # 1(minimum)..4(maximum)/
I think that the error are in CLUSTER option looking in slony1's log:
/2008-08-28 15:16:57 BRT CONFIG main: slon version 1.2.10 starting up
2008-08-28 15:16:57 BRT DEBUG2 slon: watchdog process started
2008-08-28 15:16:57 BRT DEBUG2 slon: watchdog ready - pid = 22743
2008-08-28 15:16:57 BRT ERROR cannot get sl_local_node_id - ERROR:
schema "_solaris.semfio.usp.br" does not exi
st
2008-08-28 15:16:57 BRT FATAL main: Node is not initialized properly -
sleep 10s
2008-08-28 15:16:57 BRT DEBUG2 slon: worker process created - pid = 22751
2008-08-28 15:17:02 BRT DEBUG1 slon: shutdown requested
2008-08-28 15:17:02 BRT DEBUG2 slon: notify worker process to shutdown
2008-08-28 15:17:07 BRT DEBUG2 slon_retry() from pid=22751
2008-08-28 15:17:07 BRT DEBUG1 slon: retry requested
2008-08-28 15:17:07 BRT DEBUG2 slon: notify worker process to shutdown
2008-08-28 15:17:07 BRT FATAL main: write to worker pipe failed -(9)
Bad file descriptor
2008-08-28 15:17:07 BRT DEBUG2 slon: remove pid file
2008-08-28 15:17:07 BRT DEBUG2 slon: exit(-1)
/Then, if some smart guy has implemented yet this service have some
trick or how-to to make it work in my gentoo box, i'll very gratefully.
If have any other method to make a postgresql repliction, like
pgcluster, please talk to me.
Thanks for this time.
Zhu Sha Zang
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAki29QcACgkQbLyL8mxGP9QO1gCgtv29yK1wiXcnGds/y+o4FieR
WpIAnjEyYlGmCnRoOEkBPBJqJjNI1sEF
=IIWx
-----END PGP SIGNATURE-----
_______________________________________________________
Yahoo! Mail - Sempre a melhor opção para você!
Experimente já e veja as novidades.
http://br.yahoo.com/mailbeta/tudonovo/
