Decreasing the size of the postgresql DB

[Gawuss]

Hi. I came across this article (http://www.linuxinsight.com/optimize...base_size.html) on optimizing the postgresql db size and I was wondering if the last option (dump and restore) could be applied to a HM database without losing any data etc. I have done the vacuum analyze reindex thingy but I need more space on my hard drive. Can I safely proceed with the instructions given in the article?

Thanks in advance for your help!

[netsrak]

A dump/restore will not affect the database structure so you can try it. But i recommend doing a backup before trying it.
But please be warned that both the dump and the backup temporary need free space on your HDD, if there is not enough both will fail.