pg_sphere

Extensions

pg_sphere

pgsphere : spherical objects with useful functions, operators and index support

Overview

ID	Extension	Package	Version	Category	License	Language
3590	pg_sphere	pgsphere	`1.5.2`	TYPE	BSD 3-Clause	C

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--s-d-r	No	Yes	No	Yes	yes	no

Relationships
See Also	postgis q3c earthdistance prefix semver unit pgpdf pglite_fusion

Packages

Type	Repo	Version	PG Major Compatibility	Package Pattern	Dependencies
EXT	MIXED	`1.5.2`	18 17 16 15 14	`pgsphere`	-
RPM	PIGSTY	`1.5.2`	18 17 16 15 14	`pgsphere_$v`	-
DEB	PGDG	`1.5.2`	18 17 16 15 14	`postgresql-$v-pgsphere`	-

Linux / PG	PG18	PG17	PG16	PG15	PG14
el8.x86_64	PIGSTY 1.5.2	PIGSTY 1.5.2	PIGSTY 1.5.2	PIGSTY 1.5.2	PIGSTY 1.5.2
el8.aarch64	PIGSTY 1.5.2	PIGSTY 1.5.2	PIGSTY 1.5.2	PIGSTY 1.5.2	PIGSTY 1.5.2
el9.x86_64	PIGSTY 1.5.2	PIGSTY 1.5.2	PIGSTY 1.5.2	PIGSTY 1.5.2	PIGSTY 1.5.2
el9.aarch64	PIGSTY 1.5.2	PIGSTY 1.5.2	PIGSTY 1.5.2	PIGSTY 1.5.2	PIGSTY 1.5.2
el10.x86_64	PIGSTY 1.5.2	PIGSTY 1.5.2	PIGSTY 1.5.2	PIGSTY 1.5.2	PIGSTY 1.5.2
el10.aarch64	PIGSTY 1.5.2	PIGSTY 1.5.2	PIGSTY 1.5.2	PIGSTY 1.5.2	PIGSTY 1.5.2
d12.x86_64	PGDG 1.5.2	PGDG 1.5.2	PGDG 1.5.2	PGDG 1.5.2	PGDG 1.5.2
d12.aarch64	PGDG 1.5.2	PGDG 1.5.2	PGDG 1.5.2	PGDG 1.5.2	PGDG 1.5.2
d13.x86_64	PGDG 1.5.2	PGDG 1.5.2	PGDG 1.5.2	PGDG 1.5.2	PGDG 1.5.2
d13.aarch64	PGDG 1.5.2	PGDG 1.5.2	PGDG 1.5.2	PGDG 1.5.2	PGDG 1.5.2
u22.x86_64	PGDG 1.5.2	PGDG 1.5.2	PGDG 1.5.2	PGDG 1.5.2	PGDG 1.5.2
u22.aarch64	PGDG 1.5.2	PGDG 1.5.2	PGDG 1.5.2	PGDG 1.5.2	PGDG 1.5.2
u24.x86_64	PGDG 1.5.2	PGDG 1.5.2	PGDG 1.5.2	PGDG 1.5.2	PGDG 1.5.2
u24.aarch64	PGDG 1.5.2	PGDG 1.5.2	PGDG 1.5.2	PGDG 1.5.2	PGDG 1.5.2

