Solved! Working with postgres (postgresql 11) in travis

.travis.yml

language: elixir

dist: bionic
sudo: required

elixir:
  - '1.9.0'

otp_release:
  - '22.0'

addons:
  postgresql: '11'
  apt:
    packages:
      - postgresql-11
      - postgresql-client-11

env:
  - MIX_ENV=test

cache:
  directories:
    - _build
    - deps

before_install:
  - sudo sed -i -e 's/^#listen_addresses.*/listen_addresses = "*"/' /etc/postgresql/11/main/postgresql.conf
  - sudo sed -i -e 's/^port = 5433/port = 5432/' /etc/postgresql/11/main/postgresql.conf
  - sudo service postgresql restart 11

install:
  - mix local.hex --force
  - mix local.rebar --force

before_script:
  - cp config/travis.exs config/test.exs
  - mix do ecto.create, ecto.migrate

script:
  - mix test

readme.md

Problem

The issue with postgres 11 in travis is that by default uses port 5433 and does not listen in localhost address

Solution

• Update the postgresql.conf listen_addresses to listen_addresses = "*"
• Update the postgresql.conf port to 5432
• Restart postgresql service

Resources

• https://pgdash.io/blog/postgres-11-getting-started.html#postgresqlconf

travis.exs

use Mix.Config

# Configure your database
#
# !!!! The postgres user travis is created automatically !!!!
#
config :myapp, Myapp.Repo,
  username: "travis",
  password: "",
  database: "myapp_test",
  hostname: "localhost",
  pool: Ecto.Adapters.SQL.Sandbox

# We don't run a server during test. If one is required,
# you can enable the server option below.
config :sanborns, MyappWeb.Endpoint,
  http: [port: 4002],
  server: false

# Print only warnings and errors during test
config :logger, level: :warn