What administration utilities does Ubuntu and Debian package with PostgreSQL?

Question

I see that there are a lot of tools authored by Ubuntu and Debian for PostgreSQL? Does any one have a list of them, or the build-differences?

Answer 1

Here is the Ubuntu-specific management utilities,

pg_archivecleanup
pg_basebackup
pg_config
pg_conftool
pg_createcluster
pg_ctlcluster
pg_dropcluster
pg_dump
pg_dumpall
pg_isready
pg_lsclusters
pg_receivexlog
pg_recvlogical
pg_renamecluster
pg_restore
pg_upgradecluster
pg_virtualenv

There are some other subtle differences with the variants provided upstream. Because Ubuntu is capable of running multiple PostgreSQL's of different versions, it distributes but disables some of their utilities (like pg_ctl as addressed in this question). In place of those utilities, it simplifies use with service [start|stop|restart|reload] postgresql and pg_ctlcluster.

Answer 2

I think what gets mostly added is in the postgresql-common package. As can be seen in the package page, it seems to provide us the following utilities: pg_conftool, pg_createcluster, pg_ctlcluster, pg_dropcluster, pg_lsclusters, pg_renamecluster, pg_upgradecluster, pg_virtualenv.

If you have a look at the package itself in Debian, one can find:

• pg_buildext
• pg_checksystem
• pg_config
• pg_conftool
• pg_createcluster
• pg_ctlcluster
• pg_dropcluster
• pg_lsclusters
• pg_renamecluster
• pg_updatedicts
• pg_upgradecluster
• pg_virtualenv
• pg_wrapper

You could also edit some of the files this package provides if want different parameters than what the Debian maintainers chose, for example like enabling data checksum by default.