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