PDA

View Full Version : Decreasing the size of the db



Gawuss
05-02-2014, 09:44 AM
Hi. I wanted to free up some space on my hard drive and I found a folder full of 16mb files which amount to almost 3gb. It's called pg_xlog in the PostgreSQL folder. Can I delete these files without losing my HM database? I've also found huge files in the base folder (screenSHU - The fastest screen capture ever. (http://scr.hu/0wfn/4jlcz)). Can I also do something about them? I could really use some free space..

Thanks!

Patvs
05-02-2014, 06:44 PM
You can delete the files in the pg_xlog and pg_log folder.
(don't delete the folder itself, only the files inside the folder).

DO NOT delete files from the /base folder, as this is your database.
To decrease the size of the database, perform a vacuum/analyse/reindex on the database in pgadminIII.