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?
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
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:
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.