Difference between revisions of "TimescaleDB installation"
Jump to navigation
Jump to search
| (3 intermediate revisions by one other user not shown) | |||
| Line 2: | Line 2: | ||
[[timescaledb-tune --yes]] | [[timescaledb-tune --yes]] | ||
| − | [[sudo -u postgres]] -- bash -c "psql -c 'CREATE database tsdb'" | + | [[sudo -u postgres]] -- bash -c "psql -c '[[CREATE database]] tsdb'" |
sudo -u postgres -- bash -c "psql [[tsdb]] -c '[[CREATE EXTENSION]] IF NOT EXISTS timescaledb;'" | sudo -u postgres -- bash -c "psql [[tsdb]] -c '[[CREATE EXTENSION]] IF NOT EXISTS timescaledb;'" | ||
| − | + | * <code>[[systemctl restart [email protected]]]</code> | |
* <code>[[SELECT * FROM pg_extension;]]</code> | * <code>[[SELECT * FROM pg_extension;]]</code> | ||
| + | * <code>[[CREATE EXTENSION IF NOT EXISTS]] timescaledb CASCADE;</code> | ||
== See also == | == See also == | ||
Latest revision as of 11:52, 11 May 2023
timescaledb-tune --yes sudo -u postgres -- bash -c "psql -c 'CREATE database tsdb'" sudo -u postgres -- bash -c "psql tsdb -c 'CREATE EXTENSION IF NOT EXISTS timescaledb;'"
systemctl restart [email protected]SELECT * FROM pg_extension;CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;
See also[edit]
Advertising:
