Re: [ADMIN] Find all running postgres DB servers on a network

2011-01-06 Thread ojas dubey
Hi everyone, I have to bring this up again. I ran the nmap command *nmap --open -sV -p5432 -oG dbserverlist.txt 172.28.26.0/24 *to scan the network for running instances of Postgres servers on my network. The serverlist had the following output: (I am excluding the IP addresses with Status:Down to

Re: [ADMIN] Find all running postgres DB servers on a network

2010-11-23 Thread tt
On Nov 14, 11:52 am, ojas.du...@gmail.com (ojas dubey) 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 Hi, JDisc Discovery

Re: [ADMIN] Find all running postgres DB servers on a network

2010-11-18 Thread ojas dubey
Thank you Rich,Fred,Scott,Viktor and Gerard for your replies. Actually I am neither the system administrator nor the person who set up all the servers. I am developing an application which would provide the user with a list of running Postgres DB servers from which the user can select one. So I wa

Re: [ADMIN] Find all running postgres DB servers on a network

2010-11-18 Thread Frederiko Costa
I believe in this case you will have to talk with the sysadmin and have an agreement about this requirement for your application. I don't know about Spiceworks, but I see nmap as an application working on layer 3/4, so you may be subject to firewall rules or anything defined in the security policy.

Re: [ADMIN] Find all running postgres DB servers on a network

2010-11-17 Thread Rich
Use nmap. Unless you deliberately changed the IP port you should have no problem. Are you the one who setup all the servers? On Wed, Nov 17, 2010 at 4:03 PM, Frederiko Costa wrote: > True. However, I was just assuming that Postgres was running on default > ports. If not, you could also probe in

Re: [ADMIN] Find all running postgres DB servers on a network

2010-11-17 Thread Frederiko Costa
True. However, I was just assuming that Postgres was running on default ports. If not, you could also probe in port ranges or even probe the network for open ports to have an idea and get closer. It might be faster option if software such as Spiceworks is not being used. Spiceworks looks a good op

Re: [ADMIN] Find all running postgres DB servers on a network

2010-11-17 Thread Scott Whitney
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 pro

Re: [ADMIN] Find all running postgres DB servers on a network

2010-11-17 Thread Frederiko Costa
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 wrote: > Hi, > > I wanted to know if there is a way to get the hostnames of all the systems > running Pos

Re: [ADMIN] Find all running postgres DB servers on a network

2010-11-15 Thread Viktor Bojović
On Sun, Nov 14, 2010 at 5:52 PM, ojas dubey 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 > try to scan ports for eac

Re: [ADMIN] Find all running postgres DB servers on a network

2010-11-15 Thread Gerhard Hintermayer
You could try connecting to each possible IP in your network, but to catch each instance, you should also check nostandard (i.e. different from 5432) ports - kind of hacking ...  AFAIK (or read ;-) ) Rendezvous/bonjour was implemented on OS X port only. regards Gerhard On Sun, Nov 14, 2010 at 5:5

[ADMIN] Find all running postgres DB servers on a network

2010-11-15 Thread ojas dubey
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