X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id E0F5D9F9D99
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 22 May 2006 14:53:13 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 79952-06
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 22 May 2006 14:53:09 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from moutng.kundenserver.de (moutng.kundenserver.de
	[212.227.126.187])
	by postgresql.org (Postfix) with ESMTP id C70629F9B01
	for <pgsql-sql@postgresql.org>; Mon, 22 May 2006 14:53:08 -0300 (ADT)
Received: from [134.60.236.94] (helo=lunix.schabi.de)
	by mrelayeu.kundenserver.de (node=mrelayeu4) with ESMTP (Nemesis),
	id 0ML21M-1FiEaW07pN-0003kx; Mon, 22 May 2006 19:53:04 +0200
Received: from [127.0.0.1] (localhost [127.0.0.1])
	by lunix.schabi.de (Postfix) with ESMTP id BCB051EDAD2
	for <pgsql-sql@postgresql.org>; Mon, 22 May 2006 19:52:50 +0200 (CEST)
Message-ID: <4471FA71.1050607@logix-tt.com>
Date: Mon, 22 May 2006 19:52:49 +0200
From: Markus Schaber <schabi@logix-tt.com>
User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051017)
X-Accept-Language: de-DE, de, en-us, en
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: Does PG have a database
References: <4471E6B9.9080002@noaa.gov>
In-Reply-To: <4471E6B9.9080002@noaa.gov>
X-Enigmail-Version: 0.93.0.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Provags-ID: kundenserver.de abuse@kundenserver.de
	login:a9554655f07a4e401310f2acfb43f5bf
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200605/168
X-Sequence-Number: 25199

Hi, Mark,

Mark Fenbers schrieb:

> Bottom line:  What trick can I use to determine whether a box has a
> living, breathing Pg database if I don't know the DB owner?

If all your Postmasters run on the default port, use nmap on the port,
so you see that postmasters are running there. When they run, then there
must be a cluster with databases, at least the template ones.

If your "baseline distro" is debian, ssh into the machines, and do
pg_lsclusters.

HTH,
Markus