domino66
09-01-2008, 08:42 PM
Here's the problem > I tried to RESTORE the big HEM DB I created on my desktop on my laptop (which has a 120GB HD).
In a .backedup state, it was 3.55 GB, and there was 22GB of free space on my laptop, which i figured would be enough to restore it. I was wrong, and the PGADMIN III window gave me an error about 2 hrs into the RESTORE procedure; sure enough, I checked my HD, and there was only 3 MB of free space, so i had definitely run out of space to do the full restore.
Here's the problem > I have no clue how to tell either HEM or PGAmin to remove from my HD whatever portion of the DB it was able to restore. Basically, I just want to remove it whatever portion of the DB was restored and reclaim those 22GB of HD space, then decide what other things to delete from my HD and try again.
But the name of the HEM DB that I guess was partially restored doesn't show up when I open up PGAdmin, and also isn't in the Database Management window of HEM itself. In other words, I'm now sitting here with a laptop that has zero free space on its HD and no clue how to tell it to simply delete the massive postgres database that i told it to restore (but turns out i did not have enough space to finish the task).
What should I do?
In a .backedup state, it was 3.55 GB, and there was 22GB of free space on my laptop, which i figured would be enough to restore it. I was wrong, and the PGADMIN III window gave me an error about 2 hrs into the RESTORE procedure; sure enough, I checked my HD, and there was only 3 MB of free space, so i had definitely run out of space to do the full restore.
Here's the problem > I have no clue how to tell either HEM or PGAmin to remove from my HD whatever portion of the DB it was able to restore. Basically, I just want to remove it whatever portion of the DB was restored and reclaim those 22GB of HD space, then decide what other things to delete from my HD and try again.
But the name of the HEM DB that I guess was partially restored doesn't show up when I open up PGAdmin, and also isn't in the Database Management window of HEM itself. In other words, I'm now sitting here with a laptop that has zero free space on its HD and no clue how to tell it to simply delete the massive postgres database that i told it to restore (but turns out i did not have enough space to finish the task).
What should I do?