angristan / feedbin-docker

Self-host your own Feedbin RSS reader in Docker
MIT License
251 stars 35 forks source link

Bumping Postgres version #40

Closed flosoft closed 3 years ago

flosoft commented 3 years ago

When trying to set up a fresh install of Feedbin, it fails when trying to run the DB migrations with the following error.

florian@Pam:/volume1/docker/feedbin/feedbin-docker$ sudo docker-compose run --rm feedbin-web rake db:setup
I, [2021-01-07T21:20:43.955465 #1]  INFO -- honeybadger: ** [Honeybadger] Initializing Honeybadger Error Tracker for Ruby. Ship it! version=4.7.2 framework=rails level=1 pid=1
Created database 'feedbin_production'
 set_config 
------------

(1 row)

psql:/app/db/structure.sql:42: ERROR:  unrecognized configuration parameter "default_table_access_method"
E, [2021-01-07T21:20:52.358370 #1] ERROR -- honeybadger: ** [Honeybadger] Unable to send error report: API key is missing. id=03215d16-2272-4208-953f-ed22e67c2c2d level=3 pid=1
rake aborted!
failed to execute:
psql -v ON_ERROR_STOP=1 -q -X -f /app/db/structure.sql feedbin_production

Please check the output above for any errors and make sure that `psql` is installed in your PATH and has proper permissions.

/usr/local/bundle/gems/activerecord-6.0.3.4/lib/active_record/tasks/postgresql_database_tasks.rb:113:in `run_cmd'
/usr/local/bundle/gems/activerecord-6.0.3.4/lib/active_record/tasks/postgresql_database_tasks.rb:88:in `structure_load'
/usr/local/bundle/gems/activerecord-6.0.3.4/lib/active_record/tasks/database_tasks.rb:316:in `structure_load'
/usr/local/bundle/gems/activerecord-6.0.3.4/lib/active_record/tasks/database_tasks.rb:330:in `load_schema'
/usr/local/bundle/gems/activerecord-6.0.3.4/lib/active_record/tasks/database_tasks.rb:425:in `block in load_schema_current'
/usr/local/bundle/gems/activerecord-6.0.3.4/lib/active_record/tasks/database_tasks.rb:479:in `block (2 levels) in each_current_configuration'
/usr/local/bundle/gems/activerecord-6.0.3.4/lib/active_record/tasks/database_tasks.rb:476:in `each'
/usr/local/bundle/gems/activerecord-6.0.3.4/lib/active_record/tasks/database_tasks.rb:476:in `block in each_current_configuration'
/usr/local/bundle/gems/activerecord-6.0.3.4/lib/active_record/tasks/database_tasks.rb:475:in `each'
/usr/local/bundle/gems/activerecord-6.0.3.4/lib/active_record/tasks/database_tasks.rb:475:in `each_current_configuration'
/usr/local/bundle/gems/activerecord-6.0.3.4/lib/active_record/tasks/database_tasks.rb:424:in `load_schema_current'
/usr/local/bundle/gems/activerecord-6.0.3.4/lib/active_record/railties/databases.rake:443:in `block (3 levels) in <main>'
/usr/local/bundle/gems/activerecord-6.0.3.4/lib/active_record/railties/databases.rake:447:in `block (3 levels) in <main>'
/usr/local/bundle/gems/rake-13.0.1/exe/rake:27:in `<top (required)>'
Tasks: TOP => db:structure:load
(See full trace by running task with --trace)
florian@Pam:/volume1/docker/feedbin/feedbin-docker$

Bumping the postgres image to version 13 fixes this.