Example of trying to get CircleCI with Postgres, PostGIS and psql working

circleci_config.yml

# Golang CircleCI 2.0 configuration file
#
# Check https://circleci.com/docs/2.0/language-go/ for more details
version: 2
jobs:
  build:
    docker:
      # specify the version
      - image: cimg/go:1.14
        environment:
          CI_DATABASE_URL: postgresql://postgres@localhost/your_test_db_name

      # Specify service dependencies here if necessary
      # CircleCI maintains a library of pre-built images
      # documented at https://circleci.com/docs/2.0/circleci-images/

      # Service container image available at `host: localhost`

      - image: circleci/postgres:10.7-postgis
        environment:
          POSTGRES_USER: postgres
          POSTGRES_DB: your_test_db_name

    #### TEMPLATE_NOTE: go expects specific checkout path representing url
    #### expecting it in the form of
    ####   /go/src/github.com/circleci/go-tool
    ####   /go/src/bitbucket.org/circleci/go-tool
    steps:
      - checkout
      - run: sudo apt-get update
      - run: sudo apt-get install postgresql-client
      - run:
          name: Setup DB
          working_directory: ./test/data
          environment:
            TERM: xterm
          command: psql -q -d $CI_DATABASE_URL -f your_seed_data.sql
      - run:
          name: Test some Go code
          working_directory: ./go/somemodule
          command: go test
          environment:
            CI_DATABASE_URL: postgresql://postgres@localhost/your_test_db_name