ip4r – PGEXT.CLOUD

ip4r

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 Compatibility	Package Pattern	Dependencies
EXT	PGDG	`2.4.2`	18 17 16 15 14 13	`ip4r`	-
RPM	PGDG	`2.4.2`	18 17 16 15 14 13	`ip4r_$v*`	-
DEB	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

Make sure PGDG repo available:

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

Install this extension with pig:

pig install ip4r;		# install via package name, for the active PG version

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

Create this extension with:

CREATE EXTENSION ip4r;

Last updated on 2025-11-10

hashtypes pg_duration