public inbox for [email protected]  

help / color / mirror / Atom feed

From: MichaelDBA <[email protected]>
To: Edwin UY <[email protected]>
Cc: [email protected]
Subject: Re: PostgreSQL Database 'Information' Script - is there one out there?
Date: Thu, 30 Jan 2025 09:37:15 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <CA+wokJ-C+M8Kw8JrdoH5qn25B2fz0beyLOxVSMTN5g6_NUqDAA@mail.gmail.com>
References: <CA+wokJ-C+M8Kw8JrdoH5qn25B2fz0beyLOxVSMTN5g6_NUqDAA@mail.gmail.com>

There are a whole bunch of extension tools out there for this type of
stuff.  Check out pgmetrics.

Regards,
Michael Vitale

Edwin UY wrote on 1/30/2025 7:13 AM:
> Hi,
>
> Does anyone know of any existing script/s out there somewhere that
> generates some kind of database/instance inventory, like listing of
> what databases exist (\l), schema (\dn) in each databases, extensions
> (\dx), user lists (\du), replication slots, tables, views, parameter
> default/non-default settings etc?
> Maybe there is already one out there, either a shell script or a SQL
> script that I can just run from psql and save the output to file.
> At the moment, running manually via psql running \l, running \c to
> each DB and running \dn,  didn't realize I have to run \dn on each
> database :(, and running select statements from pg_tables and so on.
>
>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: PostgreSQL Database 'Information' Script - is there one out there?
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox