I''ve been running a puppet server for about 18 months, a few months ago I read up on stored configurations and turned them on to share host entries to all my machines. But I''m seeing continuous DB collisions (machine 2 fails to run puppet agent because machine 1 already has the sqlite DB locked). I would like to start using PostgreSQL on the theory that this will allow me to avoid this behavior. 1. do I need to migrate the data from the sqlite3 DB, to the PostgreSQL DB? 2. is there any benefit in migrating the data? 3. how would I go about migrating the data if I decide there is benefit? Thanks in advance for any guidance. Ron -- 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+unsubscribe@googlegroups.com. To post to this group, send email to puppet-users@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Hi Ronald, I presume your talking about switching to PuppetDB from using the ActiveRecord sqlite3 setup? One methodology is to: * Do a quick change freeze, ie. don''t allow puppet to run properly on any host while you do the rest. * Simply make the switch to PostgreSQL & PuppetDB configuration in your puppetmaster. * Run puppet agent -t --noop a few times on all your hosts until your reports are clean. Multiple runs are needed probably to resolve ordering with any exported resource side-effects. * Come out of change freeze. Because the data is only as good as the last run, this is a reasonable methodology - as running puppet again repopulates the data. Does this sound reasonable to you Ronald? Its not the only way but it does avoid messy dump/loads from 2 completely different databases and schemas. ken. On Fri, Feb 8, 2013 at 4:21 PM, Ronald Wolf <ibawolf@gmail.com> wrote:> I''ve been running a puppet server for about 18 months, a few months ago I > read up on stored configurations and turned them on to share host entries to > all my machines. But I''m seeing continuous DB collisions (machine 2 fails > to run puppet agent because machine 1 already has the sqlite DB locked). I > would like to start using PostgreSQL on the theory that this will allow me > to avoid this behavior. > > 1. do I need to migrate the data from the sqlite3 DB, to the PostgreSQL DB? > > 2. is there any benefit in migrating the data? > > 3. how would I go about migrating the data if I decide there is benefit? > > Thanks in advance for any guidance. > > Ron > > -- > 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+unsubscribe@googlegroups.com. > To post to this group, send email to puppet-users@googlegroups.com. > Visit this group at http://groups.google.com/group/puppet-users?hl=en. > For more options, visit https://groups.google.com/groups/opt_out. > >-- 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+unsubscribe@googlegroups.com. To post to this group, send email to puppet-users@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Thanks, Ken. That was my thought too, but I wanted to get a 2nd opinion. On Friday, February 8, 2013 10:30:13 AM UTC-6, Ken Barber wrote:> > Hi Ronald, > > I presume your talking about switching to PuppetDB from using the > ActiveRecord sqlite3 setup? > > One methodology is to: > > * Do a quick change freeze, ie. don''t allow puppet to run properly on > any host while you do the rest. > * Simply make the switch to PostgreSQL & PuppetDB configuration in > your puppetmaster. > * Run puppet agent -t --noop a few times on all your hosts until your > reports are clean. Multiple runs are needed probably to resolve > ordering with any exported resource side-effects. > * Come out of change freeze. > > Because the data is only as good as the last run, this is a reasonable > methodology - as running puppet again repopulates the data. > > Does this sound reasonable to you Ronald? Its not the only way but it > does avoid messy dump/loads from 2 completely different databases and > schemas. > > ken. > > On Fri, Feb 8, 2013 at 4:21 PM, Ronald Wolf <iba...@gmail.com<javascript:>> > wrote: > > I''ve been running a puppet server for about 18 months, a few months ago > I > > read up on stored configurations and turned them on to share host > entries to > > all my machines. But I''m seeing continuous DB collisions (machine 2 > fails > > to run puppet agent because machine 1 already has the sqlite DB locked). > I > > would like to start using PostgreSQL on the theory that this will allow > me > > to avoid this behavior. > > > > 1. do I need to migrate the data from the sqlite3 DB, to the PostgreSQL > DB? > > > > 2. is there any benefit in migrating the data? > > > > 3. how would I go about migrating the data if I decide there is benefit? > > > > Thanks in advance for any guidance. > > > > Ron > > > > -- > > 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...@googlegroups.com <javascript:>. > > To post to this group, send email to puppet...@googlegroups.com<javascript:>. > > > Visit this group at http://groups.google.com/group/puppet-users?hl=en. > > For more options, visit https://groups.google.com/groups/opt_out. > > > > >-- 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+unsubscribe@googlegroups.com. To post to this group, send email to puppet-users@googlegroups.com. Visit this group at http://groups.google.com/group/puppet-users?hl=en. For more options, visit https://groups.google.com/groups/opt_out.