Filewatcher File Search File Search
Catalog
Content Search
» » » » »

postgresql-9.1-ip4r

IPv4 and IPv4 range index types for PostgreSQL 9.1

Variants:
This PostgreSQL module provides two data types, ip4 and ip4r, which can contain a single IPv4 address or a range of IPv4 addresses, respectively.

While PostgreSQL already has built-in types 'inet' and 'cidr', the authors of this module found that they had a number of requirements that were not addressed by the built-in type.

Firstly and most importantly, the built-in types have no support for index lookups of the form (column >>= parameter), i.e. where you have a table of IP address ranges and wish to find which ones include a given IP address. This requires an rtree or gist index to do efficiently, and also requires a way to represent IP address ranges that do not fall precisely on CIDR boundaries.

Secondly, the built-in inet/cidr are somewhat overloaded with semantics, with inet combining two distinct concepts (a netblock, and a specific IP within that netblock). Furthermore, they are variable length types (to support IPv6) with non-trivial overheads, and the authors (whose applications mainly deal in large volumes of single IPv4 addresses) wanted a more lightweight representation.

ip4r therefore supports two distinct data types (so far):

ip4 - a single IPv4 address ip4r - an arbitrary range of IPv4 addresses

Homepage:
Package version:1.05-0.1
Architecture:armel
Distribution:Debian
Filename:postgresql-9.1-ip4r_1.05-0.1_armel.deb

/usr/share/doc/postgresql-9.1-ip4r/README.ip4r.gz

IP4R  - IPv4 and IPv4 range index type for PostgreSQL
=====================================================

RATIONALE
=========

While PostgreSQL already has builtin types 'inet' and 'cidr', the
authors of this module found that they had a number of requirements
that were not addressed by the builtin type.

Firstly and most importantly, the builtin types have no support for
index lookups of the 
more»

/usr/share/doc/postgresql-9.1-ip4r/changelog.Debian.gz

ip4r (1.05-0.1) unstable; urgency=low

  * Non-maintainer upload.
  * New upstream version compatible with PG 9.0.
  * Convert to use pg_buildext to build against PG 9.1;
    closes: #605711, #639470.

 -- Christoph Berg <myon@debian.org>  Sat, 08 Oct 2011 14:34:24 +0200

ip4r (1.04-1) unstable; urgency=low

  * New upstream release; closes: #537693.
  * Drop postgresql-8.3-ip4r and build postgres
more»

/usr/share/doc/postgresql-9.1-ip4r/copyright

This package was debianized by Robert Edmonds <edmonds@debian.org> on
Thu, 16 Mar 2006 13:50:09 -0500.

It was downloaded from http://pgfoundry.org/projects/ip4r/

Copyright Holders:

Andrew - Supernews <andrew@supernews.net>
Steve Atkins <steve@blighty.com>

License:

This code is available under the terms of the BSD license.  On Debian
GNU/Linux systems, the complete text of the BSD license can 
more»

Browse inside postgresql-9.1-ip4r_1.05-0.1_armel.deb

         [DIR]DEBIAN/ (2)  65535+ mirrors
         [DIR]usr/ (2)  65535+ mirrors

Download postgresql-9.1-ip4r_1.05-0.1_armel.deb

Results 1 - 1 of 1
Help - FTP Sites List - Software Dir.
Search over 15 billion files
© 1997-2016 FileWatcher.com