Skip to content

Instantly share code, notes, and snippets.

@kabakaev

kabakaev/clean_puppet_db.sql

Last active August 29, 2015 14:22
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save kabakaev/2858740fce3a8fed6484 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save kabakaev/2858740fce3a8fed6484 to your computer and use it in GitHub Desktop.
Download ZIP
Clean exported resources from PuppetDB
Raw
clean_puppet_db.sql
# su - postgres
# psql
delete from public.resource_params_cache where parameters like '%live-some-nodename-db-02.project.conf%';
delete from public.resource_params where value like '%live-some-nodename-db-02.project.conf%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment