📚 [TImeScaleDB] Timescale DB + Postgresql

Category: Postgresql | 📅 May 25, 2021

준비물

잘 설치된 Postgresql

apt list 추가

# `lsb_release -c -s` should return the correct codename of your OS
echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -c -s)-pgdg main" | sudo tee /etc/apt/sources.list.d/pgdg.list
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update

설치하기


# Add our PPA
sudo add-apt-repository ppa:timescale/timescaledb-ppa
sudo apt-get update

# Now install appropriate package for PG version
sudo apt install timescaledb-2-postgresql-13

설정하기

Postgresql이 동작할 때 마다 동작하도록 libraries 에 추가.

sudo timescaledb tune

시작하기


sudo service postgresql restart

References