Difference between revisions of "TimescaleDB"
Jump to navigation
Jump to search
(→Errors) |
|||
| (5 intermediate revisions by 2 users not shown) | |||
| Line 9: | Line 9: | ||
* <code>[[brew install timescaledb]]</code> | * <code>[[brew install timescaledb]]</code> | ||
* Status: <code>[[systemctl status postgresql@14-main]]</code> | * Status: <code>[[systemctl status postgresql@14-main]]</code> | ||
| + | * Configuration: <code>[[postgresql.conf]]</code> | ||
== Binaries == | == Binaries == | ||
| Line 14: | Line 15: | ||
* <code>[[timescaledb_move.sh]]</code> | * <code>[[timescaledb_move.sh]]</code> | ||
* <code>[[timescaledb-parallel-copy]]</code> | * <code>[[timescaledb-parallel-copy]]</code> | ||
| + | |||
| + | == Errors == | ||
| + | [[ERROR: could not access file]] "$libdir/timescaledb-2.10.3": [[No such file or directory]] | ||
| + | ERROR [[#58P01]] could not access file "$libdir/timescaledb-2.10.3": No such file or directory. Retrying... | ||
== Related == | == Related == | ||
| Line 19: | Line 24: | ||
* [[Data partitioning]] | * [[Data partitioning]] | ||
* [[Hypertable]]: <code>[[create_hypertable]]</code> | * [[Hypertable]]: <code>[[create_hypertable]]</code> | ||
| + | * <code>[[CREATE EXTENSION]] timescaledb;</code> | ||
* [[Timescale Cloud]] | * [[Timescale Cloud]] | ||
| − | |||
* [[TimescaleDB versions]] | * [[TimescaleDB versions]] | ||
| − | * [[Port]]: | + | * [[Port]]: [[5432]], [[7432]] |
| − | + | ||
* <code>[[SELECT * FROM timescaledb information.hypertables WHERE hypertable name = 'data']]</code> | * <code>[[SELECT * FROM timescaledb information.hypertables WHERE hypertable name = 'data']]</code> | ||
Latest revision as of 08:54, 1 June 2023
wikipedia:TimescaleDB (Nov 2018) is an open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
- https://www.timescale.com/
- Michael J. Freedman
- https://trends.google.com/trends/explore?date=all&q=TimescaleDB,InfluxDB
Contents
Installation[edit]
- TimescaleDB installation
brew tap timescale/tapbrew install timescaledb- Status:
systemctl status postgresql@14-main - Configuration:
postgresql.conf
Binaries[edit]
Errors[edit]
ERROR: could not access file "$libdir/timescaledb-2.10.3": No such file or directory ERROR #58P01 could not access file "$libdir/timescaledb-2.10.3": No such file or directory. Retrying...
Related[edit]
- InfluxDB (2013)
- Data partitioning
- Hypertable:
create_hypertable CREATE EXTENSION timescaledb;- Timescale Cloud
- TimescaleDB versions
- Port: 5432, 7432
See also[edit]
Advertising:
