On Thursday, March 7, 2013 12:23:13 AM UTC+1, Ken Barber wrote: > > > > So the index 'idx_catalog_resources_tags' was removed in 1.1.0 I > think, so that is no longer needed. > > This points back to making sure you schema matches exactly what a > known good 1.1.1 has, as things have been missed obviously. > > Try this tool out: > > http://www.apgdiff.com/diff_online.php > > I've got a pg_dump of a good 1.1.1 here: > > https://gist.github.com/kbarber/5104169 > > All you need to do is perform a pg_dump of your schema: > > pg_dump --schema-only puppetdb > > And use that online tool to compare your schema with the one I've > provided. I would obviously double check its accuracy before doing > anything drastic, but this should help to get your schema inline with > what it should be. If you are paranoid about any part of the diff, > paste the results in a gist and we can discuss it. >
The only difference seem to be that 1 index, nothing else. > > Okay, well - lets at least get your schema back inline with what it > should be, get your re-indexes done and we can come back round to this > problem if it still exists. > > ken. > We will rebuild the indexes during the weekend, and see how it performs afterwards. -- 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 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.