DBA tasks#
- Create additional PostgreSQL® databases
- Perform a PostgreSQL® major version upgrade
- Install or update an extension
- Create manual PostgreSQL® backups
- Restore PostgreSQL® from a backup
- Migrate to a different cloud provider or region
- Claim public schema ownership
- Manage connection pooling
- Access PgBouncer statistics
- Use the PostgreSQL®
dblink
extension - Use the PostgreSQL®
pg_repack
extension - Enable JIT in PostgreSQL®
- Identify and repair issues with PostgreSQL® indexes with
REINDEX
- Identify PostgreSQL® slow queries
- Detect and terminate long-running queries
- Optimize PostgreSQL® slow queries
- Check and avoid transaction ID wraparound
- Prevent PostgreSQL® full disk issues