Getting issue with Database Migrations

(Afx Afzaal) #1

Hi , I am getting an error when i run command

bundle exec rake db:create db:migrate

ERROR:  syntax error at or near "NOT"
LINE 1: CREATE SCHEMA IF NOT EXISTS discourse_functions;

PostGRESQL Version : 9.2.24
OS : Centos 7

(Jay Pfaffman) #2

You need to upgrade Postgres. You can search here, but I think that 9.6 is required.

(Afx Afzaal) #3

Thanks Man ! It Worked ! Although working with PostgreSQL upgrades etc is a pain. Thanks ! @pfaffman