Recovering disk space

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Recovering disk space

stan-9
Sorry to repeat this, I am still in trouble on it.

I made the mistake of trying to import the mouse gnome database in an
effort to do some testing with very large data sets.

This import failed, probably because I ran out of disk space.  I deleted the
dump file, and a few other things, and now I have a bit of disk space.
Looks like I see the mad schema both in the postfres db, and in my own
stan db/ I did a drop schema cascade on both as the db superuser, and ran
vacuum full on both. This command came back almost instantly, which
surprises me.

However, my 50G disk is still 96% full. How can I recover the disk space I
seem to have used u doing this?


--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                                                -- Benjamin Franklin


Reply | Threaded
Open this post in threaded view
|

SOLVED Re: Recovering disk space

stan-9
OOK, after  a period of time, I recovered my disk space.

On Thu, Oct 10, 2019 at 03:57:00AM -0400, stan wrote:

> Sorry to repeat this, I am still in trouble on it.
>
> I made the mistake of trying to import the mouse gnome database in an
> effort to do some testing with very large data sets.
>
> This import failed, probably because I ran out of disk space.  I deleted the
> dump file, and a few other things, and now I have a bit of disk space.
> Looks like I see the mad schema both in the postfres db, and in my own
> stan db/ I did a drop schema cascade on both as the db superuser, and ran
> vacuum full on both. This command came back almost instantly, which
> surprises me.
>
> However, my 50G disk is still 96% full. How can I recover the disk space I
> seem to have used u doing this?
>
>
> --
> "They that would give up essential liberty for temporary safety deserve
> neither liberty nor safety."
> -- Benjamin Franklin
>
>

--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                                                -- Benjamin Franklin


Reply | Threaded
Open this post in threaded view
|

Re: SOLVED Re: Recovering disk space

Melvin Davidson-5
>OOK, after  a period of time, I recovered my disk space.

Stan, for those of us that have lost the ability to long distance mind read, would you please
inform us of the steps you took to solve the problem? It might be helpful in the future to someone
else in the same situation. It might also be useful to include the O/S and PostgreSQL version.


On Thu, Oct 10, 2019 at 4:01 AM stan <[hidden email]> wrote:
OOK, after  a period of time, I recovered my disk space.

On Thu, Oct 10, 2019 at 03:57:00AM -0400, stan wrote:
> Sorry to repeat this, I am still in trouble on it.
>
> I made the mistake of trying to import the mouse gnome database in an
> effort to do some testing with very large data sets.
>
> This import failed, probably because I ran out of disk space.  I deleted the
> dump file, and a few other things, and now I have a bit of disk space.
> Looks like I see the mad schema both in the postfres db, and in my own
> stan db/ I did a drop schema cascade on both as the db superuser, and ran
> vacuum full on both. This command came back almost instantly, which
> surprises me.
>
> However, my 50G disk is still 96% full. How can I recover the disk space I
> seem to have used u doing this?
>
>
> --
> "They that would give up essential liberty for temporary safety deserve
> neither liberty nor safety."
>                                               -- Benjamin Franklin
>
>

--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                                                -- Benjamin Franklin




--
Melvin Davidson
Maj. Database & Exploration Specialist

Universe Exploration Command – UXC

Employment by invitation only!