PostgreSQL Database 'Information' Script - is there one out there? - Mailing list pgsql-admin

From Edwin UY
Subject PostgreSQL Database 'Information' Script - is there one out there?
Date
Msg-id CA+wokJ-C+M8Kw8JrdoH5qn25B2fz0beyLOxVSMTN5g6_NUqDAA@mail.gmail.com
Whole thread Raw
Responses Re: PostgreSQL Database 'Information' Script - is there one out there?
Re: PostgreSQL Database 'Information' Script - is there one out there?
List pgsql-admin
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.


pgsql-admin by date:

Previous
From: Samuel VISCAPI
Date:
Subject: RE: 2nd PostgreSQL server in WAL shipping cluster fails to start
Next
From: Laurenz Albe
Date:
Subject: Re: Partition management - best practices and avoid long access exclusive lock during partition creation