Discourse Local setup

hi,
I have installed discourse in my local using ubuntu software.
i cannot run my url its showing below error, plz can any one help me?

Error:
An error has occurred, all later migrations canceled: PG::SyntaxError: ERROR: syntax error at or near “NOT” LINE 2: ADD COLUMN IF NOT EXISTS image_upload_id bigint ^

I’m probably not the right person to help with this issue, but can you confirm that you installed Discourse on your local server by following this guide: Beginners Guide to Install Discourse on Ubuntu for Development?

I’m assuming that you are creating a local development site and not a production site.

2 Likes

Yes, i am following that guide only and creating my local development.
i am not able to fix that issue.

PG::SyntaxError: ERROR: syntax error at or near "NOT"
LINE 2: ADD COLUMN IF NOT EXISTS image_upload_id bigint

1 Like

What distro are you running? That setup will work on latest Ubuntu and latest LTS Ubuntu.

If you are running an older version you will need to add a PostgreSQL PPA in order to get a more recent version.

3 Likes

Could this be a postgres version issue? Looks like we need postgres >= 9.6 ?

What version is recommended?

PostgreSQL 13 is the recommended.

3 Likes

Upgrading to postgres:10 allows the installation to proceed

2 Likes