Re: function that resolves IP addresses - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: function that resolves IP addresses
Date
Msg-id 20051029161806.GA13786@wolff.to
Whole thread Raw
In response to function that resolves IP addresses  ("Marcel Gsteiger" <Marcel.Gsteiger@milprog.ch>)
Responses Re: function that resolves IP addresses  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
On Wed, Oct 19, 2005 at 14:36:46 +0200,
  Marcel Gsteiger <Marcel.Gsteiger@milprog.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.

pgsql-general by date:

Previous
From: Tino Wildenhain
Date:
Subject: Re: which charset use for cyrilic?
Next
From: Matthew Peter
Date:
Subject: dynamic table naming in function