PDA

View Full Version : Decreasing the size of the postgresql DB



Gawuss
02-02-2014, 02:23 PM
Hi. I came across this article (http://www.linuxinsight.com/optimize_postgresql_database_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
02-03-2014, 05:45 AM
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.