PLEASE MAKE SURE YOU BACKUP YOUR PUBLIC SCHEMA ! Steps: Open up pgAdmin III and connect to PostgreSQL. Select desired database and click on schemas
read moreRun command sudo apt-get install zip in termintal to install the zip. Then run zip -r compressed_filename.zip foldername command to zip a folder recursively. Reference: http://askubuntu.com/questions/27349/how-do-i-compress-a-directory
read more