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 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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/puppet-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
--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 [email protected].
To post to this group, send email to [email protected].
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/puppet-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
