Ecto.Adapters.Postgres

Adapter module for PostgreSQL.

It uses postgrex for communicating to the database and manages a connection pool with poolboy.

Features

• Full query support (including joins, preloads and associations)
• Support for transactions
• Support for data migrations
• Support for ecto.create and ecto.drop operations
• Support for transactional tests via Ecto.Adapters.SQL

Options

Postgres options split in different categories described below. All options should be given via the repository configuration.

Connection options

• :hostname - Server hostname
• :port - Server port (default: 5432)
• :username - Username
• :password - User password
• :parameters - Keyword list of connection parameters
• :ssl - Set to true if ssl should be used (default: false)
• :ssl_opts - A list of ssl options, see Erlang's ssl docs

Pool options

• :size - The number of connections to keep in the pool
• :max_overflow - The maximum overflow of connections (see poolboy docs)
• :lazy - If false all connections will be started immediately on Repo startup (default: true)

Storage options

• :encoding - the database encoding (default: "UTF8")
• :template - the template to create the database from
• :lc_collate - the collation order
• :lc_ctype - the character classification