Ask Your Question

Need to be DB superuser to migrate askbot?

asked 2010-10-30 21:11:21 -0500

graeme gravatar image

updated 2010-10-31 17:05:37 -0500

Evgeny gravatar image

I get the following error when doing migrate askbot

File "/home/graeme/iqapy/lib/python2.5/site-packages/askbot/management/commands/", line 19, in handle_noargs
cursor.execute("CREATE LANGUAGE plpgsql")
psycopg2.ProgrammingError: must be superuser to create procedural language
edit retag flag offensive close merge delete


What is the version of your postgres?
Evgeny gravatar image Evgeny  ( 2010-10-31 16:11:50 -0500 )edit

1 Answer

Sort by ยป oldest newest most voted

answered 2010-10-31 16:18:10 -0500

Evgeny gravatar image

updated 2010-10-31 16:39:53 -0500

It depends on the version of postrges and how the admins had configured it.

In postgres <= 8.2 you do need to be a superuser to run that command and you may have additional problems running the trigger setup that is applied later in the same migration. I've written the full text trigger code using version 8.3 manual.

On versions >= 8.3 database can be configured so that database owner can run it, the default setting allows it.

If do not have access to postgres 8.3 and higher, then it might be easier for you to use MySQL.

I'll make the migration fail on this condition more softly, by disabling the full text search in such cases. The problem is that triggers for the full text indexing are written in plpgsql procedural language that needs to be created in your database.

edit flag offensive delete link more


Thanks, it is the postgres version. I will try with MySQL.
graeme gravatar image graeme  ( 2010-10-31 16:57:36 -0500 )edit
Will it be possible to enable the full text search if I move to a newer version of postgres later on?
graeme gravatar image graeme  ( 2010-11-11 06:39:02 -0500 )edit
Yes, you will be able to migrate to Postgres, I'll try to migrate this site by Monday. MySQL deployment actually has full text search, but it cannot do relevance ranking.
Evgeny gravatar image Evgeny  ( 2010-11-11 10:33:41 -0500 )edit

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Question Tools


Asked: 2010-10-30 21:11:21 -0500

Seen: 419 times

Last updated: Oct 31 '10