PostgreSQL database compression

Steps

1.  Stop the Application Server and then the Database Server.

2.  Make a copy of the DB data folder.

3.  Start pgadmin and go to VACUUM FULL ANALYZE Maintenance:

 

 

4.  Review the log of the process: