ISTI-ansible-roles
/
ansible-role-postgresql
5
0
Fork 1
Code Issues Pull Requests Releases Wiki Activity
111 Commits 1 Branch 0 Tags 178 KiB
Commit Graph

111 Commits

Author SHA1 Message Date
Andrea Dell'Amico 6712574bd6
Fix the path of the letsencrypt certificates. 2024-11-28 17:51:44 +01:00
Andrea Dell'Amico d36c88673c
Fix the systemd custom file. 2024-08-09 17:03:25 +02:00
Andrea Dell'Amico 33a9cfaefc
Reload systemd after changing the systemd unit. 2024-08-09 16:36:02 +02:00
Andrea Dell'Amico 488253a708
Fix the data directory setup on EL systems. 2024-08-09 16:28:41 +02:00
Andrea Dell'Amico 3aeea4004a
EL config: a 'become_user' is missing. 2024-08-08 19:54:45 +02:00
Andrea Dell'Amico 2f1d9b5971
Create the data directory if it is meant to be in a different place. 2024-08-08 19:32:50 +02:00
Andrea Dell'Amico 715e2b4c49
Use dnf on EL 8+. 2024-08-08 19:03:24 +02:00
Andrea Dell'Amico f2103225f1
Fix the EL repository name. 2024-08-08 18:56:24 +02:00
Andrea Dell'Amico 0c35eea79e
Fix a typo. 2024-05-13 18:23:26 +02:00
Andrea Dell'Amico 4f2e0615e5
New task to manage additional custom parameters. 2024-05-13 18:08:20 +02:00
Andrea Dell'Amico aded1a0426
hashing method configurable. 2024-05-13 17:59:41 +02:00
Andrea Dell'Amico b8be7778e8
Update the apt cache when the repo changes. 2024-02-12 16:29:27 +01:00
Andrea Dell'Amico eaeeb5be5a
Ubuntu bionic not supported anymore. 2023-12-18 13:44:49 +01:00
Andrea Dell'Amico 7870fbcbfa
Another round of task names changes. 2023-12-18 13:15:11 +01:00
Andrea Dell'Amico aad4b75d60
Fix a task name. 2023-12-18 13:12:22 +01:00
Andrea Dell'Amico 6819643fd1
Fix a typo. 2023-12-18 13:11:17 +01:00
Andrea Dell'Amico efb66ae437
Tags for the client installation. 2023-12-18 13:07:42 +01:00
Andrea Dell'Amico 96d172ce67
Option to install the client only. 2023-12-18 13:00:20 +01:00
Andrea Dell'Amico 1fc4a4527d
Fix the pgdg repository of the deb packages. 2023-12-18 12:41:38 +01:00
Andrea Dell'Amico e54345a927
New variable to set the max connections. 2023-12-13 11:56:43 +01:00
Andrea Dell'Amico e8e9e32f82
Align the parameters convetions. 2023-11-21 12:04:25 +01:00
Andrea Dell'Amico fd68e8d04a
Flush handlers after configuring pg_hba. 2023-10-25 16:29:36 +02:00
Andrea Dell'Amico a6f71dda75
Fix some lint warnings. 2023-10-20 12:44:06 +02:00
Andrea Dell'Amico d69716bb8a
Replace the configfile.py module. Other fixes. 2023-10-16 18:39:03 +02:00
Andrea Dell'Amico 3941030b6b
Start replacing configfile with the proper modules 2023-10-15 15:30:17 +02:00
Andrea Dell'Amico b6d5cae17b
Some code cleanup. 2023-10-15 15:13:16 +02:00
Andrea Dell'Amico 758b309594
Add a .gitignore. 2023-10-15 15:12:34 +02:00
Andrea Dell'Amico 05277e8038
Fix a typo. The r mode was not removed. 2023-10-11 18:53:56 +02:00
Andrea Dell'Amico cf4d866f0c
The file must be writeable... 2023-10-11 18:26:08 +02:00
Andrea Dell'Amico df6cf284e4
Use mode=r for the temp file too. 2023-10-11 18:20:29 +02:00
Andrea Dell'Amico 36ce397a79
Try again to open as a string. 2023-10-11 18:10:58 +02:00
Andrea Dell'Amico 27f5e6f0a7
Open the file as binary. 2023-10-11 18:01:56 +02:00
Andrea Dell'Amico 643ca47814
Fix the meta. 2023-10-11 17:56:26 +02:00
Andrea Dell'Amico b78149be59
Do not open the file as binary. 2023-10-11 17:56:16 +02:00
Andrea Dell'Amico 7a24ebf9be
New defaults: postgresql 16, postgis 3. 2023-10-11 11:54:01 +02:00
Andrea Dell'Amico 9df46eb4fb
Fix a typo. 2023-10-11 11:40:26 +02:00
Andrea Dell'Amico 07a81fbba9
Fix a typo. 2023-10-11 11:35:16 +02:00
Andrea Dell'Amico 1094339af2
Install python3-psycopg2 when Ubuntu >= 20. 2023-10-11 11:28:03 +02:00
Andrea Dell'Amico c0158f0c5b Merge pull request 'Update 'templates/postgresql-backup.sh.j2'' (!5) from tpiccioli-patch-1 into master 
Reviewed-on: #5
 2023-03-24 19:13:42 +01:00
Tommaso Piccioli 8b13a1377c Update 'templates/postgresql-backup.sh.j2' 2023-03-24 19:07:57 +01:00
Tommaso Piccioli a4ceaaf5b2 revert c9aa64f79a 
revert Update 'templates/postgresql-backup.sh.j2'
 2023-03-24 19:05:12 +01:00
Tommaso Piccioli c9aa64f79a Update 'templates/postgresql-backup.sh.j2' 2023-03-24 19:01:45 +01:00
Andrea Dell'Amico c38d2fb895 Merge pull request 'Update 'templates/postgresql-backup.sh.j2'' (!4) from tpiccioli-patch-1 into master 
Reviewed-on: #4
 2023-03-23 16:22:54 +01:00
Tommaso Piccioli 56cdc39d7b Update 'templates/postgresql-backup.sh.j2' 
- Cleanup older dumps leaving N_DAYS_TO_SPARE dump, don't use find by date
- clean old dumps before new dump
 2023-03-23 16:15:08 +01:00
Andrea Dell'Amico c3f33257ad Merge pull request 'using mtime instead of atime with find' (!3) from tpiccioli-patch-1 into master 
Reviewed-on: #3
 2023-03-03 18:05:39 +01:00
Tommaso Piccioli 66227f98b8 using mtime instead of atime with find 2023-03-03 17:57:19 +01:00
Andrea Dell'Amico 7b2a0a1b1e
Fix the letsencrypt defaults. 2021-10-09 17:21:53 +02:00
Andrea Dell'Amico 974c435e20
New max_slot_wal_keep_size default. 2021-09-21 19:00:26 +02:00
Andrea Dell'Amico 2d4f05bc3a
Fix the permissions of /usr/local/sbin/postgresql_wal_backup_and_removal 2021-09-18 14:35:35 +02:00
Andrea Dell'Amico d1bd4ab919
Set wal_keep_size to the default. 2021-09-18 14:31:55 +02:00