pg_rrule

RRULE field type for PostgreSQL

Module:

PGSQL

Overview

PGDG 1st Party Extension: pg_rrule : RRULE field type for PostgreSQL

Information

Extension ID: 3880
Extension Name: pg_rrule
Package Name: pg_rrule
Category: TYPE
License: MIT
Website: https://github.com/petropavel13/pg_rrule
Language: C
Extra Tags: N/A
Comment: N/A

Metadata

Latest Version: 0.2.0
Postgres Support: 17,16,15,14,13
Need Load: Shared library do not need explicit loading
Need DDL: Need CREATE EXTENSION DDL
Relocatable: Can not install to arbitrary schema
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

RPM / DEB

RPM Repo: None
RPM Name: N/A
RPM Ver : N/A
RPM Deps: N/A
DEB Repo: PGDG
DEB Name: postgresql-$v-pg-rrule
DEB Ver : 0.2.0
DEB Deps: N/A

Packages

OS	Arch	PG17	PG16	PG15	PG14	PG13
`el8`	`x86_64`
`el8`	`aarch64`
`el9`	`x86_64`
`el9`	`aarch64`
`d12`	`x86_64`	`postgresql-17-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2	`postgresql-16-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2	`postgresql-15-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2	`postgresql-14-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2	`postgresql-13-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2
`d12`	`aarch64`	`postgresql-17-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2	`postgresql-16-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2	`postgresql-15-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2	`postgresql-14-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2	`postgresql-13-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2
`u22`	`x86_64`	`postgresql-17-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2	`postgresql-16-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2	`postgresql-15-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2	`postgresql-14-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2	`postgresql-13-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2
`u22`	`aarch64`	`postgresql-17-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2	`postgresql-16-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2	`postgresql-15-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2	`postgresql-14-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2	`postgresql-13-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2
`u24`	`x86_64`	`postgresql-17-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2	`postgresql-16-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2	`postgresql-15-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2	`postgresql-14-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2	`postgresql-13-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2
`u24`	`aarch64`	`postgresql-17-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2	`postgresql-16-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2	`postgresql-15-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2	`postgresql-14-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2	`postgresql-13-pg-rrule` PGDG 0.2.0+git20211101.d7d10f2

Installation

Install pg_rrule via the pig CLI tool:

pig ext install pg_rrule

Install pg_rrule via Pigsty playbook:

./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_rrule"]}' # -l <cls>

Install pg_rrule DEB from APT repo directly:

apt install postgresql-17-pg-rrule;
apt install postgresql-16-pg-rrule;
apt install postgresql-15-pg-rrule;
apt install postgresql-14-pg-rrule;
apt install postgresql-13-pg-rrule;

Enable pg_rrule extension on PostgreSQL cluster：

CREATE EXTENSION pg_rrule;

Feedback

Was this page helpful?

Glad to hear it! Please tell us how we can improve.

Sorry to hear that. Please tell us how we can improve.

Last modified 2025-02-17: add extension part (cfa504b)