MichaelDBA
I've been working as a DBA with relational databases since 1990. Been focused mainly on PostgreSQL since 2011.
SQLEXEC LLCAnnandale, VA USA
Pinned Repositories
get_awslogs
Simplify process of getting AWS logs for PostgreSQL using AWS CLI APIs
Global-Temporary-Tables-For-PG
pg_alert
pg_alert is a PostgreSQL log file monitoring and alerting tool.
pg_check
Based on pg_report, but only issues email/slack alerts and console output, no html output format.
pg_dumpschemas
This is a bash script which does pg dumps in parallel for all schemas in a given database as linux background jobs.
pg_get_tabledef
PostgreSQL PL/PGSQL function that generates table DDL for the given schema/table.
pg_match
Schema Comparison Tool
pg_report
This python program does a general health check on the target PostgreSQL cluster.
pg_vacuum
PostgreSQL Smart Vacuuming Tool
pgbouncer_pkg
A wrapper around the pgbouncer show commands
MichaelDBA's Repositories
MichaelDBA/pg_get_tabledef
PostgreSQL PL/PGSQL function that generates table DDL for the given schema/table.
MichaelDBA/pg_report
This python program does a general health check on the target PostgreSQL cluster.
MichaelDBA/pg_vacuum
PostgreSQL Smart Vacuuming Tool
MichaelDBA/pg_alert
pg_alert is a PostgreSQL log file monitoring and alerting tool.
MichaelDBA/pg_match
Schema Comparison Tool
MichaelDBA/get_awslogs
Simplify process of getting AWS logs for PostgreSQL using AWS CLI APIs
MichaelDBA/Global-Temporary-Tables-For-PG
MichaelDBA/pg_dumpschemas
This is a bash script which does pg dumps in parallel for all schemas in a given database as linux background jobs.
MichaelDBA/pg_check
Based on pg_report, but only issues email/slack alerts and console output, no html output format.
MichaelDBA/pgbouncer_pkg
A wrapper around the pgbouncer show commands
MichaelDBA/amazon-rds-and-amazon-aurora-logging-blog
Blog content for working with Amazon RDS and Aurora Engine Logs
MichaelDBA/booktown
Queries upon queries in Booktown, USA [sql, databases]
MichaelDBA/crunchy_check_access
Functions and views to facilitate PostgreSQL object access inspection
MichaelDBA/github.io
GitHub Pages for MichaelDBA
MichaelDBA/pg_bloat_check
Bloat check script for PostgreSQL
MichaelDBA/pg_repack
Reorganize tables in PostgreSQL databases with minimal locks
MichaelDBA/pg_statsinfo
pg_statsinfo
MichaelDBA/pgddl
DDL eXtractor functions for PostgreSQL (ddlx)