API tools faq
paste
Guest User

Untitled

a guest
Oct 1st, 2018
132
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.27 KB | None | 0 0
raw download clone embed print report
  1. use_watchdog = on
  2. trusted_servers = 'app'
  3. ping_path = '/bin'
  4. wd_ipc_socket_dir = '/var/run/pgpool'
  5. wd_monitoring_interfaces_list = ''
  6. wd_hostname = '172.31.0.7'
  7. wd_port = 9000
  8. wd_authkey = ''
  9.  
  10. delegate_IP = ''
  11. ifconfig_path = '/sbin'
  12. if_up_cmd = 'ifconfig eth0:0 inet $_IP_$ netmask 255.255.255.0'
  13. if_down_cmd = 'ifconfig eth0:0 down'
  14. arping_path = '/usr/sbin'
  15. arping_cmd = 'arping -U $_IP_$ -w 1'
  16. clear_memqcache_on_escalation = on
  17. wd_escalation_command = ''
  18. wd_monitoring_interfaces_list = 'eth0'
  19. wd_lifecheck_method = 'heartbeat'
  20. wd_interval = 10
  21. wd_heartbeat_port = 9694
  22. wd_heartbeat_keepalive = 2
  23. wd_heartbeat_deadtime = 30
  24. heartbeat_destination0 = 'pgpool2'
  25. heartbeat_destination_port0 = 9694
  26. heartbeat_device0 = 'eth0'
  27.  
  28. wd_life_point = 3
  29. wd_lifecheck_query = 'SELECT 1'
  30. wd_lifecheck_dbname = 'template1'
  31. wd_lifecheck_user = 'nobody'
  32. wd_lifecheck_password = ''
  33.  
  34. other_pgpool_hostname0 = 'pgpool2'
  35. other_pgpool_port0 = 5432
  36. other_wd_port0 = 9000
  37.  
  38. use_watchdog = on
  39. trusted_servers = 'srp'
  40. ping_path = '/bin'
  41. wd_ipc_socket_dir = '/var/run/pgpool'
  42. wd_monitoring_interfaces_list = ''
  43. wd_hostname = '172.31.0.9'
  44. wd_port = 9000
  45. wd_authkey = ''
  46. delegate_IP = ''
  47. ifconfig_path = '/sbin'
  48. if_up_cmd = 'ifconfig eth0:0 inet $_IP_$ netmask 255.255.255.0'
  49. if_down_cmd = 'ifconfig eth0:0 down'
  50. arping_path = '/usr/sbin' # arping command path
  51. arping_cmd = 'arping -U $_IP_$ -w 1'
  52. clear_memqcache_on_escalation = on
  53. wd_escalation_command = ''
  54. wd_monitoring_interfaces_list = 'eth0'
  55. wd_lifecheck_method = 'heartbeat'
  56. wd_interval = 10
  57. wd_heartbeat_port = 9694
  58. wd_heartbeat_keepalive = 2
  59. wd_heartbeat_deadtime = 30
  60. heartbeat_destination0 = 'pgpool1'
  61. heartbeat_destination_port0 = 9694
  62. heartbeat_device0 = 'eth0'
  63.  
  64. wd_life_point = 3
  65. wd_lifecheck_query = 'SELECT 1'
  66. wd_lifecheck_dbname = 'template1'
  67. wd_lifecheck_user = 'nobody'
  68. wd_lifecheck_password = ''
  69.  
  70. other_pgpool_hostname0 = 'pgpool1'
  71. other_pgpool_port0 = 5432
  72. other_wd_port0 = 9000
  73.  
  74. services:
  75. ...
  76.  
  77. database:
  78. container_name: "database"
  79. image: postgres:9.5-custom
  80. environment:
  81. - POSTGRES_PASSWORD=password
  82. - PGDATA=/var/lib/postgresql/data/pgdata
  83. volumes:
  84. - '/var/lib/postgresql/data'
  85. expose:
  86. - '5432'
  87. ports:
  88. - '5431:5432'
  89. database-slave:
  90. container_name: "database-slave"
  91. image: postgres:9.5-custom
  92. environment:
  93. - POSTGRES_PASSWORD=password
  94. - PGDATA=/var/lib/postgresql/data/pgdata
  95. - REPLICATE_FROM=database
  96. volumes:
  97. - '/var/lib/postgresql/data'
  98. expose:
  99. - '5432'
  100. ports:
  101. - '5430:5432'
  102. depends_on:
  103. - database
  104. pgpool1:
  105. container_name: "pgpool1"
  106. image: pgpool:latest
  107. depends_on:
  108. - database
  109. environment:
  110. - PGPOOL_BACKENDS=0:database:5432,1:database-slave:5432
  111. - PGPOOL_SR_CHECK_PASSWORD=password
  112. - PGPOOL_POOL_PASSWD_USER=someuser
  113. - PGPOOL_POOL_PASSWD_PASSWORD=password
  114. - PGPOOL_WD_TRUSTED_SERVERS=app
  115. - PGPOOL_OTHER_PGPOOL_HOSTNAMES=0:pgpool2:9000
  116. - PGPOOL_WD_HEARTBEAT_DESTINATIONS=0:pgpool2:eth0
  117. - SLEEP=10
  118. expose:
  119. - '9000'
  120. - '5432'
  121. - '9694'
  122.  
  123. pgpool2:
  124. container_name: "pgpool2"
  125. image: pgpool:latest
  126. depends_on:
  127. - database
  128. environment:
  129. - PGPOOL_BACKENDS=0:database:5432,1:database-slave:5432
  130. - PGPOOL_SR_CHECK_PASSWORD=password
  131. - PGPOOL_POOL_PASSWD_USER=someuser
  132. - PGPOOL_POOL_PASSWD_PASSWORD=password
  133. - PGPOOL_WD_TRUSTED_SERVERS=app
  134. - PGPOOL_OTHER_PGPOOL_HOSTNAMES=0:pgpool1:9000
  135. - PGPOOL_WD_HEARTBEAT_DESTINATIONS=0:pgpool1:eth0
  136. - SLEEP=15
  137. expose:
  138. - '9000'
  139. - '5432'
  140. - '9694'
  141.  
  142. 2018-10-01 18:00:56: pid 21: DEBUG: initializing pool configuration
  143. 2018-10-01 18:00:56: pid 21: DETAIL: num_backends: 2 total_weight: 2.000000
  144. 2018-10-01 18:00:56: pid 21: DEBUG: initializing pool configuration
  145. 2018-10-01 18:00:56: pid 21: DETAIL: backend 0 weight: 1073741823.500000 flag: 0000
  146. 2018-10-01 18:00:56: pid 21: DEBUG: initializing pool configuration
  147. 2018-10-01 18:00:56: pid 21: DETAIL: backend 1 weight: 1073741823.500000 flag: 0000
  148. 2018-10-01 18:00:56: pid 21: DEBUG: loading hba configuration
  149. 2018-10-01 18:00:56: pid 21: DETAIL: loading file :"/etc/pgpool2/pool_hba.conf" for client authentication configuration file
  150. 2018-10-01 18:00:56: pid 21: LOG: Backend status file /var/log/postgresql/pgpool_status does not exist
  151. 2018-10-01 18:00:56: pid 21: DEBUG: pool_coninfo_size: num_init_children (32) * max_pool (4) * MAX_NUM_BACKENDS (128) * sizeof(ConnectionInfo) (136) = 2228224 bytes requested for shared memory
  152. 2018-10-01 18:00:56: pid 21: DEBUG: ProcessInfo: num_init_children (32) * sizeof(ProcessInfo) (32) = 1024 bytes requested for shared memory
  153. 2018-10-01 18:00:56: pid 21: DEBUG: Request info are: sizeof(POOL_REQUEST_INFO) 5304 bytes requested for shared memory
  154. 2018-10-01 18:00:56: pid 21: DEBUG: Recovery management area: sizeof(int) 4 bytes requested for shared memory
  155. 2018-10-01 18:00:56: pid 21: LOG: waiting for watchdog to initialize
  156. 2018-10-01 18:00:56: pid 22: LOG: setting the local watchdog node name to "172.31.0.8:5432 Linux 12affe97a14d"
  157. 2018-10-01 18:00:56: pid 22: LOG: watchdog cluster is configured with 1 remote nodes
  158. 2018-10-01 18:00:56: pid 22: LOG: watchdog remote node:0 on pgpool2:9000
  159. 2018-10-01 18:00:56: pid 22: DEBUG: adding monitoring interface [0] name eth0 index 1950
  160. 2018-10-01 18:00:56: pid 22: INFO: IPC socket path: "/var/run/pgpool/.s.PGPOOLWD_CMD.9000"
  161. 2018-10-01 18:00:56: pid 22: DEBUG: network interface lo having flags 65609
  162. 2018-10-01 18:00:56: pid 22: DEBUG: network interface tunl0 having flags 128
  163. 2018-10-01 18:00:56: pid 22: DEBUG: network interface ip6tnl0 having flags 128
  164. 2018-10-01 18:00:56: pid 22: DEBUG: network interface eth0 having flags 69699
  165. 2018-10-01 18:00:56: pid 22: DEBUG: network interface "eth0" link is active
  166. 2018-10-01 18:00:56: pid 22: DEBUG: network interface "eth0" link is up
  167. 2018-10-01 18:00:56: pid 22: DEBUG: network interface lo having flags 65609
  168. 2018-10-01 18:00:56: pid 22: DEBUG: network interface eth0 having flags 69699
  169. 2018-10-01 18:00:56: pid 22: DEBUG: network interface "eth0" link is active
  170. 2018-10-01 18:00:56: pid 22: DEBUG: network interface "eth0" link is up
  171. 2018-10-01 18:00:56: pid 22: DEBUG: network interface "eth0" is up and we can continue
  172. 2018-10-01 18:00:56: pid 22: LOG: watchdog node state changed from [DEAD] to [LOADING]
  173. 2018-10-01 18:00:56: pid 22: DEBUG: STATE MACHINE INVOKED WITH EVENT = STATE CHANGED Current State = LOADING
  174. 2018-10-01 18:00:56: pid 22: DEBUG: error in outbound connection to pgpool2:9000
  175. 2018-10-01 18:00:56: pid 22: DETAIL: Connection refused
  176. 2018-10-01 18:01:01: pid 22: DEBUG: STATE MACHINE INVOKED WITH EVENT = TIMEOUT Current State = LOADING
  177. 2018-10-01 18:01:01: pid 22: LOG: watchdog node state changed from [LOADING] to [JOINING]
  178. 2018-10-01 18:01:01: pid 22: DEBUG: STATE MACHINE INVOKED WITH EVENT = STATE CHANGED Current State = JOINING
  179. 2018-10-01 18:01:01: pid 22: DEBUG: error in outbound connection to pgpool2:9000
  180. 2018-10-01 18:01:01: pid 22: DETAIL: Connection refused
  181. 2018-10-01 18:01:01: pid 22: LOG: new watchdog node connection is received from "172.31.0.9:27844"
  182. 2018-10-01 18:01:01: pid 22: DEBUG: received watchdog packet type:A
  183. 2018-10-01 18:01:01: pid 22: DEBUG: reading packet type A of length 242
  184. 2018-10-01 18:01:01: pid 22: DEBUG: ADD NODE MESSAGE from hostname:"172.31.0.9" port:9000 pgpool_port:5432
  185. 2018-10-01 18:01:01: pid 22: NOTICE: add node from hostname:"172.31.0.9" port:9000 pgpool_port:5432 rejected.
  186. 2018-10-01 18:01:01: pid 22: DETAIL: verify the other watchdog node configurations
  187. 2018-10-01 18:01:01: pid 22: DEBUG: sending packet, watchdog node:[�
  188. WaVU] command id:[4] type:[REJECT] state:[JOINING]
  189. 2018-10-01 18:01:01: pid 22: DEBUG: sending watchdog packet to socket:7, type:[R], command ID:4, data Length:0
  190.  
  191. 2018-10-01 18:01:01: pid 21: DEBUG: initializing pool configuration
  192. 2018-10-01 18:01:01: pid 21: DETAIL: num_backends: 2 total_weight: 2.000000
  193. 2018-10-01 18:01:01: pid 21: DEBUG: initializing pool configuration
  194. 2018-10-01 18:01:01: pid 21: DETAIL: backend 0 weight: 1073741823.500000 flag: 0000
  195. 2018-10-01 18:01:01: pid 21: DEBUG: initializing pool configuration
  196. 2018-10-01 18:01:01: pid 21: DETAIL: backend 1 weight: 1073741823.500000 flag: 0000
  197. 2018-10-01 18:01:01: pid 21: DEBUG: loading hba configuration
  198. 2018-10-01 18:01:01: pid 21: DETAIL: loading file :"/etc/pgpool2/pool_hba.conf" for client authentication configuration file
  199. 2018-10-01 18:01:01: pid 21: LOG: Backend status file /var/log/postgresql/pgpool_status does not exist
  200. 2018-10-01 18:01:01: pid 21: DEBUG: pool_coninfo_size: num_init_children (32) * max_pool (4) * MAX_NUM_BACKENDS (128) * sizeof(ConnectionInfo) (136) = 2228224 bytes requested for shared memory
  201. 2018-10-01 18:01:01: pid 21: DEBUG: ProcessInfo: num_init_children (32) * sizeof(ProcessInfo) (32) = 1024 bytes requested for shared memory
  202. 2018-10-01 18:01:01: pid 21: DEBUG: Request info are: sizeof(POOL_REQUEST_INFO) 5304 bytes requested for shared memory
  203. 2018-10-01 18:01:01: pid 21: DEBUG: Recovery management area: sizeof(int) 4 bytes requested for shared memory
  204. 2018-10-01 18:01:01: pid 21: LOG: waiting for watchdog to initialize
  205. 2018-10-01 18:01:01: pid 22: LOG: setting the local watchdog node name to "172.31.0.9:5432 Linux b251a3a36756"
  206. 2018-10-01 18:01:01: pid 22: LOG: watchdog cluster is configured with 1 remote nodes
  207. 2018-10-01 18:01:01: pid 22: LOG: watchdog remote node:0 on pgpool1:9000
  208. 2018-10-01 18:01:01: pid 22: DEBUG: adding monitoring interface [0] name eth0 index 1952
  209. 2018-10-01 18:01:01: pid 22: INFO: IPC socket path: "/var/run/pgpool/.s.PGPOOLWD_CMD.9000"
  210. 2018-10-01 18:01:01: pid 22: DEBUG: network interface lo having flags 65609
  211. 2018-10-01 18:01:01: pid 22: DEBUG: network interface tunl0 having flags 128
  212. 2018-10-01 18:01:01: pid 22: DEBUG: network interface ip6tnl0 having flags 128
  213. 2018-10-01 18:01:01: pid 22: DEBUG: network interface eth0 having flags 69699
  214. 2018-10-01 18:01:01: pid 22: DEBUG: network interface "eth0" link is active
  215. 2018-10-01 18:01:01: pid 22: DEBUG: network interface "eth0" link is up
  216. 2018-10-01 18:01:01: pid 22: DEBUG: network interface lo having flags 65609
  217. 2018-10-01 18:01:01: pid 22: DEBUG: network interface eth0 having flags 69699
  218. 2018-10-01 18:01:01: pid 22: DEBUG: network interface "eth0" link is active
  219. 2018-10-01 18:01:01: pid 22: DEBUG: network interface "eth0" link is up
  220. 2018-10-01 18:01:01: pid 22: DEBUG: network interface "eth0" is up and we can continue
  221. 2018-10-01 18:01:01: pid 22: LOG: watchdog node state changed from [DEAD] to [LOADING]
  222. 2018-10-01 18:01:01: pid 22: DEBUG: STATE MACHINE INVOKED WITH EVENT = STATE CHANGED Current State = LOADING
  223. 2018-10-01 18:01:01: pid 22: LOG: new outbound connection to pgpool1:9000
  224. 2018-10-01 18:01:01: pid 22: DEBUG: STATE MACHINE INVOKED WITH EVENT = NEW OUTBOUND_CONNECTION Current State = LOADING
  225. 2018-10-01 18:01:01: pid 22: DEBUG: sending packet, watchdog node:[] command id:[4] type:[ADD NODE] state:[LOADING]
  226. 2018-10-01 18:01:01: pid 22: DEBUG: sending watchdog packet to socket:7, type:[A], command ID:4, data Length:242
  227. 2018-10-01 18:01:01: pid 22: DEBUG: received watchdog packet type:R
  228. 2018-10-01 18:01:01: pid 22: DEBUG: reading packet type R of length 0
  229. 2018-10-01 18:01:01: pid 22: DEBUG: STATE MACHINE INVOKED WITH EVENT = PACKET RECEIVED Current State = LOADING
  230. 2018-10-01 18:01:01: pid 22: DEBUG: received packet, watchdog node:[] command id:[4] type:[REJECT] state:[LOADING]
  231. 2018-10-01 18:01:01: pid 22: FATAL: Add to watchdog cluster request is rejected by node "pgpool1:9000"
  232. 2018-10-01 18:01:01: pid 22: HINT: check the watchdog configurations.
  233. 2018-10-01 18:01:01: pid 22: LOG: Watchdog is shutting down
  234. 2018-10-01 18:01:01: pid 21: DEBUG: reaper handler
  235. 2018-10-01 18:01:01: pid 21: DEBUG: watchdog child process with pid: 22 exit with FATAL ERROR. pgpool-II will be shutdown
  236. 2018-10-01 18:01:01: pid 21: LOG: watchdog child process with pid: 22 exits with status 768
  237. 2018-10-01 18:01:01: pid 21: FATAL: watchdog child process exit with fatal error. exiting pgpool-II
  238. 2018-10-01 18:01:01: pid 23: LOG: setting the local watchdog node name to "172.31.0.9:5432 Linux b251a3a36756"
  239. 2018-10-01 18:01:01: pid 23: LOG: watchdog cluster is configured with 1 remote nodes
  240. 2018-10-01 18:01:01: pid 23: LOG: watchdog remote node:0 on pgpool1:9000
  241. 2018-10-01 18:01:01: pid 23: DEBUG: adding monitoring interface [0] name eth0 index 1952
  242. 2018-10-01 18:01:01: pid 23: INFO: IPC socket path: "/var/run/pgpool/.s.PGPOOLWD_CMD.9000"
  243. 2018-10-01 18:01:01: pid 23: DEBUG: network interface lo having flags 65609
  244. 2018-10-01 18:01:01: pid 23: DEBUG: network interface tunl0 having flags 128
  245. 2018-10-01 18:01:01: pid 23: DEBUG: network interface ip6tnl0 having flags 128
  246. 2018-10-01 18:01:01: pid 23: DEBUG: network interface eth0 having flags 69699
  247. 2018-10-01 18:01:01: pid 23: DEBUG: network interface "eth0" link is active
  248. 2018-10-01 18:01:01: pid 23: DEBUG: network interface "eth0" link is up
  249. 2018-10-01 18:01:01: pid 23: DEBUG: network interface lo having flags 65609
  250. 2018-10-01 18:01:01: pid 23: DEBUG: network interface eth0 having flags 69699
  251. 2018-10-01 18:01:01: pid 23: DEBUG: network interface "eth0" link is active
  252. 2018-10-01 18:01:01: pid 23: DEBUG: network interface "eth0" link is up
  253. 2018-10-01 18:01:01: pid 23: DEBUG: network interface "eth0" is up and we can continue
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!