Áú»¢¶Ä²©

4 §®§Ú§Ô§â§Ñ§è§Ú§ñ §ß§Ñ TimescaleDB

§°§Ò§Ù§à§â

Áú»¢¶Ä²© §á§à§Õ§Õ§Ö§â§Ø§Ú§Ó§Ñ§Ö§ä TimescaleDB, §â§Ö§ê§Ö§ß§Ú§ñ §ß§Ñ §à§ã§ß§à§Ó§Ö PostgreSQL §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç §Õ§Ý§ñ §Ñ§Ó§ä§à§Þ§Ñ§ä§Ú§é§Ö§ã§Ü§à§Ô§à §á§Ñ§â§ä§Ú§è§Ú§à§ß§Ú§â§à§Ó§Ñ§ß§Ú§ñ §Õ§Ñ§ß§ß§í§ç §ß§Ñ §é§Ñ§ã§ä§Ú §ß§Ñ §à§ã§ß§à§Ó§Ö §Ó§â§Ö§Þ§Ö§ß§Ú §Õ§Ý§ñ §á§à§Õ§Õ§Ö§â§Ø§Ü§Ú §Ò§à§Ý§î§ê§Ö§Ô§à §å§â§à§Ó§ß§ñ §á§â§à§Ú§Ù§Ó§à§Õ§Ú§ä§Ö§Ý§î§ß§à§ã§ä§Ú.

§£ §ï§ä§à§Þ §â§Ñ§Ù§Õ§Ö§Ý§Ö §á§â§Ö§Õ§ã§ä§Ñ§Ó§Ý§Ö§ß§í §ß§Ö§à§Ò§ç§à§Õ§Ú§Þ§í§Ö §ê§Ñ§Ô§Ú §Õ§Ý§ñ §Þ§Ú§Ô§â§Ñ§è§Ú§Ú §ã §ã§å§ë§Ö§ã§ä§Ó§å§ð§ë§Ú§ç §ä§Ñ§Ò§Ý§Ú§è §Ó PostgreSQL §ß§Ñ TimescaleDB.

§¯§Ñ§ã§ä§â§à§Û§Ü§Ñ

§®§í §á§â§Ö§Õ§á§à§Ý§Ñ§Ô§Ñ§Ö§Þ, §é§ä§à TimescaleDB §â§Ñ§ã§ê§Ú§â§Ö§ß§Ú§Ö §å§Ø§Ö §å§ã§ä§Ñ§ß§à§Ó§Ý§Ö§ß§à §Ó §Ò§Ñ§Ù§Ö §Õ§Ñ§ß§ß§í§ç (§ã§Þ§à§ä§â§Ú§ä§Ö ).

TimescaleDB §â§Ñ§ã§ê§Ú§â§Ö§ß§Ú§Ö §ä§Ñ§Ü§Ø§Ö §ß§Ö§à§Ò§ç§à§Õ§Ú§Þ§à §Ó§Ü§Ý§ð§é§Ú§ä§î §Õ§Ý§ñ §à§ä§Õ§Ö§Ý§î§ß§à§Û §¢§¥, §Ó§í§á§à§Ý§ß§Ú§Ó:

echo "CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;" | sudo -u postgres psql zabbix

§¥§Ý§ñ §Ó§í§á§à§Ý§ß§Ö§ß§Ú§ñ §ï§ä§à§Û §Ü§à§Þ§Ñ§ß§Õ§í §á§à§ä§â§Ö§Ò§å§ð§ä§ã§ñ §á§â§Ú§Ó§Ú§Ý§Ö§Ô§Ú§Ú §Ñ§Õ§Þ§Ú§ß§Ú§ã§ä§â§Ñ§ä§à§â§Ñ §Ò§Ñ§Ù§í §Õ§Ñ§ß§ß§í§ç.

§©§Ñ§ä§Ö§Þ §Ó§í§á§à§Ý§ß§Ú§ä§Ö timescaledb.sql §ã§Ü§â§Ú§á§ä, §Ü§à§ä§à§â§í§Û §ß§Ñ§ç§à§Õ§Ú§ä§ã§ñ §Ó database/postgresql:

cat timescaledb.sql | sudo -u zabbix psql zabbix

§®§Ú§Ô§â§Ñ§è§Ú§ñ §ã§å§ë§Ö§ã§ä§Ó§å§ð§ë§Ú§ç §Õ§Ñ§ß§ß§í§ç §Ú§ã§ä§à§â§Ú§Ú §Ú §Õ§Ú§ß§Ñ§Þ§Ú§Ü§Ú §Ú§Ù§Þ§Ö§ß§Ö§ß§Ú§Û §á§à§ä§â§Ö§Ò§å§Ö§ä §Þ§ß§à§Ô§à §Ó§â§Ö§Þ§Ö§ß§Ú. Áú»¢¶Ä²© §ã§Ö§â§Ó§Ö§â §Ú §Ó§Ö§Ò-§Ú§ß§ä§Ö§â§æ§Ö§Û§ã §Õ§à§Ý§Ø§ß§í §Ò§í§ä§î §à§ã§ä§Ñ§ß§à§Ó§Ý§Ö§ß§í §Ó §á§â§à§è§Ö§ã§ã§Ö §Þ§Ú§Ô§â§Ñ§è§Ú§Ú.

