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


#1

I am moving to circcleci 2 but am getting the following error:

** Invoke db:load_config
** Execute db:check_protected_environments
** Execute db:structure:load
psql:/home/ubuntu/embers-rails2/db/structure.sql:10: ERROR: unrecognized configuration parameter "idle_in_transaction_session_timeout"
rake aborted!
failed to execute:
psql -v ON_ERROR_STOP=1 -q -f /home/ubuntu/embers-rails2/db/structure.sql circle_ruby_test

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

This would seem to be consistent with this Unable to `bundle exec rake db:structure:load` with 2.0 and I have tried to adjust but this is still erroring out. Any idea what I am doing wrong? thx

version: 2
jobs:
build:
working_directory: ~/repo
docker:
- image: circleci/ruby:2.4.1-node
environment:
RAILS_ENV: test
RACK_ENV:
- image: circleci/postgres:9.6.3
environment:
POSTGRES_USER: jt
POSTGRES_DB: embers_test
POSTGRES_PASSWORD: ""
steps:
- checkout

   - restore_cache:
       keys:
         - gem-cache-{{ .Branch }}-{{ checksum "Gemfile.lock" }}
         - gem-cache-{{ .Branch }}
         - gem-cache
   
   - run: bundle install --path vendor/bundle
   - run: sudo apt install postgresql-client
   
   - save_cache:
       key: gem-cache-{{ .Branch }}-{{ checksum "Gemfile.lock" }}
       paths:
         - vendor/bundle
   
   - restore_cache:
       keys:

#2