Thanks Wyatt. I see what you mean, this may take too long. What if I got
desperate and decided to just drop the entire PuppetDB. Is there an easy
way to do this? I really don't care about historical data as we use this
basically for monitoring of the environment.
On Tuesday, April 26, 2016 at 10:45:40 AM UTC-5, Wyatt Alt wrote:
>
> Hey Mike, give this a shot (in a psql session):
>
> begin;
> delete from facts where fact_path_id in (select id from fact_paths where
> name=any('{"disks", "partitions", "mountpoints"}'));
> delete from fact_paths where id not in (select fact_path_id from facts);
> delete from fact_values where id not in (select fact_value_id from facts);
> commit;
>
>
> If you hit a transaction rollback you may need to run it with PDB
> stopped. Those last two deletes may take some time since your
> gc-interval is long, so you should probably run it in tmux/screen or
> something.
>
> Wyatt
>
--
You received this message because you are subscribed to the Google Groups
"Puppet Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to puppet-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/puppet-users/fa7d0b01-49c2-4a6a-bb4c-8090f6024373%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
