Timescaledb
Jump to navigation
Jump to search
https://docs.timescale.com/timescaledb/latest/how-to-guides/hypertables/create/
https://github.com/timescale/timescaledb-kubernetes/tree/master/charts/timescaledb-single
SELECT * FROM timescaledb_information.hypertables;
https://www.zabbix.com/documentation/current/en/manual/appendix/install/timescaledb
git clone https://github.com/timescale/timescaledb-tune.git cd timescaledb-tune/cmd/timescaledb-tune go build main.go sudo chown $USER:$USER main mv main /tmp/timescaledb-tune kubectl -n postgres-dev cp /tmp/timescaledb-tune postgres0-0:/tmp/ kubectl -n postgres-dev exec -it postgres0-0 -- /bin/bash
apt install gnupg postgresql-common apt-transport-https lsb-release wget /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh curl -L https://packagecloud.io/timescale/timescaledb/gpgkey | sudo apt-key add - sh -c "echo 'deb https://packagecloud.io/timescale/timescaledb/debian/ $(lsb_release -c -s) main' > /etc/apt/sources.list.d/timescaledb.list" wget --quiet -O - https://packagecloud.io/timescale/timescaledb/gpgkey | apt-key add - apt update apt install timescaledb-2-postgresql-14
cat timescaledb.sql | psql zabbix