search

Netflix-Skunkworks / Scumblr

Web framework that allows performing periodic syncs of data sources and performing analysis on the identified results
Apache License 2.0
2.64k stars 317 forks source link

Postgres issues - new install #147

Closed smoebot closed 7 years ago

smoebot commented 7 years ago

Hello,

New install, Ubuntu 14.04.5.

Everything seems fine during install until creating the database. Then I get a lot of psql errors about 'last_comment' being deprecated, and about various types and relations not existing.

smoebot commented 7 years ago

scumblr 1 scumblr 2 scumblr 3

sbehrens commented 7 years ago

Can you provide some information on the version of PostGres you are using? It's throwing errors related to JSONB which may indicate you are using an older version of PostGres.

ahoernecke commented 7 years ago

@smoebot, just wanted to follow up on this. Looking at your the log from your "rake db:structure:load" command, it definitely looks like the version of Postgres you're using is too old. You'll need to have version 9.4+ (9.5 is better because it includes some performance enhancements specifically around jsonb).

Please check the version of postgres you're using and reopen if that isn't the issue. Also feel free to jump into our gitter channel to discuss: https://gitter.im/Netflix/Scumblr

Thanks!

smoebot commented 7 years ago

Confirmed - it was an older version of postgres that had been installed. started again with a blank install and installed as per instructions no problem

ahoernecke commented 7 years ago

Great, thanks for the update!