X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 450299DC93F for ; Tue, 10 Jan 2006 17:00:30 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 94520-01 for ; Tue, 10 Jan 2006 17:00:31 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id C9E889DC93E for ; Tue, 10 Jan 2006 17:00:27 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id k0AL0Jki003973; Tue, 10 Jan 2006 16:00:19 -0500 (EST) To: Murray Cumming cc: pgsql-interfaces Subject: Re: Detecting postgres servers In-reply-to: <1136925763.20493.8.camel@localhost.localdomain> References: <1132421658.10562.31.camel@localhost.localdomain> <1136925763.20493.8.camel@localhost.localdomain> Comments: In-reply-to Murray Cumming message dated "Tue, 10 Jan 2006 21:42:43 +0100" Date: Tue, 10 Jan 2006 16:00:19 -0500 Message-ID: <3972.1136926819@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.079 required=5 tests=[AWL=0.079] X-Spam-Score: 0.079 X-Spam-Level: X-Archive-Number: 200601/19 X-Sequence-Number: 5935 Murray Cumming writes: > On Sat, 2005-11-19 at 18:34 +0100, Murray Cumming wrote: >> Is there any way, without a username and password, to >> 1. Detect whether a Postgres server is running on a certain host on a >> certain port. >> 2. Detect whether a Postgres server is running on a certain host. >> 3. Detect whether a Postgres server is running somewhere on the local >> network, via some bonjour/rendezvous/avahi/howl-type thing? We have bonjour code, but it's written to Apple's API and hence only works on Darwin. There was some talk recently of revising that code to be more portable ... dunno if anyone is actually working on it, but check the archives. regards, tom lane