Re: function that resolves IP addresses

From: Bruno Wolff III <bruno(at)wolff(dot)to>
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-29 16:18:06
Message-ID: 20051029161806.GA13786@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Oct 19, 2005 at 14:36:46 +0200,
Marcel Gsteiger <Marcel(dot)Gsteiger(at)milprog(dot)ch> 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.
>
> Any idea would much be appreciated.

Note that dns lookups can be slow and that might cause some issues for you
if it leaves resources needed for other queries locked while the function
waits for a response.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2005-10-29 16:36:50 Re: difficulty formating interval datatypes in 7.4
Previous Message Tino Wildenhain 2005-10-29 15:39:30 Re: which charset use for cyrilic?