Re: SOLVED Re: Recovering disk space

>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 <stanb(at)panix(dot)com> 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!