Extensions
ip4r

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
hashtypespg_duration