tzf
Fast lookup timezone name by GPS coordinates
Module:
Categories:
Overview
PIGSTY 3rd Party Extension: pg_tzf
: Fast lookup timezone name by GPS coordinates
Information
- Extension ID: 1680
- Extension Name:
tzf
- Package Name:
pg_tzf
- Category:
GIS
- License: MIT
- Website: https://github.com/ringsaturn/tzf-pg
- Language: Rust
- Extra Tags:
pgrx
- 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 be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_tzf_$v
- RPM Ver :
0.2.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-tzf
- DEB Ver :
0.2.0
- DEB Deps: N/A
Availability
OS | Arch | PG17 | PG16 | PG15 | PG14 | PG13 |
---|---|---|---|---|---|---|
el8 |
x86_64 |
pg_tzf_17 PIGSTY 0.2.0 |
pg_tzf_16 PIGSTY 0.2.0 |
pg_tzf_15 PIGSTY 0.2.0 |
pg_tzf_14 PIGSTY 0.2.0 |
pg_tzf_13 PIGSTY 0.2.0 |
el8 |
aarch64 |
pg_tzf_17 PIGSTY 0.2.0 |
pg_tzf_16 PIGSTY 0.2.0 |
pg_tzf_15 PIGSTY 0.2.0 |
pg_tzf_14 PIGSTY 0.2.0 |
pg_tzf_13 PIGSTY 0.2.0 |
el9 |
x86_64 |
pg_tzf_17 PIGSTY 0.2.0 |
pg_tzf_16 PIGSTY 0.2.0 |
pg_tzf_15 PIGSTY 0.2.0 |
pg_tzf_14 PIGSTY 0.2.0 |
pg_tzf_13 PIGSTY 0.2.0 |
el9 |
aarch64 |
pg_tzf_17 PIGSTY 0.2.0 |
pg_tzf_16 PIGSTY 0.2.0 |
pg_tzf_15 PIGSTY 0.2.0 |
pg_tzf_14 PIGSTY 0.2.0 |
pg_tzf_13 PIGSTY 0.2.0 |
d12 |
x86_64 |
postgresql-17-tzf PIGSTY 0.2.0 |
postgresql-16-tzf PIGSTY 0.2.0 |
postgresql-15-tzf PIGSTY 0.2.0 |
postgresql-14-tzf PIGSTY 0.2.0 |
postgresql-13-tzf PIGSTY 0.2.0 |
d12 |
aarch64 |
postgresql-17-tzf PIGSTY 0.2.0 |
postgresql-16-tzf PIGSTY 0.2.0 |
postgresql-15-tzf PIGSTY 0.2.0 |
postgresql-14-tzf PIGSTY 0.2.0 |
postgresql-13-tzf PIGSTY 0.2.0 |
u22 |
x86_64 |
postgresql-17-tzf PIGSTY 0.2.0 |
postgresql-16-tzf PIGSTY 0.2.0 |
postgresql-15-tzf PIGSTY 0.2.0 |
postgresql-14-tzf PIGSTY 0.2.0 |
postgresql-13-tzf PIGSTY 0.2.0 |
u22 |
aarch64 |
postgresql-17-tzf PIGSTY 0.2.0 |
postgresql-16-tzf PIGSTY 0.2.0 |
postgresql-15-tzf PIGSTY 0.2.0 |
postgresql-14-tzf PIGSTY 0.2.0 |
postgresql-13-tzf PIGSTY 0.2.0 |
u24 |
x86_64 |
postgresql-17-tzf PIGSTY 0.2.0 |
postgresql-16-tzf PIGSTY 0.2.0 |
postgresql-15-tzf PIGSTY 0.2.0 |
postgresql-14-tzf PIGSTY 0.2.0 |
postgresql-13-tzf PIGSTY 0.2.0 |
u24 |
aarch64 |
postgresql-17-tzf PIGSTY 0.2.0 |
postgresql-16-tzf PIGSTY 0.2.0 |
postgresql-15-tzf PIGSTY 0.2.0 |
postgresql-14-tzf PIGSTY 0.2.0 |
postgresql-13-tzf PIGSTY 0.2.0 |
Installation
Install tzf
via the pig
CLI tool:
pig ext install pg_tzf; # Extension Name
pig ext install tzf; # normalized package name
Install pg_tzf
via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_tzf"]}' # -l <cls>
Install pg_tzf
RPM from YUM repo directly:
dnf install pg_tzf_17;
dnf install pg_tzf_16;
dnf install pg_tzf_15;
dnf install pg_tzf_14;
dnf install pg_tzf_13;
Install pg_tzf
DEB from APT repo directly:
apt install postgresql-17-tzf;
apt install postgresql-16-tzf;
apt install postgresql-15-tzf;
apt install postgresql-14-tzf;
apt install postgresql-13-tzf;
Create tzf
extension on PostgreSQL cluster:
CREATE EXTENSION tzf;
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.