Package	Version	OS	ORG	SIZE	File URL
`pgsphere_18`	`1.5.2`	el8.x86_64	pigsty	125.2 KiB	pgsphere_18-1.5.2-1PIGSTY.el8.x86_64.rpm
`pgsphere_18`	`1.5.2`	el8.aarch64	pigsty	122.2 KiB	pgsphere_18-1.5.2-1PIGSTY.el8.aarch64.rpm
`pgsphere_18`	`1.5.2`	el9.x86_64	pigsty	118.2 KiB	pgsphere_18-1.5.2-1PIGSTY.el9.x86_64.rpm
`pgsphere_18`	`1.5.2`	el9.aarch64	pigsty	116.7 KiB	pgsphere_18-1.5.2-1PIGSTY.el9.aarch64.rpm
`pgsphere_18`	`1.5.2`	el10.x86_64	pigsty	119.3 KiB	pgsphere_18-1.5.2-1PIGSTY.el10.x86_64.rpm
`pgsphere_18`	`1.5.2`	el10.aarch64	pigsty	119.5 KiB	pgsphere_18-1.5.2-1PIGSTY.el10.aarch64.rpm
`postgresql-18-pgsphere`	`1.5.2`	d12.x86_64	pgdg	405.0 KiB	postgresql-18-pgsphere_1.5.2-1.pgdg12+1_amd64.deb
`postgresql-18-pgsphere`	`1.5.2`	d12.aarch64	pgdg	400.2 KiB	postgresql-18-pgsphere_1.5.2-1.pgdg12+1_arm64.deb
`postgresql-18-pgsphere`	`1.5.2`	d13.x86_64	pgdg	405.1 KiB	postgresql-18-pgsphere_1.5.2-1.pgdg13+1_amd64.deb
`postgresql-18-pgsphere`	`1.5.2`	d13.aarch64	pgdg	402.7 KiB	postgresql-18-pgsphere_1.5.2-1.pgdg13+1_arm64.deb
`postgresql-18-pgsphere`	`1.5.2`	u22.x86_64	pgdg	413.8 KiB	postgresql-18-pgsphere_1.5.2-1.pgdg22.04+1_amd64.deb
`postgresql-18-pgsphere`	`1.5.2`	u22.aarch64	pgdg	407.4 KiB	postgresql-18-pgsphere_1.5.2-1.pgdg22.04+1_arm64.deb
`postgresql-18-pgsphere`	`1.5.2`	u24.x86_64	pgdg	406.4 KiB	postgresql-18-pgsphere_1.5.2-1.pgdg24.04+1_amd64.deb
`postgresql-18-pgsphere`	`1.5.2`	u24.aarch64	pgdg	401.2 KiB	postgresql-18-pgsphere_1.5.2-1.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pgsphere_17`	`1.5.2`	el8.x86_64	pigsty	125.2 KiB	pgsphere_17-1.5.2-1PIGSTY.el8.x86_64.rpm
`pgsphere_17`	`1.5.2`	el8.aarch64	pigsty	122.2 KiB	pgsphere_17-1.5.2-1PIGSTY.el8.aarch64.rpm
`pgsphere_17`	`1.5.2`	el9.x86_64	pigsty	118.2 KiB	pgsphere_17-1.5.2-1PIGSTY.el9.x86_64.rpm
`pgsphere_17`	`1.5.2`	el9.aarch64	pigsty	116.7 KiB	pgsphere_17-1.5.2-1PIGSTY.el9.aarch64.rpm
`pgsphere_17`	`1.5.2`	el10.x86_64	pigsty	119.3 KiB	pgsphere_17-1.5.2-1PIGSTY.el10.x86_64.rpm
`pgsphere_17`	`1.5.2`	el10.aarch64	pigsty	119.6 KiB	pgsphere_17-1.5.2-1PIGSTY.el10.aarch64.rpm
`postgresql-17-pgsphere`	`1.5.2`	d12.x86_64	pgdg	404.8 KiB	postgresql-17-pgsphere_1.5.2-1.pgdg12+1_amd64.deb
`postgresql-17-pgsphere`	`1.5.2`	d12.aarch64	pgdg	400.1 KiB	postgresql-17-pgsphere_1.5.2-1.pgdg12+1_arm64.deb
`postgresql-17-pgsphere`	`1.5.2`	d13.x86_64	pgdg	405.5 KiB	postgresql-17-pgsphere_1.5.2-1.pgdg13+1_amd64.deb
`postgresql-17-pgsphere`	`1.5.2`	d13.aarch64	pgdg	402.5 KiB	postgresql-17-pgsphere_1.5.2-1.pgdg13+1_arm64.deb
`postgresql-17-pgsphere`	`1.5.2`	u22.x86_64	pgdg	434.0 KiB	postgresql-17-pgsphere_1.5.2-1.pgdg22.04+1_amd64.deb
`postgresql-17-pgsphere`	`1.5.2`	u22.aarch64	pgdg	427.1 KiB	postgresql-17-pgsphere_1.5.2-1.pgdg22.04+1_arm64.deb
`postgresql-17-pgsphere`	`1.5.2`	u24.x86_64	pgdg	406.3 KiB	postgresql-17-pgsphere_1.5.2-1.pgdg24.04+1_amd64.deb
`postgresql-17-pgsphere`	`1.5.2`	u24.aarch64	pgdg	401.0 KiB	postgresql-17-pgsphere_1.5.2-1.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pgsphere_16`	`1.5.2`	el8.x86_64	pigsty	125.3 KiB	pgsphere_16-1.5.2-1PIGSTY.el8.x86_64.rpm
`pgsphere_16`	`1.5.2`	el8.aarch64	pigsty	122.2 KiB	pgsphere_16-1.5.2-1PIGSTY.el8.aarch64.rpm
`pgsphere_16`	`1.5.2`	el9.x86_64	pigsty	118.2 KiB	pgsphere_16-1.5.2-1PIGSTY.el9.x86_64.rpm
`pgsphere_16`	`1.5.2`	el9.aarch64	pigsty	116.7 KiB	pgsphere_16-1.5.2-1PIGSTY.el9.aarch64.rpm
`pgsphere_16`	`1.5.2`	el10.x86_64	pigsty	119.3 KiB	pgsphere_16-1.5.2-1PIGSTY.el10.x86_64.rpm
`pgsphere_16`	`1.5.2`	el10.aarch64	pigsty	119.5 KiB	pgsphere_16-1.5.2-1PIGSTY.el10.aarch64.rpm
`postgresql-16-pgsphere`	`1.5.2`	d12.x86_64	pgdg	404.8 KiB	postgresql-16-pgsphere_1.5.2-1.pgdg12+1_amd64.deb
`postgresql-16-pgsphere`	`1.5.2`	d12.aarch64	pgdg	400.2 KiB	postgresql-16-pgsphere_1.5.2-1.pgdg12+1_arm64.deb
`postgresql-16-pgsphere`	`1.5.2`	d13.x86_64	pgdg	405.4 KiB	postgresql-16-pgsphere_1.5.2-1.pgdg13+1_amd64.deb
`postgresql-16-pgsphere`	`1.5.2`	d13.aarch64	pgdg	402.6 KiB	postgresql-16-pgsphere_1.5.2-1.pgdg13+1_arm64.deb
`postgresql-16-pgsphere`	`1.5.2`	u22.x86_64	pgdg	433.6 KiB	postgresql-16-pgsphere_1.5.2-1.pgdg22.04+1_amd64.deb
`postgresql-16-pgsphere`	`1.5.2`	u22.aarch64	pgdg	427.1 KiB	postgresql-16-pgsphere_1.5.2-1.pgdg22.04+1_arm64.deb
`postgresql-16-pgsphere`	`1.5.2`	u24.x86_64	pgdg	406.4 KiB	postgresql-16-pgsphere_1.5.2-1.pgdg24.04+1_amd64.deb
`postgresql-16-pgsphere`	`1.5.2`	u24.aarch64	pgdg	401.0 KiB	postgresql-16-pgsphere_1.5.2-1.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pgsphere_15`	`1.5.2`	el8.x86_64	pigsty	127.2 KiB	pgsphere_15-1.5.2-1PIGSTY.el8.x86_64.rpm
`pgsphere_15`	`1.5.2`	el8.aarch64	pigsty	124.1 KiB	pgsphere_15-1.5.2-1PIGSTY.el8.aarch64.rpm
`pgsphere_15`	`1.5.2`	el9.x86_64	pigsty	114.7 KiB	pgsphere_15-1.5.2-1PIGSTY.el9.x86_64.rpm
`pgsphere_15`	`1.5.2`	el9.aarch64	pigsty	114.8 KiB	pgsphere_15-1.5.2-1PIGSTY.el9.aarch64.rpm
`pgsphere_15`	`1.5.2`	el10.x86_64	pigsty	114.5 KiB	pgsphere_15-1.5.2-1PIGSTY.el10.x86_64.rpm
`pgsphere_15`	`1.5.2`	el10.aarch64	pigsty	116.8 KiB	pgsphere_15-1.5.2-1PIGSTY.el10.aarch64.rpm
`postgresql-15-pgsphere`	`1.5.2`	d12.x86_64	pgdg	405.9 KiB	postgresql-15-pgsphere_1.5.2-1.pgdg12+1_amd64.deb
`postgresql-15-pgsphere`	`1.5.2`	d12.aarch64	pgdg	401.2 KiB	postgresql-15-pgsphere_1.5.2-1.pgdg12+1_arm64.deb
`postgresql-15-pgsphere`	`1.5.2`	d13.x86_64	pgdg	406.2 KiB	postgresql-15-pgsphere_1.5.2-1.pgdg13+1_amd64.deb
`postgresql-15-pgsphere`	`1.5.2`	d13.aarch64	pgdg	403.3 KiB	postgresql-15-pgsphere_1.5.2-1.pgdg13+1_arm64.deb
`postgresql-15-pgsphere`	`1.5.2`	u22.x86_64	pgdg	434.2 KiB	postgresql-15-pgsphere_1.5.2-1.pgdg22.04+1_amd64.deb
`postgresql-15-pgsphere`	`1.5.2`	u22.aarch64	pgdg	428.2 KiB	postgresql-15-pgsphere_1.5.2-1.pgdg22.04+1_arm64.deb
`postgresql-15-pgsphere`	`1.5.2`	u24.x86_64	pgdg	404.9 KiB	postgresql-15-pgsphere_1.5.2-1.pgdg24.04+1_amd64.deb
`postgresql-15-pgsphere`	`1.5.2`	u24.aarch64	pgdg	402.1 KiB	postgresql-15-pgsphere_1.5.2-1.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`pgsphere_14`	`1.5.2`	el8.x86_64	pigsty	127.1 KiB	pgsphere_14-1.5.2-1PIGSTY.el8.x86_64.rpm
`pgsphere_14`	`1.5.2`	el8.aarch64	pigsty	124.1 KiB	pgsphere_14-1.5.2-1PIGSTY.el8.aarch64.rpm
`pgsphere_14`	`1.5.2`	el9.x86_64	pigsty	114.6 KiB	pgsphere_14-1.5.2-1PIGSTY.el9.x86_64.rpm
`pgsphere_14`	`1.5.2`	el9.aarch64	pigsty	114.8 KiB	pgsphere_14-1.5.2-1PIGSTY.el9.aarch64.rpm
`pgsphere_14`	`1.5.2`	el10.x86_64	pigsty	114.5 KiB	pgsphere_14-1.5.2-1PIGSTY.el10.x86_64.rpm
`pgsphere_14`	`1.5.2`	el10.aarch64	pigsty	116.7 KiB	pgsphere_14-1.5.2-1PIGSTY.el10.aarch64.rpm
`postgresql-14-pgsphere`	`1.5.2`	d12.x86_64	pgdg	406.0 KiB	postgresql-14-pgsphere_1.5.2-1.pgdg12+1_amd64.deb
`postgresql-14-pgsphere`	`1.5.2`	d12.aarch64	pgdg	400.9 KiB	postgresql-14-pgsphere_1.5.2-1.pgdg12+1_arm64.deb
`postgresql-14-pgsphere`	`1.5.2`	d13.x86_64	pgdg	406.3 KiB	postgresql-14-pgsphere_1.5.2-1.pgdg13+1_amd64.deb
`postgresql-14-pgsphere`	`1.5.2`	d13.aarch64	pgdg	403.9 KiB	postgresql-14-pgsphere_1.5.2-1.pgdg13+1_arm64.deb
`postgresql-14-pgsphere`	`1.5.2`	u22.x86_64	pgdg	433.6 KiB	postgresql-14-pgsphere_1.5.2-1.pgdg22.04+1_amd64.deb
`postgresql-14-pgsphere`	`1.5.2`	u22.aarch64	pgdg	428.1 KiB	postgresql-14-pgsphere_1.5.2-1.pgdg22.04+1_arm64.deb
`postgresql-14-pgsphere`	`1.5.2`	u24.x86_64	pgdg	405.1 KiB	postgresql-14-pgsphere_1.5.2-1.pgdg24.04+1_amd64.deb
`postgresql-14-pgsphere`	`1.5.2`	u24.aarch64	pgdg	402.0 KiB	postgresql-14-pgsphere_1.5.2-1.pgdg24.04+1_arm64.deb

Source

Repository

github.com/postgrespro/pgsphere

Source Tarball

pgsphere-1.5.2.tar.gz

pig build pkg pgsphere;		# build rpm

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgsql -u   # add both repo and update cache

Install this extension with pig:

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

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

Create this extension with:

CREATE EXTENSION pg_sphere;

Last updated on 2026-03-08

pgfaceting country