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.
Compile time options
Those options should be set in the config file and require recompilation in order to make an effect.
:adapter
- The adapter name, in this case,Ecto.Adapters.Postgres
:timeout
- The default timeout to use on queries, defaults to5000
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'sssl
docs:connect_timeout
- The timeout for establishing new connections, defaults to5000
:extensions
- Specify extensions to the postgres adapter
Pool options
:size
- The number of connections to keep in the pool:lazy
- If false all connections will be started immediately on Repo startup (default: true):max_overflow
- The maximum overflow of connections (see poolboy docs)
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