Re: function that resolves IP addresses

From: Richard Huxton <dev(at)archonet(dot)com>
To: Marcel Gsteiger <Marcel(dot)Gsteiger(at)milprog(dot)ch>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: function that resolves IP addresses
Date: 2005-10-19 13:09:02
Message-ID: 4356456E.1060103@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marcel Gsteiger wrote:
> Hi all
>
> Does anybody know how I could create a database function that accepts
> an INET parameter and reverse-lookups the hostname via DNS PTR lookup?
> Something like the dnsname command line utility in the djbdns package. I
> need this function for analyzing firewall logs stored in the database
> with ulogd.

You can write "unsafe" functions in any of the pl...u languages and also
pl/sh and "C". Should be simple enough in whatever language you're most
familiar with.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2005-10-19 13:09:15 Re: function that resolves IP addresses
Previous Message Richard Huxton 2005-10-19 13:07:11 Re: psql runs out of memory