Re: Find all running postgres DB servers on a network

From: Scott Whitney <scott(at)journyx(dot)com>
To: Frederiko Costa <frederiko(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, ojas dubey <ojas(dot)dubey(at)gmail(dot)com>
Subject: Re: Find all running postgres DB servers on a network
Date: 2010-11-17 20:56:22
Message-ID: 31372072.18703.1290027382116.JavaMail.root@zimbra.int.journyx.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

That only works in the event that you have PG listening on port 5432.

A product like Spiceworks will provide much more detail, presuming you have the IT credentials to talk to the machines.

nmap is the way to go. Try to scan for port 5432 in a range of IP of your
LAN.

~Fred
Linkedin profile: http://www.linkedin.com/in/frederikocosta

On Sun, Nov 14, 2010 at 8:52 AM, ojas dubey <ojas(dot)dubey(at)gmail(dot)com> wrote:

> Hi,
>
> I wanted to know if there is a way to get the hostnames of all the systems
> running PostGres DB servers on a local network on Windows (XP/Vista/7) using
> JDBC or any other Java API ?
>
>
> Regards,
> Ojas
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Frederiko Costa 2010-11-17 21:03:52 Re: Find all running postgres DB servers on a network
Previous Message Frederiko Costa 2010-11-17 20:53:33 Re: Find all running postgres DB servers on a network