Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-8923

Add support for PgBouncer database name redirect support

XMLWordPrintable

      i try sets differrent pools size for server and frontend

      root@zabbix-db-01:~# sudo -u postgres createdb -O zabbix zabbix
      ...
      root@zabbix-db-01:~# cat /etc/pgbouncer/zabbix-db.conf
      [databases]
      db_web = dbname=zabbix user=zabbix_web auth_user=postgres pool_size=20
      db_srv = dbname=zabbix user=zabbix_server auth_user=postgres pool_size=5 
      ...

      with psql it works well

      root@zabbix-web-01:~# psql -h 192.168.1.31 -p 6432 -U zabbix_web db_web
      db_web=> \dt
      ...
       public | dashboard_user             | table | zabbix
       public | dashboard_usrgrp           | table | zabbix
       public | dbversion                  | table | zabbix
       public | dchecks                    | table | zabbix
       public | dhosts                     | table | zabbix
      ...
       

      but web setup page report that the table "dbversion" was not found

      if i rename in /etc/pgbouncer/zabbix-db.conf "db_web" to "zabbix" then its work

      [databases]
      ;db_web = dbname=zabbix user=zabbix_web auth_user=postgres pool_size=20 
      zabbix = dbname=zabbix user=zabbix_web auth_user=postgres pool_size=20 

       

            Unassigned Unassigned
            nick.w Nick
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: