Re: Does PG have a database

From: Markus Schaber <schabi(at)logix-tt(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Does PG have a database
Date: 2006-05-22 17:52:49
Message-ID: 4471FA71.1050607@logix-tt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Manlio Perillo 2006-05-22 17:59:28 Re: Does PG have a database
Previous Message Mark Fenbers 2006-05-22 16:28:41 Does PG have a database