Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 34AC51337B8D
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 17 Nov 2010 16:56:48 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 88480-07-2
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 17 Nov 2010 20:56:40 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail.int.journyx.com (mail.journyx.com [66.219.41.227])
	by mail.postgresql.org (Postfix) with ESMTP id 633F11337B93
	for <pgsql-admin@postgresql.org>; Wed, 17 Nov 2010 16:56:37 -0400 (AST)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by mail.int.journyx.com (Postfix) with ESMTP id 244EDC488D;
	Wed, 17 Nov 2010 14:56:36 -0600 (CST)
X-Virus-Scanned: amavisd-new at zimbra.int.journyx.com
Received: from mail.int.journyx.com ([127.0.0.1])
	by localhost (mail.int.journyx.com [127.0.0.1]) (amavisd-new,
	port 10024)
	with ESMTP id Dy-JdiZN0YGn; Wed, 17 Nov 2010 14:56:22 -0600 (CST)
Received: from mail.int.journyx.com (zimbra.int.journyx.com [192.168.100.5])
	by mail.int.journyx.com (Postfix) with ESMTP id 3D6B0C488E;
	Wed, 17 Nov 2010 14:56:22 -0600 (CST)
Date: Wed, 17 Nov 2010 14:56:22 -0600 (CST)
From: Scott Whitney <scott@journyx.com>
Reply-To: Scott Whitney <swhitney@journyx.com>
To: Frederiko Costa <frederiko@gmail.com>
Cc: pgsql-admin@postgresql.org, ojas dubey <ojas.dubey@gmail.com>
Message-ID: 
 <31372072.18703.1290027382116.JavaMail.root@zimbra.int.journyx.com>
In-Reply-To: <AANLkTimsOkgBCp+=erY8B5n6GNuUQ1_cu-7KxFneekQZ@mail.gmail.com>
Subject: Re: Find all running postgres DB servers on a network
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_18702_6606938.1290027382113"
X-Originating-IP: [192.168.100.188]
X-Mailer: Zimbra 6.0.6_GA_2331.RHEL4 (ZimbraWebClient - FF3.0
	(Win)/6.0.6_GA_2331.RHEL4)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.909 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201011/141
X-Sequence-Number: 36107

------=_Part_18702_6606938.1290027382113
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

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 
> 


------=_Part_18702_6606938.1290027382113
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><style type=3D'text/css'>p { margin: 0; }</style></head><body><=
div style=3D'font-family: Times New Roman; font-size: 12pt; color: #000000'=
>That only works in the event that you have PG listening on port 5432.<br><=
br>A product like Spiceworks will provide much more detail, presuming you h=
ave the IT credentials to talk to the machines.<br><br><hr><blockquote styl=
e=3D"border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-lef=
t: 5px;">nmap is the way to go. Try to scan for port 5432 in a range of IP =
of your<br>LAN.<br><br>~Fred<br>Linkedin profile: http://www.linkedin.com/i=
n/frederikocosta<br><br><br>On Sun, Nov 14, 2010 at 8:52 AM, ojas dubey &lt=
;ojas.dubey@gmail.com&gt; wrote:<br><br>&gt; Hi,<br>&gt;<br>&gt; I wanted t=
o know if there is a way to get the hostnames of all the systems<br>&gt; ru=
nning PostGres DB servers on a local network on Windows (XP/Vista/7) using<=
br>&gt; JDBC or any other Java API ?<br>&gt;<br>&gt;<br>&gt; Regards,<br>&g=
t; Ojas<br>&gt;<br></blockquote><br></div></body></html>
------=_Part_18702_6606938.1290027382113--