PostgreSQL network discovery

Gevik Babakhani wrote:

Hi,

There is a nice little feature within MSSQL where it is possible to
enumerate all MSSQL servers on the local network.
I wonder how this can be made possible with PG. Pinging every IP:PGPORT
within the current subnet is one of the options but I guess that would be
just a bad solution. Any thoughts?

Isn't the bonjour support supposed to do this?
(Never used it myself though)

//Magnus

Gevik Babakhani wrote:

Hi,

There is a nice little feature within MSSQL where it is possible to
enumerate all MSSQL servers on the local network.
I wonder how this can be made possible with PG. Pinging every IP:PGPORT
within the current subnet is one of the options but I guess that would be
just a bad solution. Any thoughts?

We have rendezvous support too. We need to update it to use the newer
Avahi library, but the one person who proposed using the thread
interface got scolded for that and fled :-) The interface we'd need to
use is complex and the patch would be a lot bigger.

If you want to work on it, you're welcome to do so :-)

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

If I am not mistaken, it only works fine on OSX environments. (I might be
very wrong here)

I asked this question because I have a situation where a service like this
would be very useful. If such a functionality would be accepted by the core
team, I am willing to work on it.

"Gevik Babakhani" <pgdev@xs4all.nl> writes:

I asked this question because I have a situation where a service like this
would be very useful. If such a functionality would be accepted by the core
team, I am willing to work on it.

The existing code uses APIs that Apple has deprecated, so it's going to
need to be fixed sooner or later. The issue isn't whether to fix it,
it's how to not introduce any unwanted dependencies (like threading...)

regards, tom lane