Smali
08-22-2011, 11:15 AM
I've been using the backup/restore function to transfer my database between my laptop and desktop a few times lately as I've been moving around a lot. Just got home now and wanted to use the function to transfer the DB from my laptop to my desktop and I always get an error after a while saying there isn't enough disk space. When I first tried it this morning I think I had ~5-6 GB disk space. After getting the error I removed around 5GB and tried again, and again I got the error and had no disk space left so I removed another 7GB and tried again but to no avail. I started looking for where all this space was going, and found that postgreSQL program is taking up 105GB of my 135GB hard disk!!
As I said I've used the backup restore a couple of times already, once when moving my DB from my laptop to my new desktop, and then moving the DB to the laptop from the desktop as I was on the move. I had no problems with it then. Is there some way to do some housecleaning on the postgreSQL thingy without losing hands? Is there a minimum disk space required to perform the backup/restore function? I don't really have a lot of room to work with as it stands with the postgreSQL being this huge as I've ran out of stuff to remove from my laptop. Any help with this would be greatly appreciated.
As I said I've used the backup restore a couple of times already, once when moving my DB from my laptop to my new desktop, and then moving the DB to the laptop from the desktop as I was on the move. I had no problems with it then. Is there some way to do some housecleaning on the postgreSQL thingy without losing hands? Is there a minimum disk space required to perform the backup/restore function? I don't really have a lot of room to work with as it stands with the postgreSQL being this huge as I've ran out of stuff to remove from my laptop. Any help with this would be greatly appreciated.