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
psql
is 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: