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_testPlease check the output above for any errors and make sure that
psqlis installed in your PATH and has proper permissions.
This would seem to be consistent with this https://discuss.circleci.com/t/unable-to-bundle-exec-rake-db-structure-load-with-2-0/13692 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: