From: Scott Whitney <scott@journyx.com>
To: Frederiko Costa <frederiko@gmail.com>
Cc: pgsql-admin@postgresql.org, ojas dubey <ojas.dubey@gmail.com>
Subject: Re: Find all running postgres DB servers on a network
Date: Wed, 17 Nov 2010 14:56:22 -0600 (CST)
Message-ID: <31372072.18703.1290027382116.JavaMail.root@zimbra.int.journyx.com> (raw)
In-Reply-To: <AANLkTimsOkgBCp+=erY8B5n6GNuUQ1_cu-7KxFneekQZ@mail.gmail.com>
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.dubey@gmail.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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott@journyx.com, frederiko@gmail.com, ojas.dubey@gmail.com
Subject: Re: Find all running postgres DB servers on a network
In-Reply-To: <31372072.18703.1290027382116.JavaMail.root@zimbra.int.journyx.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox