📚 [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
📖 Please Note that...
  • [digndig]
  • [TimescaleDB - Timeseries database for PostgreSQL]
    • 🏷️ Tags
  • #timescale  
  • #timescaledb  
  • #postgresql