Releases: Azmodey/pg_dba_scripts
Version 1.10.0
Version 1.9.0
Added support for Ubuntu 20.04.
Version 1.8.0
Added support for Debian 10.
Simplifying the settings.txt file.
Version 1.7.0
To all scripts added support for PostgreSQL 9.6.
Minor fixes and improvements.
Version 1.6.0
To all scripts added support for PostgreSQL versions 10 and 11.
pg_database_status.sh - added display of network connection.
Version 1.5.0
pg_database_information.sh - a script that provides a single tape with the current status of a group of PostgreSQL servers, allowing you to quickly find out what the servers are doing and see the exact data for logical replication and external tables.
- Displays server time and lag time, hostname and IP address, PostgreSQL version and status (Master / Replica), data checksums.
- Statistics are also displayed on databases, waits and locks, archive and replication statuses.
- For logical replication, information about publications and subscriptions in the target databases is displayed.
- Displays information about external servers, associated with them by users and tables.
- Blocked sessions and a tree with their locks are displayed, as well as a list of long-running requests.
- When activities occur in PostgreSQL, the progress of operations is displayed: vacuum, vacuum full or cluster, index creation, analyze, pg_basebackup.
pg_database_hugepages.sh - added display of Transparent Huge Pages (THP).
Version 1.2.0
Minor fixes.
Version 1.1.0
pg_database_activity.sh - added displaying the status of streaming and logical replication for replica servers.
Version 1.0.0
Initial release.