I messed up and my disk utlization is HUGE - Mailing list pgsql-general

From stan
Subject I messed up and my disk utlization is HUGE
Date
Msg-id 20191009172119.GA2673@panix.com
Whole thread Raw
List pgsql-general
I was going to try to do some testing on very large databases, and I tried to
load the Mouse Gerome DB. It failed, and now I know why :-) I filled the
disk up. Presently, with virtually nothing in any database the postgres
storage location has 43G allocated. The DB was also crashed but i did free
up some space and get it started again. How can I shrink this back to a
reasonable size? The WAL also seems pretty large.



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



pgsql-general by date:

Previous
From: Sonam Sharma
Date:
Subject: Repmgr and pglogical
Next
From: Alvaro Herrera
Date:
Subject: Re: Pg11 -- MultiXactId xxxx has not been created yet -- apparentwraparound