Database error when running migrations
I've set up a Postgres database (
create user askbot with password 'blah;
grant all on database askbot to askbot). For some reason, when I tried to do
syncdb, I got an error saying '
psycopg2.OperationalError: FATAL: Ident authentication failed for user "askbot"'. Anyway, I ended up adding a line to the pg_hba.conf file to fix password authentication for the askbot user.
The problem I'm having is that when I try and run
python manage.py migrate, I get this error:
File "/srv/askbot/askbot/management/commands/init_postgresql_full_text_search.py", line 19, in handle_noargs cursor.execute("CREATE LANGUAGE plpgsql") psycopg2.ProgrammingError: must be owner of database askbot
Any help with this would be much appreciated.