Commit Graph

116 Commits

Author SHA1 Message Date
Daniel Berteaud 45d8142d22 Bigger timeout for checks 2023-11-11 00:57:21 +01:00
Daniel Berteaud 6350e82f32 Backup needs RW access to data, for logs 2023-11-03 16:20:13 +01:00
Daniel Berteaud 24eda58174 Typo 2023-11-03 15:56:19 +01:00
Daniel Berteaud 1b4346ebcc Ensure /alloc/data/postgres dir exists 2023-11-03 15:54:18 +01:00
Daniel Berteaud ae8f9d76e2 Revert "Don't add a unix_socket in /alloc/data"
This reverts commit b5d6431438.
2023-11-03 15:51:05 +01:00
Daniel Berteaud b5d6431438 Don't add a unix_socket in /alloc/data 2023-11-03 15:37:00 +01:00
Daniel Berteaud 964634ad50 Don't run exporter or backup in recovery 2023-11-03 15:29:49 +01:00
Daniel Berteaud 6e82e4ef2c Fix log dir 2023-11-03 15:19:23 +01:00
Daniel Berteaud 4f3dfeddeb Adjust some logging directive 2023-11-03 15:03:44 +01:00
Daniel Berteaud b5825722ed Quote DB name and role 2023-11-03 09:10:58 +01:00
Daniel Berteaud 1da9a23808 Set shm_size to half of the total mem 2023-10-31 17:20:35 +01:00
Daniel Berteaud 7c2550dad1 More ram for exporter 2023-10-31 17:03:54 +01:00
Daniel Berteaud f743a09225 GRANT SUPERUSER to vault so it can manage SUPERUSER too 2023-10-31 16:11:54 +01:00
Daniel Berteaud 350be5c718 Allocate a bit more RAM to exporter 2023-10-31 16:06:02 +01:00
Daniel Berteaud fa419eb1a4 Try to grant needed privileges to monitor user 2023-10-31 16:05:33 +01:00
Daniel Berteaud b482657fbe Monitor user is static, as it's harder to bootstrap if using vault to
fetch creds
2023-10-31 15:38:04 +01:00
Daniel Berteaud 0a4ef9654c Handle cases where no other database config is present 2023-10-31 15:23:25 +01:00
Daniel Berteaud 9ccd3c45df Use simpler passwords 2023-10-31 15:21:34 +01:00
Daniel Berteaud 4c0df1b902 Do not quote ldap password for postgres
As it's already quoted
2023-10-31 15:14:15 +01:00
Daniel Berteaud ace4782ebf Add missing vault policy for monitor 2023-10-31 15:14:06 +01:00
Daniel Berteaud 0981ff0a1b Fix monitoring with loging 2023-10-31 15:04:31 +01:00
Daniel Berteaud 177835167a Quote ldap_pwd, don't create DB in dry mode 2023-10-31 14:48:14 +01:00
Daniel Berteaud 7e7eb131b4 Cleanup, use supercronic instead of nomad cron, and quote passwords in
env
2023-10-31 14:39:26 +01:00
Daniel Berteaud 269b3213c4 Rename dba to pgdba and set vault as a SUPERUSER 2023-10-31 12:01:02 +01:00
Daniel Berteaud 753f587709 Adapt for new wait_for 2023-10-30 23:51:42 +01:00
Daniel Berteaud cf1f536658 Support ldap auth + small fixes 2023-10-30 21:50:28 +01:00
Daniel Berteaud 3212e80baf Use public_url to set HostSNI 2023-10-30 16:24:54 +01:00
Daniel Berteaud 5f133648b0 Mount the backup volume in the server task for pgbackrest 2023-10-30 16:10:25 +01:00
Daniel Berteaud 6e126bbc93 Fix postgres-replica service-resolver 2023-10-30 13:20:12 +01:00
Daniel Berteaud 2139d4d44d Add conf fragment to expose patroni prometheus metrics 2023-10-30 11:53:58 +01:00
Daniel Berteaud d690f16a66 Cleanup Dockerfile 2023-10-30 11:04:48 +01:00
Daniel Berteaud ada3454699 Fix vault-database init script 2023-10-29 18:59:14 +01:00
Daniel Berteaud a6be8f7380 Use alma based image 2023-10-29 18:47:54 +01:00
Daniel Berteaud 2ede9bc460 Set high deadline so it doesn't fail on recovery 2023-10-29 10:27:07 +01:00
Daniel Berteaud 14929b2d99 Fix vault policies for exporter 2023-10-27 16:04:02 +02:00
Daniel Berteaud da3d31baa5 Use instance for volume names 2023-10-27 14:18:23 +02:00
Daniel Berteaud ec7733107b Add file extension in dump logs 2023-10-27 10:55:56 +02:00
Daniel Berteaud f7498bcfc0 Rework volumes 2023-10-26 23:58:35 +02:00
Daniel Berteaud 685c966835 Add a prep.d script to generate random passwords 2023-10-26 11:40:01 +02:00
Daniel Berteaud a2d5befac1 Update patroni to 3.2.0
And replace bootstrap.users with a bootstrap.post_bootstrap script
2023-10-26 11:26:21 +02:00
Daniel Berteaud cac0c3f085 Run ldap2pg in a manage batch job 2023-10-25 23:25:15 +02:00
Daniel Berteaud cae39a3c05 Fix wait-for 2023-10-22 23:27:50 +02:00
Daniel Berteaud 26d591e16a Fix DB locale 2023-10-22 21:45:49 +02:00
Daniel Berteaud fa17bc9c7a Add kill_timeout 2023-10-22 21:45:42 +02:00
Daniel Berteaud c78cc74add Add support for pg_dump backups 2023-10-18 12:03:42 +02:00
Daniel Berteaud 037cd4f98d Change some parameters defaults 2023-10-18 10:38:34 +02:00
Daniel Berteaud 9dc3da2ec2 Don't restart when job is resubmited 2023-10-18 09:24:33 +02:00
Daniel Berteaud 5dc02f36f9 Cleanup 2023-10-08 17:14:30 +02:00
Daniel Berteaud ee8fdf2efe Add comment on variable and ldap2pg defaults in variable instead of templates 2023-10-04 23:31:01 +02:00
Daniel Berteaud 546e85190e Fix permissions for rewind and wait_for 2023-09-28 15:05:56 +02:00