Добрый день, коллеги!
У меня установлено:
- zabbix-server версии 5.0.11
- postgresql версии psql (PostgreSQL) 13.1 (Debian 13.1-1.pgdg100+1), но с кластером:
От этого очень сильно распухает база данных zabbix.
Подскажите обязательно ли устанавливать расширение TimescaleDB? Если да, то при установке не сломаю ли я существующую БД? Если нет, то прошу подсказать, как настроить периодическую очистку истории с участием только postgresql без установки расширения TimescaleDB?
Заранее благодарен.
У меня установлено:
- zabbix-server версии 5.0.11
- postgresql версии psql (PostgreSQL) 13.1 (Debian 13.1-1.pgdg100+1), но с кластером:
Ver Cluster Port Status Owner Data directory Log file
12 main 5432 online postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log
12 main 5432 online postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log
У меня в логах postgresql сыпятся ошибки:
2022-07-05 16:41:04.465 +10 [11544] zabbix@zabbix ERROR: function drop_chunks(table_name => unknown, older_than => integer) does not exist at character 8
2022-07-05 16:41:04.465 +10 [11544] zabbix@zabbix HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2022-07-05 16:41:04.465 +10 [11544] zabbix@zabbix STATEMENT: select drop_chunks(table_name=>'history',older_than=>1656 830464)
2022-07-05 16:41:04.465 +10 [11544] zabbix@zabbix ERROR: function drop_chunks(table_name => unknown, older_than => integer) does not exist at character 8
2022-07-05 16:41:04.465 +10 [11544] zabbix@zabbix HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2022-07-05 16:41:04.465 +10 [11544] zabbix@zabbix STATEMENT: select drop_chunks(table_name=>'history_str',older_than=> 1656830464)
2022-07-05 16:41:04.466 +10 [11544] zabbix@zabbix ERROR: function drop_chunks(table_name => unknown, older_than => integer) does not exist at character 8
2022-07-05 16:41:04.466 +10 [11544] zabbix@zabbix HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2022-07-05 16:41:04.466 +10 [11544] zabbix@zabbix STATEMENT: select drop_chunks(table_name=>'history_log',older_than=> 1656830464)
2022-07-05 16:41:04.466 +10 [11544] zabbix@zabbix ERROR: function drop_chunks(table_name => unknown, older_than => integer) does not exist at character 8
2022-07-05 16:41:04.466 +10 [11544] zabbix@zabbix HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2022-07-05 16:41:04.466 +10 [11544] zabbix@zabbix STATEMENT: select drop_chunks(table_name=>'history_uint',older_than= >1656830464)
2022-07-05 16:41:04.466 +10 [11544] zabbix@zabbix ERROR: function drop_chunks(table_name => unknown, older_than => integer) does not exist at character 8
2022-07-05 16:41:04.466 +10 [11544] zabbix@zabbix HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2022-07-05 16:41:04.466 +10 [11544] zabbix@zabbix STATEMENT: select drop_chunks(table_name=>'history_text',older_than= >1656830464)
2022-07-05 16:41:04.465 +10 [11544] zabbix@zabbix ERROR: function drop_chunks(table_name => unknown, older_than => integer) does not exist at character 8
2022-07-05 16:41:04.465 +10 [11544] zabbix@zabbix HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2022-07-05 16:41:04.465 +10 [11544] zabbix@zabbix STATEMENT: select drop_chunks(table_name=>'history',older_than=>1656 830464)
2022-07-05 16:41:04.465 +10 [11544] zabbix@zabbix ERROR: function drop_chunks(table_name => unknown, older_than => integer) does not exist at character 8
2022-07-05 16:41:04.465 +10 [11544] zabbix@zabbix HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2022-07-05 16:41:04.465 +10 [11544] zabbix@zabbix STATEMENT: select drop_chunks(table_name=>'history_str',older_than=> 1656830464)
2022-07-05 16:41:04.466 +10 [11544] zabbix@zabbix ERROR: function drop_chunks(table_name => unknown, older_than => integer) does not exist at character 8
2022-07-05 16:41:04.466 +10 [11544] zabbix@zabbix HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2022-07-05 16:41:04.466 +10 [11544] zabbix@zabbix STATEMENT: select drop_chunks(table_name=>'history_log',older_than=> 1656830464)
2022-07-05 16:41:04.466 +10 [11544] zabbix@zabbix ERROR: function drop_chunks(table_name => unknown, older_than => integer) does not exist at character 8
2022-07-05 16:41:04.466 +10 [11544] zabbix@zabbix HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2022-07-05 16:41:04.466 +10 [11544] zabbix@zabbix STATEMENT: select drop_chunks(table_name=>'history_uint',older_than= >1656830464)
2022-07-05 16:41:04.466 +10 [11544] zabbix@zabbix ERROR: function drop_chunks(table_name => unknown, older_than => integer) does not exist at character 8
2022-07-05 16:41:04.466 +10 [11544] zabbix@zabbix HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2022-07-05 16:41:04.466 +10 [11544] zabbix@zabbix STATEMENT: select drop_chunks(table_name=>'history_text',older_than= >1656830464)
Подскажите обязательно ли устанавливать расширение TimescaleDB? Если да, то при установке не сломаю ли я существующую БД? Если нет, то прошу подсказать, как настроить периодическую очистку истории с участием только postgresql без установки расширения TimescaleDB?
Заранее благодарен.