Difference between revisions of "Timescaledb"

From UVOO Tech Wiki
Jump to navigation Jump to search
Line 33: Line 33:
 
apt install timescaledb-2-postgresql-14
 
apt install timescaledb-2-postgresql-14
 
```
 
```
 +
 +
 +
 +
 +
cat timescaledb.sql | psql zabbix

Revision as of 21:18, 23 April 2022

https://docs.timescale.com/install/latest/self-hosted/installation-debian/#install-self-hosted-timescaledb-on-debian-based-systems

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

https://docs.timescale.com/install/latest/self-hosted/installation-debian/#install-self-hosted-timescaledb-on-debian-based-systems

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