SOLVED Re: Recovering disk space

From: stan <stanb(at)panix(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: SOLVED Re: Recovering disk space
Date: 2019-10-10 08:01:42
Message-ID: 20191010080142.GA23150@panix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Wim Bertels 2019-10-10 08:31:37 Re: Is my lecturer wrong about PostgreSQL? I think he is!
Previous Message stan 2019-10-10 07:57:00 Recovering disk space