In general, you should refer to your database administrator to perform administrative tasks with your PostgreSQL DB. However, there is a set of tools packaged for PostgreSQL databases, named pgadmin, which is available at https://www.pgadmin.org/download/.
The two most common activities seen are:
o PostgreSQL database compression
o PostgreSQL database reindexing.