Hello,
Bumping my installation up to Postgres 9.3.5 and PuppetDB 2.2 I noticed in
the release notes about the pg_trgm extension (hence the Postgres update)
However on installing them and setting up the extension (seemingly
correctly):-
$ psql
psql (9.3.5)
Type "help" for help.
postgres=# \dx
List of installed extensions
Name | Version | Schema | Description
---------+---------+------------+-------------------------------------------------------------------
pg_trgm | 1.1 | public | text similarity measurement and index
searching based on trigrams
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(2 rows)
postgres-# \q
I still get this on startup of PuppetDB2.2:-
2014-08-30 08:05:56,029 WARN [c.p.p.s.migrate] Missing PostgreSQL
extension `pg_trgm`
We are unable to create the recommended pg_trgm indexes due to
the extension not being installed correctly. Run the command:
CREATE EXTENSION pg_trgm;
as the database super user on the PuppetDB database to correct
this, then restart PuppetDB.
Which is odd. My Postgres install is non-standard as I need to move the
paths around for my environment but that shouldn't matter.
Any ideas. These are on RHEL6.5.
Cheers
Paul
--
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 view this discussion on the web visit
https://groups.google.com/d/msgid/puppet-users/1a58e32d-7255-4cb8-a13e-e134414f30a0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.