Using the PostgreSQL TimescaleDB functionality
TimescaleDB is an open source relational PostgreSQL database extension for time-based series data. Using PostgreSQL TimescaleDB is a solid way to work around using the Zabbix housekeeper to manage your PostgreSQL database. In this recipe, we will go over the installation of PostgreSQL TimescaleDB on a new server and how to set it up with Zabbix.
Getting ready
We will need an empty Linux server. I’ll be using my server called lar-book- postgresql-mgmt.
How to do it…
We have a bit of a different process for RHEL-based and Ubuntu systems, which is why we have split this How to do it… section in two. We will start with Ubuntu systems.
Ubuntu installation
- Let’s log in to our Linux CLI and add the PostgreSQL repo with the following commands:
apt install gnupg postgresql-common apt-transport-https lsb-release wget /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh
- Now, add the TimescaleDB...