§³§Ü§â§Ú§á§ä timescaledb.sql §Ù§Ñ§Õ§Ñ§Ö§ä §ã§Ý§Ö§Õ§å§ð§ë§Ú§Ö §á§Ñ§â§Ñ§Þ§Ö§ä§â§í §á§â§à§è§Ö§ã§ã§å §à§é§Ú§ã§ä§Ü§Ú §Ú§ã§ä§à§â§Ú§Ú (§ã §¡§Õ§Þ§Ú§ß§Ú§ã§ä§â§Ú§â§à§Ó§Ñ§ß§Ú§Ö ¡ú §°§Ò§ë§Ú§Ö ¡ú §°§é§Ú§ã§ä§Ü§Ñ §Ú§ã§ä§à§â§Ú§Ú):

• §±§Ö§â§Ö§à§á§â§Ö§Õ§Ö§Ý§Ú§ä§î §á§Ö§â§Ú§à§Õ §ç§â§Ñ§ß§Ö§ß§Ú§ñ §Ú§ã§ä§à§â§Ú§Ú §ï§Ý§Ö§Þ§Ö§ß§ä§à§Ó §Õ§Ñ§ß§ß§í§ç
• §±§Ö§â§Ö§à§á§â§Ö§Õ§Ö§Ý§Ú§ä§î §á§Ö§â§Ú§à§Õ §ç§â§Ñ§ß§Ö§ß§Ú§ñ §Õ§Ú§ß§Ñ§Þ§Ú§Ü§Ú §Ú§Ù§Þ§Ö§ß§Ö§ß§Ú§ñ §ï§Ý§Ö§Þ§Ö§ß§ä§à§Ó §Õ§Ñ§ß§ß§í§ç

§£ §ã§Ý§å§é§Ñ§Ö §Ú§ã§á§à§Ý§î§Ù§à§Ó§Ñ§ß§Ú§ñ §à§é§Ú§ã§ä§Ü§Ú §Ú§ã§ä§à§â§Ú§Ú §ã §á§Ñ§â§ä§Ú§è§Ú§à§ß§Ú§â§à§Ó§Ñ§ß§Ú§Ö§Þ §Õ§Ý§ñ §Ú§ã§ä§à§â§Ú§Ú §Ú §Õ§Ú§ß§Ñ§Þ§Ú§Ü§Ú §Ú§Ù§Þ§Ö§ß§Ö§ß§Ú§Û §à§Ò§Ö §ï§ä§Ú §à§á§è§Ú§Ú §ß§Ö§à§Ò§ç§à§Õ§Ú§Þ§à §Ñ§Ü§ä§Ú§Ó§Ú§â§à§Ó§Ñ§ä§î. §ª§Þ§Ö§Ö§ä§ã§ñ §Ó§à§Ù§Þ§à§Ø§ß§à§ã§ä§î §Ú§ã§á§à§Ý§î§Ù§à§Ó§Ñ§ß§Ú§ñ TimescaleDB §á§Ñ§â§ä§Ú§è§Ú§à§ß§Ú§â§à§Ó§Ñ§ß§Ú§ñ §ä§à§Ý§î§Ü§à §Õ§Ý§ñ §Õ§Ú§ß§Ñ§Þ§Ú§Ü§Ú §Ú§Ù§Þ§Ö§ß§Ö§ß§Ú§Û (§å§ã§ä§Ñ§ß§à§Ó§Ú§Ó §ß§Ñ§ã§ä§â§à§Û§Ü§å §±§Ö§â§Ö§à§á§â§Ö§Õ§Ö§Ý§Ú§ä§î §á§Ö§â§Ú§à§Õ §ç§â§Ñ§ß§Ö§ß§Ú§ñ §Õ§Ú§ß§Ñ§Þ§Ú§Ü§Ú §Ú§Ù§Þ§Ö§ß§Ö§ß§Ú§ñ §ï§Ý§Ö§Þ§Ö§ß§ä§à§Ó §Õ§Ñ§ß§ß§í§ç) §Ú§Ý§Ú §ä§à§Ý§î§Ü§à §Õ§Ý§ñ §Ú§ã§ä§à§â§Ú§Ú (§±§Ö§â§Ö§à§á§â§Ö§Õ§Ö§Ý§Ú§ä§î §á§Ö§â§Ú§à§Õ §ç§â§Ñ§ß§Ö§ß§Ú§ñ §Ú§ã§ä§à§â§Ú§Ú §ï§Ý§Ö§Þ§Ö§ß§ä§à§Ó §Õ§Ñ§ß§ß§í§ç).