ansible-postgresql
ansible-postgresql copied to clipboard
galaxyproject
An Ansible role for managing a PostgreSQL server
Running `/var/lib/postgresql/backup/bin/backup.py --rsync-backup-opts '\-rptg' --keep 30 --backup --clean-archive /archive` will fail with ``` INFO:root:Initiating backup with pg_start_backup() INFO:root:Connecting to database INFO:root:Backup label is: 20240216T184527Z Traceback (most recent call last): File...
Our deployment is now failing on RHEL7 due to task `Install repository key` in `galaxyproject.postgresql`. The task tries to fetch from: `https://download.postgresql.org/pub/repos/yum/RPM-GPG-KEY-PGDG` which no longer exists. I think this is...
I have a fresh Rocky Linux 8 VM ([vggp-v60-j326-d1dfcf46c4cd-main](https://github.com/usegalaxy-eu/vgcn)) however installing postgresql15-server fails at the install step: https://github.com/galaxyproject/ansible-postgresql/blob/f23cb7a2fca78cad977c5db09e489a983bc6411f/tasks/redhat.yml#L50 with: ``` All matches were filtered out by modular filtering for argument:...
The fancy thing is very fancy, but lacks restore instructions and I'm not entirely sure what the restore process is, just replace the directory? I'd love to have something simpler...
From @vazovn > Setting the `__postgresql_version_dotless: ""` seems to do the fix. The good news is that one can do this in the ansible playbook yaml file and thus not...
Arguably a distribution problem (looking at you ubuntu) but, the backup script stopped working in Dec 2021.
That's a pretty comprehensive list of steps, could probs do that in gh actions. _Originally posted by @hexylena in https://github.com/galaxyproject/ansible-postgresql/pull/30#issuecomment-966444473_
Ok, even with the small fix I proposed in #38, it was still not working in check_mode (because a bunch of reasons). So this PR aims to make it work...
Metadata
Owner
Metadata
An Ansible role for managing a PostgreSQL server