pgSherpa: a free PostgreSQL monitoring companion for macOS

Поиск
Список
Период
Сортировка
Искать

pgSherpa: a free PostgreSQL monitoring companion for macOS

От:
CortexRidge via PostgreSQL Announce <announce-noreply@postgresql.org>
Дата:
 

pgSherpa: a free PostgreSQL monitoring companion for macOS

CortexRidge has released pgSherpa, a free desktop companion for PostgreSQL on macOS, now available on the Mac App Store.

pgSherpa sits in a corner of the screen and polls one or more PostgreSQL servers (PostgreSQL 12 to 18). When something needs attention it says so in a sentence, with the rows behind it:

  • Health: lock-wait chains, long-running and idle-in-transaction sessions, replication lag and replication slots, vacuum and transaction ID wraparound, connection limits.
  • Security: the server's version compared with the latest PostgreSQL minor release and the CVEs fixed since, plus configuration such as SSL, MD5 passwords and superuser count.
  • Cloud: backups, failovers, maintenance windows and replicas for DigitalOcean Managed Databases, Supabase and Amazon RDS / Aurora PostgreSQL, read from the provider's API.
  • SQL: a query box with PostgreSQL completion and \h syntax help for the server's own version. Every statement runs in a read-only transaction unless the user switches it to write.
  • Reports: ready-made views of pg_stat_activity, pg_locks, pg_stat_statements, vacuum progress, indexes and replication.

pgSherpa needs only a role with pg_monitor. It installs no extension and no agent on the server, and it has no account and no telemetry; passwords and keys stay in the macOS Keychain.

It runs on macOS 12 or later, on Apple silicon and Intel Macs.

This email was sent to you from CortexRidge. It was delivered on their behalf by the PostgreSQL project. Any questions about the content of the message should be sent to CortexRidge.

You were sent this email as a subscriber of the pgsql-announce mailinglist, for the content tag Related Proprietary. To unsubscribe from further emails, or change which emails you want to receive, please click the personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
FAQ