PostgreSQL for Development

Ansible role for a very basic installation of PostgreSQL better suited for development environments, especially Vagrant boxes. It installs the database and the command-line client, and enables remote access so you can also connect a client from outside the Vagrant virtual machine (such as DBeaver from your host machine - just remember to configure port forwarding on your vagrantfile).

The software is installed from PostgreSQL's PPA, documented here.

PostgreSQL is installed as a systemd service named postgres.

Role Variables

postgres_version: Version of PostgreSQL to be installed.
Default: 12

postgres_ubuntu_version: Version name of the Ubuntu where PostgreSQL is going to be installed.
Default: focal

Example Playbook

Default installation

roles:
  - honatas.postgresql_dev

Installs PostgreSQL 11 on Ubuntu 18.04

roles:
  - { role: honatas.postgresql_dev, postgresql_version: 11, postgresql_ubuntu_version: bionic }

Dependencies

None

Requirements

None

License

MIT

Contributions

Feel free to open an issue or add a pull request. Anytime. Really, I mean it.

Also, if you like my work, I'll let you know that I love coffee.