A tool to inventory a database is always useful for administrations tasks, backup planning and monitoring, migrations, capacity management, forecasts, releasing new applications’ versions into Production, code management of database objects, etc.

I have recently needed a tool to retrieve information about objects, database setup and space of a PostgreSQL database cluster. I couldn’t find a script to dump all the information, so I developed mine. I share it with you here.
My inventory tool includes information about:

• Cluster’s information
• List of databases
• List of schemas
• List of foreign servers
• Space
• Objects’ DDLs
• Permissions