First time here? Check out the FAQ!

Ask Your Question

2

Deploying to Heroku

heroku
retag add tags

I am trying to deploy askbot to Heroku and I am getting the following error when I run ./manage.py migrate:

Running migrations for askbot: - Migrating forwards to 0051proxifyqarevmodels.

askbot:0022initpostgresqlfulltext_search Traceback (most recent call last): django.db.utils.DatabaseError: must be owner of database qkdxugtyqz

When I contacted Heroku support they said this:

"Hi, it looks like you app is running

CREATE LANGUAGE plpgsql

which is restricted to superusers on the database - you will need to remove this from your migration."

Is there any way around this, or is deploying askbot to heroku not possible?

asked 2011-12-09 20:25:39 -0600

edit flag offensive 0 remove flag close merge delete

Comments

add a comment see more comments

2 Answers

Sort by

1

Hello, that means you cannot use postgresql on heroku with askbot, try MySQL, but make sure to use MyISAM tables.

You can also use sqlite3 for the database.

answered 2011-12-09 20:27:41 -0600

edit flag offensive 0 remove flag delete link

Comments

add a comment see more comments

1

It did work for me, but I had to comment the logging that goes into askbot.log

answered 2012-08-24 15:01:10 -0600

edit flag offensive 0 remove flag delete link

Comments

1

can you please create a separate post for - A step by step procedure for installing askbot(any issues if any) in Heroku? It will be very helpful for others. Thanks. :)

pajju (2012-08-26 01:45:18 -0600) edit

add a comment see more comments