Hi!
Trying to install the Discourse forum (https://github.com/discourse/discourse)
manually without Docker. I got PostgreSQL 9.4, Redis and my bundle all set up,
however the migration seems to fail:
== 20120921162512 AddMetaDataToForumThreads: migrating ========================
-- execute("CREATE EXTENSION IF NOT EXISTS hstore")
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:
PG::UndefinedFile: ERROR: could not open extension control file
"/usr/local/share/postgresql/extension/hstore.control": No such file or
directory
: CREATE EXTENSION IF NOT EXISTS
hstore/home/od/discourse/db/migrate/20120921162512_add_meta_data_to_forum_threads.rb:3:in
`change'
ActiveRecord::StatementInvalid: PG::UndefinedFile: ERROR: could not open
extension control file "/usr/local/share/postgresql/extension/hstore.control":
No such file or directory
: CREATE EXTENSION IF NOT EXISTS hstore
/home/od/discourse/db/migrate/20120921162512_add_meta_data_to_forum_threads.rb:3:in
`change'
PG::UndefinedFile: ERROR: could not open extension control file
"/usr/local/share/postgresql/extension/hstore.control": No such file or
directory
/home/od/discourse/db/migrate/20120921162512_add_meta_data_to_forum_threads.rb:3:in
`change'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
I then did a `touch /usr/local/share/postgresql/extension/hstore.control` and
now on `rake db:migrate` I get:
ps: %p|$|%a: keyword not found
ps: no valid keywords
== 20120921162512 AddMetaDataToForumThreads: migrating ========================
-- execute("CREATE EXTENSION IF NOT EXISTS hstore")
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:
PG::InvalidParameterValue: ERROR: version to install must be specified
: CREATE EXTENSION IF NOT EXISTS
hstore/home/od/discourse/db/migrate/20120921162512_add_meta_data_to_forum_threads.rb:3:in
`change'
ActiveRecord::StatementInvalid: PG::InvalidParameterValue: ERROR: version to
install must be specified
: CREATE EXTENSION IF NOT EXISTS hstore
/home/od/discourse/db/migrate/20120921162512_add_meta_data_to_forum_threads.rb:3:in
`change'
PG::InvalidParameterValue: ERROR: version to install must be specified
/home/od/discourse/db/migrate/20120921162512_add_meta_data_to_forum_threads.rb:3:in
`change'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)
Only Docker installs are supported meaning the Discourse team won't help me
with this one. Docker or not though, it's still odd that the migration should
fail like this.
O.D.
