postgresql
postgresql copied to clipboard
ANXS
Fairly full featured Ansible role for Postgresql.
## Description - [x] Missing `gnupg2` in some base image, such as: `ubuntu:22.04` - [x] Update default var postgresql_apt_repository, to fix error missing package postgresql-16 in ubuntu 22 - [x]...
https://github.com/ANXS/postgresql/issues/581 Ignore local file `psqlrc` by adding the option `-X` to all commands `psql`. Make the role's behavior independent of the local configuration.
# CurrentBehavior Service connection encountered database exception
If the file `.psqlrc` or `/etc/psqlrc` exists the behavior of tasks using `psql` may changes. Proposed patch attached: [ANXS.postgresql.patch](https://github.com/user-attachments/files/17044787/ANXS.postgresql.patch)
Hi, i would like to be able to select the postgres minor version during install. I see that the `postgresql_version` variable is used at many places so probably an additional...
Hello! I'm trying to install PostgreSQL on a fresh Ubuntu 22.04 with `postgresql_data_directory: /data/postgresql`, but I'm getting the following error: ``` TASK [anxs.postgresql : PostgreSQL | Verify postgresql cluster version]...
https://github.com/ANXS/postgresql/blob/b38e897e2b8e91f3dbb1216739678c844911b1bc/tasks/users_privileges.yml#L4-L12 > WARNING The priv option has been deprecated and will be removed in community.postgresql 4.0.0. Please use the [community.postgresql.postgresql_privs](https://docs.ansible.com/ansible/latest/collections/community/postgresql/postgresql_privs_module.html#ansible-collections-community-postgresql-postgresql-privs-module) module instead. Reference: https://docs.ansible.com/ansible/latest/collections/community/postgresql/postgresql_user_module.html#ansible-collections-community-postgresql-postgresql-user-module
