FAQ Search Today's Posts Mark Forums Read
» Video Reviews

» Linux Archive

Linux-archive is a website aiming to archive linux email lists and to make them easily accessible for linux users/developers.


» Sponsor

» Partners

» Sponsor

Go Back   Linux Archive > Gentoo > Gentoo User

 
 
LinkBack Thread Tools
 
Old 08-28-2008, 06:57 PM
Zhu Sha Zang
 
Default postgresql replication with slony1

-----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

iEYEARECAAYFAki29QcACgkQbLyL8mxGP9QO1gCgtv29yK1wiX cnGds/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/
 

Thread Tools




All times are GMT. The time now is 10:00 PM.

VBulletin, Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO ©2007, Crawlability, Inc.
Copyright ©2007 - 2008, www.linux-archive.org