Re: Does PG have a database - Mailing list pgsql-sql

From Markus Schaber
Subject Re: Does PG have a database
Date
Msg-id 4471FA71.1050607@logix-tt.com
Whole thread Raw
In response to Does PG have a database  (Mark Fenbers <Mark.Fenbers@noaa.gov>)
List 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


pgsql-sql by date:

Previous
From: Mark Fenbers
Date:
Subject: Does PG have a database
Next
From: Manlio Perillo
Date:
Subject: Re: Does PG have a database