ycFat 2019-10-06 16:07 采纳率: 0%
浏览 443

pgpool 分发问题,一直只连接单个数据库(DB node id: 0 backend)

pgpool.conf 配置文件:
load_balance_mode = on

listen_addresses = '*'
port = 9999

backend_hostname0 = '192.168.1.74'
backend_port0 = 5432
backend_weight0 = 1
backend_data_directory0 = '/www/postgresql/pg_data'
backend_flag0 = 'ALLOW_TO_FAILOVER'

backend_hostname1 = '192.168.1.70'
backend_port1 = 5432
backend_weight1 = 1
backend_data_directory1 = '/www/postgresql/pg_data'
backend_flag1 = 'ALLOW_TO_FAILOVER'

日志:
Oct 6 15:40:55 localhost pgpool[8796]: [312-43] #011 #011LIMIT $3 OFFSET $4"
Oct 6 15:40:55 localhost pgpool[8796]: [313-1] 2019-10-06 15:40:55: pid 8796: LOG: DB node id: 0 backend pid: 8812 statement: Parse: SELECT
Oct 6 15:40:55 localhost pgpool[8796]: [313-2] #011 #011dsca.id, dsca.deletetime, dsca.deleter,
Oct 6 15:40:55 localhost pgpool[8796]: [313-13] #011#011 dsca.is_have_order_reverse isH图片说明

Oct 6 15:40:55 localhost pgpool[8796]: [314-1] 2019-10-06 15:40:55: pid 8796: LOG: Bind message from frontend.
Oct 6 15:40:55 localhost pgpool[8796]: [314-2] 2019-10-06 15:40:55: pid 8796: DETAIL: portal: "", statement: ""
Oct 6 15:40:55 localhost pgpool[8796]: [315-1] 2019-10-06 15:40:55: pid 8796: LOG: DB node id: 0 backend pid: 8812 statement: B message
Oct 6 15:40:55 localhost pgpool[8796]: [316-1] 2019-10-06 15:40:55: pid 8796: LOG: Describe message from frontend.
Oct 6 15:40:55 localhost pgpool[8796]: [316-2] 2019-10-06 15:40:55: pid 8796: DETAIL: portal: ""
Oct 6 15:40:55 localhost pgpool[8796]: [317-1] 2019-10-06 15:40:55: pid 8796: LOG: DB node id: 0 backend pid: 8812 statement: D message
Oct 6 15:40:55 localhost pgpool[8796]: [318-1] 2019-10-06 15:40:55: pid 8796: LOG: Execute message from frontend.
Oct 6 15:40:55 localhost pgpool[8796]: [318-2] 2019-10-06 15:40:55: pid 8796: DETAIL: portal: ""
Oct 6 15:40:55 localhost pgpool[8796]: [319-1] 2019-10-06 15:40:55: pid 8796: LOG: DB node id: 0 backend pid: 8812 statement: Execute: SELECT

如上配置,java程序和navicat通过9999端口去连接,一直都是使用backend_hostname0读取数据,寻找懂pgpool分发的大神,帮忙解决问题。谢谢

  • 写回答

2条回答 默认 最新

  • zqbnqsdsmd 2019-10-06 16:50
    关注
    评论

报告相同问题?

悬赏问题

  • ¥15 安卓adb backup备份应用数据失败
  • ¥15 eclipse运行项目时遇到的问题
  • ¥15 关于#c##的问题:最近需要用CAT工具Trados进行一些开发
  • ¥15 南大pa1 小游戏没有界面,并且报了如下错误,尝试过换显卡驱动,但是好像不行
  • ¥15 没有证书,nginx怎么反向代理到只能接受https的公网网站
  • ¥50 成都蓉城足球俱乐部小程序抢票
  • ¥15 yolov7训练自己的数据集
  • ¥15 esp8266与51单片机连接问题(标签-单片机|关键词-串口)(相关搜索:51单片机|单片机|测试代码)
  • ¥15 电力市场出清matlab yalmip kkt 双层优化问题
  • ¥30 ros小车路径规划实现不了,如何解决?(操作系统-ubuntu)