【參考文檔】：Zabbix for PostgreSQL部署技術文檔
http://www.postgres.cn/news/viewone/1/280#ch8

基本上所有的配置都是根據(jù)上述文檔完成的，下面是幾點遇到的問題。

pg_monz是一個基于zabbix的postgresql監(jiān)控模板，支持對postgresql多種運行指標進行監(jiān)控，如是否存活，性能，資源。監(jiān)控的類型可以單機，流復制高可用，pgpool-II負載平衡。pg_monz可以獲得postgresql服務長期運行狀態(tài)數(shù)據(jù)，當Postgesql服務出現(xiàn)問題時，可以利用pg_monz來進行恢復。

業(yè)務需求：拉取pgsql（云服務）監(jiān)控數(shù)據(jù)到zabbix

技術選型：通過某臺服務器拉取pgsql監(jiān)控數(shù)據(jù)，再通過zabbix agent將數(shù)據(jù)代理上傳到zabbix server。

技術難點：pgsql為云服務，無法更新配置以配合調(diào)試

遇到問題：pgsql連接鑒權失敗

眾所周知，pgsql數(shù)據(jù)庫連接方式密碼要配置.pgpass，配置在用戶的家目錄下，那么該配置在哪個用戶的家目錄下呢？答案是應該部署在啟動zabbix agent進程用戶的家目錄下。比如zabbix agent進程是通過用戶zabbix啟動的，那么.pgpass文件應當存儲為/home/zabbix/.pgpass

啟動報錯：

21573:20181127:160850.305 error reason for "pg-test-myserver:psql.active_connections[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE}]" changed: Value "Password for user myuser:
21573:20181127:160858.342 error reason for "pg-test-myserver:psql.idle_connections[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE}]" changed: Value "Password for user myuser:
21573:20181127:160858.342 error reason for "pg-test-myserver:psql.idle_tx_connections[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE}]" changed: Value "Password for user myuser:
21571:20181127:160859.335 error reason for "pg-test-myserver:psql.locks_waiting[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE}]" changed: Value "Password for user myuser:
21572:20181127:160903.351 error reason for "pg-test-myserver:psql.server_connections[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE}]" changed: Value "Password for user myuser:
21573:20181127:160904.359 error reason for "pg-test-myserver:psql.server_maxcon[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE}]" changed: Value "Password for user myuser:
21571:20181127:160905.360 error reason for "pg-test-myserver:psql.slow_dml_queries[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE},{$PGSLOWQUERY_THRESHOLD}]" changed: Value "Password for user myuser:
21572:20181127:160906.372 error reason for "pg-test-myserver:psql.slow_queries[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE},{$PGSLOWQUERY_THRESHOLD}]" changed: Value "Password for user myuser:
21572:20181127:164406.994 error reason for "pg-test-myserver:psql.slow_select_queries[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE},{$PGSLOWQUERY_THRESHOLD}]" changed: Value "Password for user myuser:
psql: fe_sendauth: no password supplied" of type "string" is not suitable for value type "Numeric (unsigned)"

問題解決之后會發(fā)現(xiàn)監(jiān)控項入庫成功，日志如下：

21573:20181128:143326.135 item "pg-test-myserver:psql.active_connections[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE}]" became supported
21574:20181128:143334.174 item "pg-test-myserver:psql.idle_connections[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE}]" became supported
21573:20181128:143335.180 item "pg-test-myserver:psql.idle_tx_connections[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE}]" became supported
21572:20181128:143336.183 item "pg-test-myserver:psql.locks_waiting[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE}]" became supported
21573:20181128:143338.202 item "pg-test-myserver:psql.server_connections[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE}]" became supported
21571:20181128:143339.250 item "pg-test-myserver:psql.server_maxcon[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE}]" became supported
21572:20181128:143341.209 item "pg-test-myserver:psql.slow_dml_queries[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE},{$PGSLOWQUERY_THRESHOLD}]" became supported
21573:20181128:143342.221 item "pg-test-myserver:psql.slow_queries[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE},{$PGSLOWQUERY_THRESHOLD}]" became supported
21572:20181128:143343.223 item "pg-test-myserver:psql.slow_select_queries[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE},{$PGSLOWQUERY_THRESHOLD}]" became supported
21573:20181128:143826.513 item "pg-test-myserver:psql.buffers_alloc[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE}]" became supported
21571:20181128:143828.521 item "pg-test-myserver:psql.buffers_backend[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE}]" became supported
21572:20181128:143829.525 item "pg-test-myserver:psql.buffers_backend_fsync[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE}]" became supported
21574:20181128:143830.536 item "pg-test-myserver:psql.buffers_checkpoint[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE}]" became supported
21571:20181128:143831.544 item "pg-test-myserver:psql.buffers_clean[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE}]" became supported
21571:20181128:143831.544 item "pg-test-myserver:psql.checkpoints_req[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE}]" became supported
21573:20181128:143832.538 item "pg-test-myserver:psql.checkpoints_timed[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE}]" became supported
21571:20181128:143837.567 item "pg-test-myserver:psql.maxwritten_clean[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE}]" became supported
21571:20181128:143843.593 item "pg-test-myserver:psql.tx_committed[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE}]" became supported
21574:20181128:143845.599 item "pg-test-myserver:psql.tx_rolledback[{$PGHOST},{$PGPORT},{$PGROLE},{$PGDATABASE}]" became supported`

leeypp@foxmail.com (如果你有疑問，請聯(lián)系我)