Gentoo Archives: gentoo-user

From: Zhu Sha Zang <zhushazang@×××××××××.br>
To: gentoo-user@l.g.o
Subject: [gentoo-user] postgresql replication with slony1
Date: Thu, 28 Aug 2008 18:59:22
Message-Id: 48B6F509.9060200@yahoo.com.br
1 -----BEGIN PGP SIGNED MESSAGE-----
2 Hash: SHA1
3
4 I need know if somebody here has installed/configured a postgresql
5 replication where gentoo is a master host. I'm trying to make it using
6 slony1, but have some mismatch configuration, look:
7 /
8 USER=postgres
9 CLUSTER=slave.host
10 DBUSER=snort
11 DBNAME=snort_log
12 DBHOST=master.host
13
14 LOGFILE=/var/lib/postgresql/data/slony1.log
15 LOGLEVEL=4 # 1(minimum)..4(maximum)/
16
17 I think that the error are in CLUSTER option looking in slony1's log:
18
19 /2008-08-28 15:16:57 BRT CONFIG main: slon version 1.2.10 starting up
20 2008-08-28 15:16:57 BRT DEBUG2 slon: watchdog process started
21 2008-08-28 15:16:57 BRT DEBUG2 slon: watchdog ready - pid = 22743
22 2008-08-28 15:16:57 BRT ERROR cannot get sl_local_node_id - ERROR:
23 schema "_solaris.semfio.usp.br" does not exi
24 st
25 2008-08-28 15:16:57 BRT FATAL main: Node is not initialized properly -
26 sleep 10s
27 2008-08-28 15:16:57 BRT DEBUG2 slon: worker process created - pid = 22751
28 2008-08-28 15:17:02 BRT DEBUG1 slon: shutdown requested
29 2008-08-28 15:17:02 BRT DEBUG2 slon: notify worker process to shutdown
30 2008-08-28 15:17:07 BRT DEBUG2 slon_retry() from pid=22751
31 2008-08-28 15:17:07 BRT DEBUG1 slon: retry requested
32 2008-08-28 15:17:07 BRT DEBUG2 slon: notify worker process to shutdown
33 2008-08-28 15:17:07 BRT FATAL main: write to worker pipe failed -(9)
34 Bad file descriptor
35 2008-08-28 15:17:07 BRT DEBUG2 slon: remove pid file
36 2008-08-28 15:17:07 BRT DEBUG2 slon: exit(-1)
37
38 /Then, if some smart guy has implemented yet this service have some
39 trick or how-to to make it work in my gentoo box, i'll very gratefully.
40
41 If have any other method to make a postgresql repliction, like
42 pgcluster, please talk to me.
43
44 Thanks for this time.
45
46 Zhu Sha Zang
47
48
49 -----BEGIN PGP SIGNATURE-----
50 Version: GnuPG v2.0.9 (GNU/Linux)
51 Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
52
53 iEYEARECAAYFAki29QcACgkQbLyL8mxGP9QO1gCgtv29yK1wiXcnGds/y+o4FieR
54 WpIAnjEyYlGmCnRoOEkBPBJqJjNI1sEF
55 =IIWx
56 -----END PGP SIGNATURE-----
57
58
59
60
61
62
63 _______________________________________________________
64 Yahoo! Mail - Sempre a melhor opção para você!
65 Experimente já e veja as novidades.
66 http://br.yahoo.com/mailbeta/tudonovo/