Ecto.Adapters.Postgres

Adapter module for PostgreSQL.

It handles and pools the connections to the postgres database using postgrex with poolboy.

Options

Postgrex 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

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