postgres tool - ghdrako/doc_snipets GitHub Wiki

Tools	Description
psql	PostgreSQL Interactive Terminal
createdb	create a new PostgreSQL database
clusterdb	cluster a PostgreSQL database
dropdb	remove a PostgreSQL database
createuser	define a new PostgreSQL user account
dropuser	remove a PostgreSQL user account
epcgembedded SQL C pre-processor
pg_dump	extract a PostgreSQL database into a script file or
other archive file
pg_dumpall	extract a PostgreSQL database cluster into a script file
pg_config	retrieve information about the installed version of
PostgreSQL
pgbenchrun	a benchmark test on PostgreSQL
pg_basebackup	take a base backup of a PostgreSQL cluster
pg_verifybackup	verify the integrity of a base backup of a PostgreSQL cluster
pg_restore	restore a PostgreSQL database from an archive file
created by pg_dump
pg_amcheck	checks for corruption in one or more PostgreSQL da
tabases
pg_isready	check the connection status of a PostgreSQL server
pg_receivewal	stream write-ahead logs from a PostgreSQL server
pg_recvlogical	control PostgreSQL logical decoding streams
reindexdb	reindex a PostgreSQL database
vacuumdb	garbage-collect and analyse a PostgreSQL database

• https://postgresql.us/events/pgopen2019/sessions/session/622/slides/48/terminal-tools.pdf Open source projects
• postgresql_is_enough] - list of tools
• pg_top - Display PostgreSQL processes https://pg_top.gitlab.io/
• pg_systat - Display PostgreSQL statistics https://pg_systat.gitlab.io/
• pg_proctab - PostgreSQL extension to query operating system process table https://pg_proctab.gitlab.io
• pgroll
  • https://xata.io/blog/pgroll-schema-migrations-postgres
  • https://github.com/xataio/pgroll
  • https://fabianlindfors.se/blog/schema-migrations-in-postgres/
  • https://medium.com/miro-engineering/sql-migrations-in-postgresql-part-1-bc38ec1cbe75
  • https://medium.com/miro-engineering/handling-databases-from-a-developers-perspective-fc916ab3fe68
• https://pgbackrest.org/
• pgLoader - fully automated tool used to load data in Postgres, and also to migrate a whole database in a single comman
  • https://pgloader.io/

pgloader mysql://user@host/dbname pgsql://user@host/dbname

• pgVersion - PostgreSQL Version Manager - tool to manage multiple PostgreSQL installations
  • https://github.com/guedes/pgvm
• pgActivity - is a top like application for PostgreSQL server activity monitoring.
  • https://github.com/dalibo/pg_activity
• pgTop
• pgView - Get a detailed, real-time view of your PostgreSQL database and system metrics
  • https://github.com//zalando/pg_view
• pgPool II - middleware that works between PostgreSQL servers and a PostgreSQL database client.
  • https://www.pgpool.net/mediawiki/index.php/Main_Page
• pgWatch2 - PostgreSQL metrics monitor/dashboard
  • https://github.com/cybertec-postgresql/pgwatch2
• PGObserver - monitoring solution for your PostgreSQL databases
• pgBarman - implement disaster recovery solutions for PostgreSQL databases. Taking an online hot backup of PostgreSQL
  • https://pgbarman.org/
• Patroni - template for PostgreSQL High Availability with Etcd, Consul, ZooKeeper, or Kubernetes
  • https://github.com/zalando/patroni
• pgTAP - unit test database
  • https://pgtap.org/
• • pgbadger

Alerting

• check_postgres
  • https://bucardo.org/check_postgres/
• tail_n_mail
  • https://github.com/bucardo/tail_n_mail

Monitoring