Postgresql monitoring with zabbix


        
            
                Markdown 0.38 KB
                                    
                        | None                    
                
                                        |
    0    0                            

            
                
                                    raw
                    download
                    clone
                    embed
                    print
                
                                    report
                
                
                            
        
        
            CREATE USER zbx_monitor WITH PASSWORD 'abcd1234' INHERIT;
GRANT pg_monitor TO zbx_monitor;
ALTER USER zbx_monitor WITH SUPERUSER;
pg_hba.conf
host all zbx_monitor 127.0.0.1/32 trust
host all zbx_monitor 0.0.0.0/0 md5
host all zbx_monitor ::0/0 md5
sudo systemctl restart postgresql
psql -h 127.0.0.1 --username=zbx_monitor  postgres