You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

1.4 KiB

apt install pg-activity pgtop sudo su - postgres pg_activity pg_top

Consider:

Analysis, on pg server:

pg-activity

pgtop

Analysis, separate server. See powa/ dir.

PoWa:

postgresql-10-powa -- Workload analyzer

postgresql-10-pg-qualstats

postgresql-10-pg-stat-kcache

postgresql-10-hypopg - PostgreSQL extension adding support for hypothetical indexes.

pgbadger - Fast PostgreSQL log analysis report

pgcluu - PostgreSQL performance monitoring and auditing tool

postgresql-10-pgaudit

Administration, separate server:

pgadmin -- web admin

tora (workstation) -- graphical toolkit for database developers and administrators. Ancient version in Debian, no postgres.

pgmodeler - PostgreSQL database modeler GUI interface

Report generation:

openrpt - graphical SQL report writer, designer and rendering engine

Backups:

autopostgresqlbackup - Automated tool to make periodic backups of PostgreSQL databases

backupninja - lightweight, extensible meta-backup system

barman - Backup and Recovery Manager for PostgreSQL

pgbackrest - Reliable PostgreSQL Backup & Restore

pg-backup-ctl - backup and recover PostgreSQL using log archiving

Misc

pspg - PostgreSQL pager

pgcli -- command line

##############################################################################

XXX

log_timezone = 'Navajo' ##############################################################################