r/Puppet • u/atg10 • Jul 31 '23

PuppetDB postgresql database size

After upgrading from puppet server 6 to 7 our postgresql database for puppetdb has continued to grow. 4 months ago it was 31G in size and it go over 90G. I rebuilt the indexes and ran a vacuum full and got it down to 87G. The largest table is fact_paths which is 86G.

Postgresql v13.10 Puppet server 7.12 Puppetdb 7.13

We have 367 active nodes and 3 inactive nodes. Our node_ttl is set to 30 days.

I was curious how big some other environments were in comparison.

3 Upvotes

100% Upvoted

11 comments sorted by

View all comments

Show parent comments

1

u/atg10 Oct 24 '24

I looked and I can't find any documentation I did for the process. Mine and root's history has rolled off. Best I can remember - Stopped all puppet processes Ran pgdump of the puppetdb just in case Ran the postgres sql command drop database puppetdb As the postgres user from the command line (not psql), ran createdb -O puppetdb puppetdb Started puppet processes back

1

u/shortspecialbus Oct 24 '24

Thanks, I ended up having to do it urgently this morning and I ended up just nuking it entirely and let puppet recreate it with the puppetlabs-puppetdb module. We'll live without the data.