Re: [Puppet Users] Re: PuppetDB database tunning

2013-05-29 Thread shell heriyanto
Already update to 1.3.1, the old database still there. Theres script for remove it via postgres script or puppet stanza to clean this such as after 30days old? On Wed, May 29, 2013 at 12:19 PM, shell heriyanto wrote: > Hi Ken thanks for your reply, > We using Postgresql, we just have about 150

Re: [Puppet Users] Re: PuppetDB database tunning

2013-05-28 Thread shell heriyanto
Hi Ken thanks for your reply, We using Postgresql, we just have about 150 puppet agent, and for 130 agent its just run once per day, every day its take about 150MB. We using puppetDB 1.1.0. I will try to update puppetDB today. On Tue, May 28, 2013 at 10:23 PM, Ken Barber wrote: > What kind of d

Re: [Puppet Users] Re: PuppetDB database tunning

2013-05-28 Thread Ken Barber
What kind of database is this? Postgresql or the built-in HSQLDB? And - how are you calculating the database size? On Tue, May 28, 2013 at 12:19 PM, shell heriyanto wrote: > no efect, this my configuration: > > gc-interval = 60 > node-ttl = 30m > node-purge-ttl = 30m > report-ttl = 30m > > I make

Re: [Puppet Users] Re: PuppetDB database tunning

2013-05-28 Thread shell heriyanto
no efect, this my configuration: gc-interval = 60 node-ttl = 30m node-purge-ttl = 30m report-ttl = 30m I make ttl fast to see the change but still, my database still grow bigger. Its need to remove the database fast and create again, to make this work? how ttl work? is it just count when we do ad

Re: [Puppet Users] Re: PuppetDB database tunning

2013-05-22 Thread shell heriyanto
This what i'am find, thank you Klavs. On Wed, May 22, 2013 at 9:44 PM, Klavs Klavsen wrote: > http://docs.puppetlabs.com/puppetdb/1.3/maintain_and_tune.html > > Den onsdag den 22. maj 2013 09.56.36 UTC+2 skrev Heriyanto: > >> Hi, >> >> I've been use puppetdb about 6 months ago, and now the data

[Puppet Users] Re: PuppetDB database tunning

2013-05-22 Thread Klavs Klavsen
http://docs.puppetlabs.com/puppetdb/1.3/maintain_and_tune.html Den onsdag den 22. maj 2013 09.56.36 UTC+2 skrev Heriyanto: > > Hi, > > I've been use puppetdb about 6 months ago, and now the database more than > 6gigs > Is that any way to "recycle" database? the data on database more than > 30day