Okay, we’ve settled on a single postgresql snap with tracks, as described in Please create tracks for postgres snap.
That narrows down the list of aliases we need for postgresql to the following:
clusterdb
createdb
createlang
createuser
dropdb
droplang
dropuser
ecpg
initdb
oid2name
pg_archivecleanup
pg_basebackup
pg_config
pg_controldata
pg_ctl
pg_dump
pg_dumpall
pg_isready
pg_receivewal
pg_receivexlog
pg_recvlogical
pg_resetwal
pg_resetxlog
pg_restore
pg_rewind
pg_standby
pg_test_fsync
pg_test_timing
pg_upgrade
pg_waldump
pg_xlogdump
pgbench
pltcl_delmod
pltcl_listmod
pltcl_loadmod
postgres
postmaster
psql
reindexdb
vacuumdb
vacuumlo
These are all commands people normally associate with PostgreSQL. I think it’s reasonable that they not have to type postgresql.postgres to reach them.
We’ll be adding a few more once finished snapping PostgreSQL 11.