The catalogue
PostgreSQL
The major version you choose, local only, app and remote roles you name, common extensions, dump import.
- Module
- db.postgres
- Category
- Databases
What it installs
- PostgreSQL at the major version you pick, from the project’s own repository, listening on 127.0.0.1 only.
- An application role that owns the imported databases, a remote role for your laptop, and the pg_trgm, uuid-ossp and citext extensions.
- Shared buffers sized for the machine, unless you give a size of your own.
- An import of the dumps you drop in ~/dumps.
What it asks you for
- The major version.
- The port. 5432 by default.
- The names of the application role and the remote role.
- The application password and the remote password, generated if you like.
- The shared buffers size.
Good to know
Uninstalling takes back the packages and the configuration. The cluster’s data directory stays where PostgreSQL wrote it.