ip4r – PIG

ip4r

IPv4/v6 and IPv4/v6 range index type for PostgreSQL

Overview

ID	Extension	Package	Version	Category	License	Language
3820	ip4r	ip4r	`2.4.2`	TYPE	PostgreSQL	C

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

Relationships
Need By	geoip
See Also	pg_net prefix semver unit pgpdf pglite_fusion md5hash asn1oid

Packages

Type	Repo	Version	PG Major Availability	Package Pattern	Dependencies
EL	PGDG	`2.4.2`	18 17 16 15 14 13	`ip4r_$v*`	-
Debian	PGDG	`2.4.2`	18 17 16 15 14 13	`postgresql-$v-ip4r`	-

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

Package	Version	OS	ORG	SIZE	File URL
`ip4r_18`	2.4.2	`el8.x86_64`	pgdg	78.0 KiB	ip4r_18-2.4.2-3PGDG.rhel8.x86_64.rpm
`ip4r_18`	2.4.2	`el8.aarch64`	pgdg	73.2 KiB	ip4r_18-2.4.2-3PGDG.rhel8.aarch64.rpm
`ip4r_18`	2.4.2	`el9.x86_64`	pgdg	76.9 KiB	ip4r_18-2.4.2-3PGDG.rhel9.x86_64.rpm
`ip4r_18`	2.4.2	`el9.aarch64`	pgdg	72.8 KiB	ip4r_18-2.4.2-3PGDG.rhel9.aarch64.rpm
`ip4r_18`	2.4.2	`el10.x86_64`	pgdg	79.0 KiB	ip4r_18-2.4.2-3PGDG.rhel10.x86_64.rpm
`ip4r_18`	2.4.2	`el10.aarch64`	pgdg	74.5 KiB	ip4r_18-2.4.2-3PGDG.rhel10.aarch64.rpm
`postgresql-18-ip4r`	2.4.2	`d12.x86_64`	pgdg	180.5 KiB	postgresql-18-ip4r_2.4.2-4.pgdg12+1_amd64.deb
`postgresql-18-ip4r`	2.4.2	`d12.aarch64`	pgdg	173.9 KiB	postgresql-18-ip4r_2.4.2-4.pgdg12+1_arm64.deb
`postgresql-18-ip4r`	2.4.2	`d13.x86_64`	pgdg	180.6 KiB	postgresql-18-ip4r_2.4.2-4.pgdg13+1_amd64.deb
`postgresql-18-ip4r`	2.4.2	`d13.aarch64`	pgdg	175.3 KiB	postgresql-18-ip4r_2.4.2-4.pgdg13+1_arm64.deb
`postgresql-18-ip4r`	2.4.2	`u22.x86_64`	pgdg	181.3 KiB	postgresql-18-ip4r_2.4.2-4.pgdg22.04+1_amd64.deb
`postgresql-18-ip4r`	2.4.2	`u22.aarch64`	pgdg	176.4 KiB	postgresql-18-ip4r_2.4.2-4.pgdg22.04+1_arm64.deb
`postgresql-18-ip4r`	2.4.2	`u24.x86_64`	pgdg	176.9 KiB	postgresql-18-ip4r_2.4.2-4.pgdg24.04+1_amd64.deb
`postgresql-18-ip4r`	2.4.2	`u24.aarch64`	pgdg	171.9 KiB	postgresql-18-ip4r_2.4.2-4.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`ip4r_17`	2.4.2	`el8.x86_64`	pgdg	77.9 KiB	ip4r_17-2.4.2-2PGDG.rhel8.x86_64.rpm
`ip4r_17`	2.4.2	`el8.aarch64`	pgdg	73.0 KiB	ip4r_17-2.4.2-2PGDG.rhel8.aarch64.rpm
`ip4r_17`	2.4.2	`el9.x86_64`	pgdg	76.8 KiB	ip4r_17-2.4.2-2PGDG.rhel9.x86_64.rpm
`ip4r_17`	2.4.2	`el9.aarch64`	pgdg	72.9 KiB	ip4r_17-2.4.2-2PGDG.rhel9.aarch64.rpm
`ip4r_17`	2.4.2	`el10.x86_64`	pgdg	79.0 KiB	ip4r_17-2.4.2-3PGDG.rhel10.x86_64.rpm
`ip4r_17`	2.4.2	`el10.aarch64`	pgdg	74.5 KiB	ip4r_17-2.4.2-3PGDG.rhel10.aarch64.rpm
`postgresql-17-ip4r`	2.4.2	`d12.x86_64`	pgdg	180.4 KiB	postgresql-17-ip4r_2.4.2-4.pgdg12+1_amd64.deb
`postgresql-17-ip4r`	2.4.2	`d12.aarch64`	pgdg	174.0 KiB	postgresql-17-ip4r_2.4.2-4.pgdg12+1_arm64.deb
`postgresql-17-ip4r`	2.4.2	`d13.x86_64`	pgdg	180.6 KiB	postgresql-17-ip4r_2.4.2-4.pgdg13+1_amd64.deb
`postgresql-17-ip4r`	2.4.2	`d13.aarch64`	pgdg	175.2 KiB	postgresql-17-ip4r_2.4.2-4.pgdg13+1_arm64.deb
`postgresql-17-ip4r`	2.4.2	`u22.x86_64`	pgdg	194.9 KiB	postgresql-17-ip4r_2.4.2-4.pgdg22.04+1_amd64.deb
`postgresql-17-ip4r`	2.4.2	`u22.aarch64`	pgdg	189.6 KiB	postgresql-17-ip4r_2.4.2-4.pgdg22.04+1_arm64.deb
`postgresql-17-ip4r`	2.4.2	`u24.x86_64`	pgdg	176.8 KiB	postgresql-17-ip4r_2.4.2-4.pgdg24.04+1_amd64.deb
`postgresql-17-ip4r`	2.4.2	`u24.aarch64`	pgdg	171.7 KiB	postgresql-17-ip4r_2.4.2-4.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`ip4r_16`	2.4.2	`el8.x86_64`	pgdg	77.7 KiB	ip4r_16-2.4.2-1PGDG.rhel8.x86_64.rpm
`ip4r_16`	2.4.2	`el8.aarch64`	pgdg	73.0 KiB	ip4r_16-2.4.2-1PGDG.rhel8.aarch64.rpm
`ip4r_16`	2.4.2	`el9.x86_64`	pgdg	76.7 KiB	ip4r_16-2.4.2-1PGDG.rhel9.x86_64.rpm
`ip4r_16`	2.4.2	`el9.aarch64`	pgdg	72.4 KiB	ip4r_16-2.4.2-1PGDG.rhel9.aarch64.rpm
`ip4r_16`	2.4.2	`el10.x86_64`	pgdg	78.9 KiB	ip4r_16-2.4.2-3PGDG.rhel10.x86_64.rpm
`ip4r_16`	2.4.2	`el10.aarch64`	pgdg	74.5 KiB	ip4r_16-2.4.2-3PGDG.rhel10.aarch64.rpm
`postgresql-16-ip4r`	2.4.2	`d12.x86_64`	pgdg	180.4 KiB	postgresql-16-ip4r_2.4.2-4.pgdg12+1_amd64.deb
`postgresql-16-ip4r`	2.4.2	`d12.aarch64`	pgdg	174.0 KiB	postgresql-16-ip4r_2.4.2-4.pgdg12+1_arm64.deb
`postgresql-16-ip4r`	2.4.2	`d13.x86_64`	pgdg	180.5 KiB	postgresql-16-ip4r_2.4.2-4.pgdg13+1_amd64.deb
`postgresql-16-ip4r`	2.4.2	`d13.aarch64`	pgdg	175.2 KiB	postgresql-16-ip4r_2.4.2-4.pgdg13+1_arm64.deb
`postgresql-16-ip4r`	2.4.2	`u22.x86_64`	pgdg	194.5 KiB	postgresql-16-ip4r_2.4.2-4.pgdg22.04+1_amd64.deb
`postgresql-16-ip4r`	2.4.2	`u22.aarch64`	pgdg	189.4 KiB	postgresql-16-ip4r_2.4.2-4.pgdg22.04+1_arm64.deb
`postgresql-16-ip4r`	2.4.2	`u24.x86_64`	pgdg	176.9 KiB	postgresql-16-ip4r_2.4.2-4.pgdg24.04+1_amd64.deb
`postgresql-16-ip4r`	2.4.2	`u24.aarch64`	pgdg	171.9 KiB	postgresql-16-ip4r_2.4.2-4.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`ip4r_15`	2.4.2	`el8.x86_64`	pgdg	77.1 KiB	ip4r_15-2.4.2-1PGDG.rhel8.x86_64.rpm
`ip4r_15`	2.4.1	`el8.x86_64`	pgdg	208.7 KiB	ip4r_15-2.4.1-2.rhel8.x86_64.rpm
`ip4r_15`	2.4.2	`el8.aarch64`	pgdg	72.0 KiB	ip4r_15-2.4.2-1PGDG.rhel8.aarch64.rpm
`ip4r_15`	2.4.1	`el8.aarch64`	pgdg	203.2 KiB	ip4r_15-2.4.1-2.rhel8.aarch64.rpm
`ip4r_15`	2.4.2	`el9.x86_64`	pgdg	75.6 KiB	ip4r_15-2.4.2-1PGDG.rhel9.x86_64.rpm
`ip4r_15`	2.4.1	`el9.x86_64`	pgdg	209.9 KiB	ip4r_15-2.4.1-2.rhel9.x86_64.rpm
`ip4r_15`	2.4.2	`el9.aarch64`	pgdg	71.3 KiB	ip4r_15-2.4.2-1PGDG.rhel9.aarch64.rpm
`ip4r_15`	2.4.1	`el9.aarch64`	pgdg	204.6 KiB	ip4r_15-2.4.1-2.rhel9.aarch64.rpm
`ip4r_15`	2.4.2	`el10.x86_64`	pgdg	78.6 KiB	ip4r_15-2.4.2-3PGDG.rhel10.x86_64.rpm
`ip4r_15`	2.4.2	`el10.aarch64`	pgdg	73.8 KiB	ip4r_15-2.4.2-3PGDG.rhel10.aarch64.rpm
`postgresql-15-ip4r`	2.4.2	`d12.x86_64`	pgdg	179.2 KiB	postgresql-15-ip4r_2.4.2-4.pgdg12+1_amd64.deb
`postgresql-15-ip4r`	2.4.2	`d12.aarch64`	pgdg	172.7 KiB	postgresql-15-ip4r_2.4.2-4.pgdg12+1_arm64.deb
`postgresql-15-ip4r`	2.4.2	`d13.x86_64`	pgdg	179.2 KiB	postgresql-15-ip4r_2.4.2-4.pgdg13+1_amd64.deb
`postgresql-15-ip4r`	2.4.2	`d13.aarch64`	pgdg	173.9 KiB	postgresql-15-ip4r_2.4.2-4.pgdg13+1_arm64.deb
`postgresql-15-ip4r`	2.4.2	`u22.x86_64`	pgdg	192.9 KiB	postgresql-15-ip4r_2.4.2-4.pgdg22.04+1_amd64.deb
`postgresql-15-ip4r`	2.4.2	`u22.aarch64`	pgdg	187.5 KiB	postgresql-15-ip4r_2.4.2-4.pgdg22.04+1_arm64.deb
`postgresql-15-ip4r`	2.4.2	`u24.x86_64`	pgdg	175.0 KiB	postgresql-15-ip4r_2.4.2-4.pgdg24.04+1_amd64.deb
`postgresql-15-ip4r`	2.4.2	`u24.aarch64`	pgdg	170.2 KiB	postgresql-15-ip4r_2.4.2-4.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`ip4r_14`	2.4.2	`el8.x86_64`	pgdg	77.1 KiB	ip4r_14-2.4.2-1PGDG.rhel8.x86_64.rpm
`ip4r_14`	2.4.1	`el8.x86_64`	pgdg	210.6 KiB	ip4r_14-2.4.1-2.rhel8.x86_64.rpm
`ip4r_14`	2.4.2	`el8.aarch64`	pgdg	71.9 KiB	ip4r_14-2.4.2-1PGDG.rhel8.aarch64.rpm
`ip4r_14`	2.4.1	`el8.aarch64`	pgdg	203.2 KiB	ip4r_14-2.4.1-2.rhel8.aarch64.rpm
`ip4r_14`	2.4.2	`el9.x86_64`	pgdg	75.6 KiB	ip4r_14-2.4.2-1PGDG.rhel9.x86_64.rpm
`ip4r_14`	2.4.2	`el9.aarch64`	pgdg	71.3 KiB	ip4r_14-2.4.2-1PGDG.rhel9.aarch64.rpm
`ip4r_14`	2.4.1	`el9.aarch64`	pgdg	204.7 KiB	ip4r_14-2.4.1-2.rhel9.aarch64.rpm
`ip4r_14`	2.4.2	`el10.x86_64`	pgdg	78.6 KiB	ip4r_14-2.4.2-3PGDG.rhel10.x86_64.rpm
`ip4r_14`	2.4.2	`el10.aarch64`	pgdg	73.8 KiB	ip4r_14-2.4.2-3PGDG.rhel10.aarch64.rpm
`postgresql-14-ip4r`	2.4.2	`d12.x86_64`	pgdg	179.2 KiB	postgresql-14-ip4r_2.4.2-4.pgdg12+1_amd64.deb
`postgresql-14-ip4r`	2.4.2	`d12.aarch64`	pgdg	172.7 KiB	postgresql-14-ip4r_2.4.2-4.pgdg12+1_arm64.deb
`postgresql-14-ip4r`	2.4.2	`d13.x86_64`	pgdg	179.2 KiB	postgresql-14-ip4r_2.4.2-4.pgdg13+1_amd64.deb
`postgresql-14-ip4r`	2.4.2	`d13.aarch64`	pgdg	173.7 KiB	postgresql-14-ip4r_2.4.2-4.pgdg13+1_arm64.deb
`postgresql-14-ip4r`	2.4.2	`u22.x86_64`	pgdg	192.7 KiB	postgresql-14-ip4r_2.4.2-4.pgdg22.04+1_amd64.deb
`postgresql-14-ip4r`	2.4.2	`u22.aarch64`	pgdg	187.4 KiB	postgresql-14-ip4r_2.4.2-4.pgdg22.04+1_arm64.deb
`postgresql-14-ip4r`	2.4.2	`u24.x86_64`	pgdg	175.0 KiB	postgresql-14-ip4r_2.4.2-4.pgdg24.04+1_amd64.deb
`postgresql-14-ip4r`	2.4.2	`u24.aarch64`	pgdg	170.2 KiB	postgresql-14-ip4r_2.4.2-4.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`ip4r_13`	2.4.2	`el8.x86_64`	pgdg	76.2 KiB	ip4r_13-2.4.2-1PGDG.rhel8.x86_64.rpm
`ip4r_13`	2.4.2	`el8.aarch64`	pgdg	71.9 KiB	ip4r_13-2.4.2-1PGDG.rhel8.aarch64.rpm
`ip4r_13`	2.4.1	`el8.aarch64`	pgdg	202.7 KiB	ip4r_13-2.4.1-2.rhel8.aarch64.rpm
`ip4r_13`	2.4.2	`el9.x86_64`	pgdg	75.2 KiB	ip4r_13-2.4.2-1PGDG.rhel9.x86_64.rpm
`ip4r_13`	2.4.2	`el9.aarch64`	pgdg	71.4 KiB	ip4r_13-2.4.2-1PGDG.rhel9.aarch64.rpm
`ip4r_13`	2.4.1	`el9.aarch64`	pgdg	204.7 KiB	ip4r_13-2.4.1-2.rhel9.aarch64.rpm
`ip4r_13`	2.4.2	`el10.x86_64`	pgdg	78.1 KiB	ip4r_13-2.4.2-3PGDG.rhel10.x86_64.rpm
`ip4r_13`	2.4.2	`el10.aarch64`	pgdg	73.7 KiB	ip4r_13-2.4.2-3PGDG.rhel10.aarch64.rpm
`postgresql-13-ip4r`	2.4.2	`d12.x86_64`	pgdg	178.6 KiB	postgresql-13-ip4r_2.4.2-4.pgdg12+1_amd64.deb
`postgresql-13-ip4r`	2.4.2	`d12.aarch64`	pgdg	172.5 KiB	postgresql-13-ip4r_2.4.2-4.pgdg12+1_arm64.deb
`postgresql-13-ip4r`	2.4.2	`d13.x86_64`	pgdg	178.8 KiB	postgresql-13-ip4r_2.4.2-4.pgdg13+1_amd64.deb
`postgresql-13-ip4r`	2.4.2	`d13.aarch64`	pgdg	173.7 KiB	postgresql-13-ip4r_2.4.2-4.pgdg13+1_arm64.deb
`postgresql-13-ip4r`	2.4.2	`u22.x86_64`	pgdg	192.1 KiB	postgresql-13-ip4r_2.4.2-4.pgdg22.04+1_amd64.deb
`postgresql-13-ip4r`	2.4.2	`u22.aarch64`	pgdg	187.1 KiB	postgresql-13-ip4r_2.4.2-4.pgdg22.04+1_arm64.deb
`postgresql-13-ip4r`	2.4.2	`u24.x86_64`	pgdg	174.5 KiB	postgresql-13-ip4r_2.4.2-4.pgdg24.04+1_amd64.deb
`postgresql-13-ip4r`	2.4.2	`u24.aarch64`	pgdg	169.9 KiB	postgresql-13-ip4r_2.4.2-4.pgdg24.04+1_arm64.deb

Source

Repository

github.com/RhodiumToad/ip4r

Install

To add the required PGDG / PIGSTY upstream repository, use:

pig repo add pgsql -u   # add PGDG + Pigsty repo and update cache (leave existing repos)

Install this extension with:

pig ext install ip4r; # install by extension name, for the current active PG version
pig ext install ip4r; # install via package alias, for the active PG version
pig ext install ip4r -v 18;   # install for PG 18
pig ext install ip4r -v 17;   # install for PG 17
pig ext install ip4r -v 16;   # install for PG 16
pig ext install ip4r -v 15;   # install for PG 15
pig ext install ip4r -v 14;   # install for PG 14
pig ext install ip4r -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION ip4r;

Last updated on 2025-11-02

hashtypes pg_duration