# Clean up (or validate) Postgres data?

**URL:** https://meta.discourse.org/t/clean-up-or-validate-postgres-data/168668
**Category:** Self-hosting
**Created:** [October 29, 2020, 6:16pm UTC](https://meta.discourse.org/t/clean-up-or-validate-postgres-data/168668 "2020-10-29T18:16:09Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![wincenworks](https://avatars.discourse-cdn.com/v4/letter/w/96bed5/32.png) [@wincenworks](https://meta.discourse.org/u/wincenworks)
#### Post date: [October 29, 2020, 6:16pm UTC](https://meta.discourse.org/t/clean-up-or-validate-postgres-data/168668/1 "2020-10-29T18:16:09Z")

</div>

Hi,

There’s been some ongoing issues with server stability with my cloud service and it appears one of them interfered with my latest update and has created some broken interface issues.

So I attempted to pull a fresh copy and do a rebuild, and it failed due to me apparently needing a further 16 gigs of disk space to update postgres.

I know my members are a chatty bunch, but this seems excessive:

 ![image](https://global.discourse-cdn.com/meta/original/3X/0/a/0a7f196b22d7e2131c13391824d789c473e0b11c.png)

I’ve done some cleanups and they’ve freed up about 16 gig previously, and the most recent one cleaned up 2.3 gig - however I was wondering if there’s any way to confirm if the postgres is fine, maybe run a cleanup on it, etc?

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [October 31, 2020, 10:22pm UTC](https://meta.discourse.org/t/clean-up-or-validate-postgres-data/168668/2 "2020-10-31T22:22:19Z")

</div>

I assume you’ve already done

`./launcher cleanup`

and

`apt-get autoclean`  
`apt-get autoremove`

You can do a full vacuum on your postgres database, too, if you want to make sure it is totally ship-shape. This can also clean up some space in the database. See [Recover from a very slow database](https://meta.discourse.org/t/how-to-recover-from-a-very-slow-database/68793)

---

<div class="post-metadata">

### Author: ![wincenworks](https://avatars.discourse-cdn.com/v4/letter/w/96bed5/32.png) [@wincenworks](https://meta.discourse.org/u/wincenworks)
#### Post date: [November 1, 2020, 12:41am UTC](https://meta.discourse.org/t/clean-up-or-validate-postgres-data/168668/3 "2020-11-01T00:41:54Z")

</div>

I’ve done a few launcher cleanups, they don’t seem to effect the postgres database size.

The full vacuum seems to have shaved 5 gig off my postgres data.

While trying to do a full vacuum I received this error (shown here after I did it again in verbose):

 ![image](https://global.discourse-cdn.com/meta/original/3X/f/b/fbe2f66ad391fe26a98a83d9c0e39172516e22bb.png)

I also tried doing a reindex and received this error:

 ![image](https://global.discourse-cdn.com/meta/original/3X/4/1/4154b6ce0e82176c3d62cfc197f9bde70f42a342.png)

Is there anything I can/should do about these or just reattempt rebuilding/upgrading?

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [December 1, 2020, 12:50am UTC](https://meta.discourse.org/t/clean-up-or-validate-postgres-data/168668/4 "2020-12-01T00:50:58Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.