On Wed, Oct 09, 2019 at 02:59:17PM -0400, melvin6925 wrote:
> Have you tried a VACUUM FULL of the db?Sent via the Samsung Galaxy S?? 6, an
> AT&T 4G LTE smartphone
> -------- Original message --------From: stan <st...@panix.com> Date: 10/9/19
> 14:54 (GMT-05:00) To: melvin6925 <melvin6...@gmail.com> Subject: Re: I
> messed up and my disk utlization is HUGE On Wed, Oct 09, 2019 at 01:30:33PM
> -0400, melvin6925 wrote:> >How can I shrink this back to a>reasonable
> size???Have you tried a vacuum full of the db?Sent via the Samsung Galaxy S??
> 6, an AT&T 4G LTE smartphone> -------- Original message --------From: stan
> <st...@panix.com> Date: 10/9/19?? 13:21?? (GMT-05:00) To:
> pgsql-general@lists.postgresql.org Subject: I messed up and my disk
> utlization is HUGE I was going to try to do some testing on very large
> databases, and I tried toload the Mouse Gerome DB. It failed, and now I know
> why :-) I filled thedisk up. Presently, with virtually nothing in any
> database the postgresstorage location has 43G allocated. The DB was also
> crashed but i did freeup some space and get it started again. How can I
> shrink this back to areasonable size? The WAL also seems pretty large.--
> "They that would give up essential liberty for temporary safety
> deserveneither liberty nor safety."
> -- Benjamin FranklinSorry your reply was garbled.-- "They that would
> give up essential liberty for temporary safety deserveneither liberty nor
> safety." -- Benjamin Franklin
I ran vacuumdb from the comand line as postgres , which I beleive does
this. Did not take very long to run BTW.
--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
-- Benjamin Franklin
