Extensions
timeseries

timeseries

pg_timeseries : Convenience API for time series stack

Overview

IDExtensionPackageVersionCategoryLicenseLanguage
1020
timeseries
pg_timeseries
0.1.7
TIME
PostgreSQL
SQL
AttributeHas BinaryHas LibraryNeed LoadHas DDLRelocatableTrusted
----d--
No
No
No
Yes
no
no
Relationships
Requires
columnar
pg_cron
pg_ivm
pg_partman
See Also
timescaledb
timescaledb_toolkit
periods
temporal_tables
emaj
table_version
pg_task
pg_later

unmet deps: hydra17 not ready, pg_partman17/pg_ivm12 on el not ready, 0.1.7 break, pg18 break

Packages

TypeRepoVersionPG Major CompatibilityPackage PatternDependencies
EXT
PIGSTY
0.1.7
18
17
16
15
14
13
pg_timeseries-
RPM
PIGSTY
0.1.7
18
17
16
15
14
13
pg_timeseries_$vhydra_$v, pg_cron_$v, pg_ivm_$v, pg_partman_$v
DEB
PIGSTY
0.1.7
18
17
16
15
14
13
postgresql-$v-pg-timeseries-
Linux / PGPG18PG17PG16PG15PG14PG13
el8.x86_64
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
el8.aarch64
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
el9.x86_64
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
el9.aarch64
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
el10.x86_64
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
el10.aarch64
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
d12.x86_64
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
d12.aarch64
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
d13.x86_64
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
d13.aarch64
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
u22.x86_64
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
u22.aarch64
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
u24.x86_64
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
u24.aarch64
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PIGSTY 0.1.7
PackageVersionOSORGSIZEFile URL
pg_timeseries_180.1.7el8.x86_64pigsty27.8 KiBpg_timeseries_18-0.1.7-1PIGSTY.el8.x86_64.rpm
pg_timeseries_180.1.7el8.aarch64pigsty27.8 KiBpg_timeseries_18-0.1.7-1PIGSTY.el8.aarch64.rpm
pg_timeseries_180.1.7el9.x86_64pigsty27.4 KiBpg_timeseries_18-0.1.7-1PIGSTY.el9.x86_64.rpm
pg_timeseries_180.1.7el9.aarch64pigsty27.4 KiBpg_timeseries_18-0.1.7-1PIGSTY.el9.aarch64.rpm
pg_timeseries_180.1.7el10.x86_64pigsty27.6 KiBpg_timeseries_18-0.1.7-1PIGSTY.el10.x86_64.rpm
pg_timeseries_180.1.7el10.aarch64pigsty27.6 KiBpg_timeseries_18-0.1.7-1PIGSTY.el10.aarch64.rpm
postgresql-18-pg-timeseries0.1.7d12.x86_64pigsty23.4 KiBpostgresql-18-pg-timeseries_0.1.7-1PIGSTY~bookworm_amd64.deb
postgresql-18-pg-timeseries0.1.7d12.aarch64pigsty23.4 KiBpostgresql-18-pg-timeseries_0.1.7-1PIGSTY~bookworm_arm64.deb
postgresql-18-pg-timeseries0.1.7d13.x86_64pigsty23.4 KiBpostgresql-18-pg-timeseries_0.1.7-1PIGSTY~trixie_amd64.deb
postgresql-18-pg-timeseries0.1.7d13.aarch64pigsty23.4 KiBpostgresql-18-pg-timeseries_0.1.7-1PIGSTY~trixie_arm64.deb
postgresql-18-pg-timeseries0.1.7u22.x86_64pigsty23.8 KiBpostgresql-18-pg-timeseries_0.1.7-1PIGSTY~jammy_amd64.deb
postgresql-18-pg-timeseries0.1.7u22.aarch64pigsty23.8 KiBpostgresql-18-pg-timeseries_0.1.7-1PIGSTY~jammy_arm64.deb
postgresql-18-pg-timeseries0.1.7u24.x86_64pigsty23.8 KiBpostgresql-18-pg-timeseries_0.1.7-1PIGSTY~noble_amd64.deb
postgresql-18-pg-timeseries0.1.7u24.aarch64pigsty23.8 KiBpostgresql-18-pg-timeseries_0.1.7-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pg_timeseries_170.1.7el8.x86_64pigsty27.8 KiBpg_timeseries_17-0.1.7-1PIGSTY.el8.x86_64.rpm
pg_timeseries_170.1.7el8.aarch64pigsty27.8 KiBpg_timeseries_17-0.1.7-1PIGSTY.el8.aarch64.rpm
pg_timeseries_170.1.7el9.x86_64pigsty27.4 KiBpg_timeseries_17-0.1.7-1PIGSTY.el9.x86_64.rpm
pg_timeseries_170.1.7el9.aarch64pigsty27.4 KiBpg_timeseries_17-0.1.7-1PIGSTY.el9.aarch64.rpm
pg_timeseries_170.1.7el10.x86_64pigsty27.6 KiBpg_timeseries_17-0.1.7-1PIGSTY.el10.x86_64.rpm
pg_timeseries_170.1.7el10.aarch64pigsty27.6 KiBpg_timeseries_17-0.1.7-1PIGSTY.el10.aarch64.rpm
postgresql-17-pg-timeseries0.1.7d12.x86_64pigsty23.4 KiBpostgresql-17-pg-timeseries_0.1.7-1PIGSTY~bookworm_amd64.deb
postgresql-17-pg-timeseries0.1.7d12.aarch64pigsty23.4 KiBpostgresql-17-pg-timeseries_0.1.7-1PIGSTY~bookworm_arm64.deb
postgresql-17-pg-timeseries0.1.7d13.x86_64pigsty23.4 KiBpostgresql-17-pg-timeseries_0.1.7-1PIGSTY~trixie_amd64.deb
postgresql-17-pg-timeseries0.1.7d13.aarch64pigsty23.4 KiBpostgresql-17-pg-timeseries_0.1.7-1PIGSTY~trixie_arm64.deb
postgresql-17-pg-timeseries0.1.7u22.x86_64pigsty23.8 KiBpostgresql-17-pg-timeseries_0.1.7-1PIGSTY~jammy_amd64.deb
postgresql-17-pg-timeseries0.1.7u22.aarch64pigsty23.8 KiBpostgresql-17-pg-timeseries_0.1.7-1PIGSTY~jammy_arm64.deb
postgresql-17-pg-timeseries0.1.7u24.x86_64pigsty23.8 KiBpostgresql-17-pg-timeseries_0.1.7-1PIGSTY~noble_amd64.deb
postgresql-17-pg-timeseries0.1.7u24.aarch64pigsty23.8 KiBpostgresql-17-pg-timeseries_0.1.7-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pg_timeseries_160.1.7el8.x86_64pigsty27.8 KiBpg_timeseries_16-0.1.7-1PIGSTY.el8.x86_64.rpm
pg_timeseries_160.1.7el8.aarch64pigsty27.8 KiBpg_timeseries_16-0.1.7-1PIGSTY.el8.aarch64.rpm
pg_timeseries_160.1.7el9.x86_64pigsty27.4 KiBpg_timeseries_16-0.1.7-1PIGSTY.el9.x86_64.rpm
pg_timeseries_160.1.7el9.aarch64pigsty27.4 KiBpg_timeseries_16-0.1.7-1PIGSTY.el9.aarch64.rpm
pg_timeseries_160.1.7el10.x86_64pigsty27.6 KiBpg_timeseries_16-0.1.7-1PIGSTY.el10.x86_64.rpm
pg_timeseries_160.1.7el10.aarch64pigsty27.6 KiBpg_timeseries_16-0.1.7-1PIGSTY.el10.aarch64.rpm
postgresql-16-pg-timeseries0.1.7d12.x86_64pigsty23.4 KiBpostgresql-16-pg-timeseries_0.1.7-1PIGSTY~bookworm_amd64.deb
postgresql-16-pg-timeseries0.1.7d12.aarch64pigsty23.4 KiBpostgresql-16-pg-timeseries_0.1.7-1PIGSTY~bookworm_arm64.deb
postgresql-16-pg-timeseries0.1.7d13.x86_64pigsty23.4 KiBpostgresql-16-pg-timeseries_0.1.7-1PIGSTY~trixie_amd64.deb
postgresql-16-pg-timeseries0.1.7d13.aarch64pigsty23.4 KiBpostgresql-16-pg-timeseries_0.1.7-1PIGSTY~trixie_arm64.deb
postgresql-16-pg-timeseries0.1.7u22.x86_64pigsty23.8 KiBpostgresql-16-pg-timeseries_0.1.7-1PIGSTY~jammy_amd64.deb
postgresql-16-pg-timeseries0.1.7u22.aarch64pigsty23.8 KiBpostgresql-16-pg-timeseries_0.1.7-1PIGSTY~jammy_arm64.deb
postgresql-16-pg-timeseries0.1.7u24.x86_64pigsty23.8 KiBpostgresql-16-pg-timeseries_0.1.7-1PIGSTY~noble_amd64.deb
postgresql-16-pg-timeseries0.1.7u24.aarch64pigsty23.8 KiBpostgresql-16-pg-timeseries_0.1.7-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pg_timeseries_150.1.7el8.x86_64pigsty27.8 KiBpg_timeseries_15-0.1.7-1PIGSTY.el8.x86_64.rpm
pg_timeseries_150.1.7el8.aarch64pigsty27.8 KiBpg_timeseries_15-0.1.7-1PIGSTY.el8.aarch64.rpm
pg_timeseries_150.1.7el9.x86_64pigsty27.4 KiBpg_timeseries_15-0.1.7-1PIGSTY.el9.x86_64.rpm
pg_timeseries_150.1.7el9.aarch64pigsty27.4 KiBpg_timeseries_15-0.1.7-1PIGSTY.el9.aarch64.rpm
pg_timeseries_150.1.7el10.x86_64pigsty27.6 KiBpg_timeseries_15-0.1.7-1PIGSTY.el10.x86_64.rpm
pg_timeseries_150.1.7el10.aarch64pigsty27.6 KiBpg_timeseries_15-0.1.7-1PIGSTY.el10.aarch64.rpm
postgresql-15-pg-timeseries0.1.7d12.x86_64pigsty23.4 KiBpostgresql-15-pg-timeseries_0.1.7-1PIGSTY~bookworm_amd64.deb
postgresql-15-pg-timeseries0.1.7d12.aarch64pigsty23.4 KiBpostgresql-15-pg-timeseries_0.1.7-1PIGSTY~bookworm_arm64.deb
postgresql-15-pg-timeseries0.1.7d13.x86_64pigsty23.4 KiBpostgresql-15-pg-timeseries_0.1.7-1PIGSTY~trixie_amd64.deb
postgresql-15-pg-timeseries0.1.7d13.aarch64pigsty23.4 KiBpostgresql-15-pg-timeseries_0.1.7-1PIGSTY~trixie_arm64.deb
postgresql-15-pg-timeseries0.1.7u22.x86_64pigsty23.8 KiBpostgresql-15-pg-timeseries_0.1.7-1PIGSTY~jammy_amd64.deb
postgresql-15-pg-timeseries0.1.7u22.aarch64pigsty23.8 KiBpostgresql-15-pg-timeseries_0.1.7-1PIGSTY~jammy_arm64.deb
postgresql-15-pg-timeseries0.1.7u24.x86_64pigsty23.8 KiBpostgresql-15-pg-timeseries_0.1.7-1PIGSTY~noble_amd64.deb
postgresql-15-pg-timeseries0.1.7u24.aarch64pigsty23.8 KiBpostgresql-15-pg-timeseries_0.1.7-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pg_timeseries_140.1.7el8.x86_64pigsty27.8 KiBpg_timeseries_14-0.1.7-1PIGSTY.el8.x86_64.rpm
pg_timeseries_140.1.7el8.aarch64pigsty27.8 KiBpg_timeseries_14-0.1.7-1PIGSTY.el8.aarch64.rpm
pg_timeseries_140.1.7el9.x86_64pigsty27.4 KiBpg_timeseries_14-0.1.7-1PIGSTY.el9.x86_64.rpm
pg_timeseries_140.1.7el9.aarch64pigsty27.4 KiBpg_timeseries_14-0.1.7-1PIGSTY.el9.aarch64.rpm
pg_timeseries_140.1.7el10.x86_64pigsty27.6 KiBpg_timeseries_14-0.1.7-1PIGSTY.el10.x86_64.rpm
pg_timeseries_140.1.7el10.aarch64pigsty27.6 KiBpg_timeseries_14-0.1.7-1PIGSTY.el10.aarch64.rpm
postgresql-14-pg-timeseries0.1.7d12.x86_64pigsty23.4 KiBpostgresql-14-pg-timeseries_0.1.7-1PIGSTY~bookworm_amd64.deb
postgresql-14-pg-timeseries0.1.7d12.aarch64pigsty23.4 KiBpostgresql-14-pg-timeseries_0.1.7-1PIGSTY~bookworm_arm64.deb
postgresql-14-pg-timeseries0.1.7d13.x86_64pigsty23.4 KiBpostgresql-14-pg-timeseries_0.1.7-1PIGSTY~trixie_amd64.deb
postgresql-14-pg-timeseries0.1.7d13.aarch64pigsty23.4 KiBpostgresql-14-pg-timeseries_0.1.7-1PIGSTY~trixie_arm64.deb
postgresql-14-pg-timeseries0.1.7u22.x86_64pigsty23.8 KiBpostgresql-14-pg-timeseries_0.1.7-1PIGSTY~jammy_amd64.deb
postgresql-14-pg-timeseries0.1.7u22.aarch64pigsty23.8 KiBpostgresql-14-pg-timeseries_0.1.7-1PIGSTY~jammy_arm64.deb
postgresql-14-pg-timeseries0.1.7u24.x86_64pigsty23.8 KiBpostgresql-14-pg-timeseries_0.1.7-1PIGSTY~noble_amd64.deb
postgresql-14-pg-timeseries0.1.7u24.aarch64pigsty23.8 KiBpostgresql-14-pg-timeseries_0.1.7-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pg_timeseries_130.1.7el8.x86_64pigsty27.8 KiBpg_timeseries_13-0.1.7-1PIGSTY.el8.x86_64.rpm
pg_timeseries_130.1.7el8.aarch64pigsty27.8 KiBpg_timeseries_13-0.1.7-1PIGSTY.el8.aarch64.rpm
pg_timeseries_130.1.7el9.x86_64pigsty27.4 KiBpg_timeseries_13-0.1.7-1PIGSTY.el9.x86_64.rpm
pg_timeseries_130.1.7el9.aarch64pigsty27.4 KiBpg_timeseries_13-0.1.7-1PIGSTY.el9.aarch64.rpm
pg_timeseries_130.1.7el10.x86_64pigsty27.6 KiBpg_timeseries_13-0.1.7-1PIGSTY.el10.x86_64.rpm
pg_timeseries_130.1.7el10.aarch64pigsty27.6 KiBpg_timeseries_13-0.1.7-1PIGSTY.el10.aarch64.rpm
postgresql-13-pg-timeseries0.1.7d12.x86_64pigsty23.4 KiBpostgresql-13-pg-timeseries_0.1.7-1PIGSTY~bookworm_amd64.deb
postgresql-13-pg-timeseries0.1.7d12.aarch64pigsty23.4 KiBpostgresql-13-pg-timeseries_0.1.7-1PIGSTY~bookworm_arm64.deb
postgresql-13-pg-timeseries0.1.7d13.x86_64pigsty23.4 KiBpostgresql-13-pg-timeseries_0.1.7-1PIGSTY~trixie_amd64.deb
postgresql-13-pg-timeseries0.1.7d13.aarch64pigsty23.4 KiBpostgresql-13-pg-timeseries_0.1.7-1PIGSTY~trixie_arm64.deb
postgresql-13-pg-timeseries0.1.7u22.x86_64pigsty23.8 KiBpostgresql-13-pg-timeseries_0.1.7-1PIGSTY~jammy_amd64.deb
postgresql-13-pg-timeseries0.1.7u22.aarch64pigsty23.8 KiBpostgresql-13-pg-timeseries_0.1.7-1PIGSTY~jammy_arm64.deb
postgresql-13-pg-timeseries0.1.7u24.x86_64pigsty23.8 KiBpostgresql-13-pg-timeseries_0.1.7-1PIGSTY~noble_amd64.deb
postgresql-13-pg-timeseries0.1.7u24.aarch64pigsty23.8 KiBpostgresql-13-pg-timeseries_0.1.7-1PIGSTY~noble_arm64.deb

Source

Repository
github.com/ChuckHend/pg_timeseries
Source Tarball
pg_timeseries-0.1.7.tar.gz
pig build pkg pg_timeseries;		# build rpm / deb with pig

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgdg pigsty -u   # add both repo and update cache

Install this extension with pig:

pig install pg_timeseries;		# install via package name, for the active PG version
pig install timeseries;		# install by extension name, for the current active PG version

pig install timeseries -v 18;   # install for PG 18
pig install timeseries -v 17;   # install for PG 17
pig install timeseries -v 16;   # install for PG 16
pig install timeseries -v 15;   # install for PG 15
pig install timeseries -v 14;   # install for PG 14
pig install timeseries -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION timeseries CASCADE; -- requires columnar, pg_cron, pg_ivm, pg_partman
Last updated on
timescaledb_toolkitperiods