ISTI-ansible-roles
/
ansible-role-postgresql
4
0
Fork 1
Code Issues Pull Requests Releases Wiki Activity
100 Commits 1 Branch 0 Tags 139 KiB
Commit Graph

100 Commits

Author SHA1 Message Date
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
Andrea Dell'Amico 596337db58
The proposed value of 'wal_keep_size' was wrong. 2021-09-18 14:24:10 +02:00
Andrea Dell'Amico 3e01e4fa34 Merge pull request 'if master check added' (!2) from tpiccioli/ansible-role-postgresql:master into master 
Reviewed-on: #2
 2021-09-17 23:28:47 +02:00
Tommaso Piccioli 84b1c899ef if master check added 2021-09-17 17:56:29 +02:00
Andrea Dell'Amico ac009a330a
Add options to the streaming replication conf. 2021-09-17 15:41:38 +02:00
Andrea Dell'Amico 44c99e81bd Merge pull request 'backup and clean of wal files' (!1) from tpiccioli/ansible-role-postgresql:master into master 
Reviewed-on: #1
 2021-09-17 11:33:59 +02:00
Tommaso Piccioli 7f799023d9 backup and clean of wal files 2021-09-16 23:54:17 +02:00
Andrea Dell'Amico 8af951180e
Always reload the service. 2021-07-05 11:47:51 +02:00
Andrea Dell'Amico c559b6b0f6
Define psql_wal_files_archiving_enabled 2021-06-01 23:59:18 +02:00
Andrea Dell'Amico d872e67c8c Another template that pertains to pgpool. 2021-04-07 19:17:02 +02:00
Andrea Dell'Amico 14968c9da3 Remove the sudoers file. It's pgpool stuff. 2021-04-07 19:10:30 +02:00
Andrea Dell'Amico d73add956c Flush the handlers when needed. 2021-04-06 16:55:11 +02:00