Getting issue with Database Migrations

Installation
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

2

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

4 Likes
3

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

1 Like