status-im
/
infra-role-postgres-ha
mirror of https://github.com/status-im/infra-role-postgres-ha.git
2
0
Fork 0
Code Issues Packages Projects Releases Wiki Activity
40 Commits 2 Branches 0 Tags 184 KiB
Commit Graph

40 Commits

Author SHA1 Message Date
Ivan Folgueira Bande d3e46b2ac9
tasks/config.yml: simplify the deployment of postgres.conf file 2024-06-24 18:33:42 +02:00
Ivan Folgueira Bande 186ffab82f
simplify template/postgresql.conf and only leave needed attributes 2024-06-24 18:32:24 +02:00
Ivan Folgueira Bande d298e0db57
add postgresql.conf from outside into the database container 
We are starting to control-version the changes of the
postgres config file. Notice that this initial file has been
extracted from the current store-db-01.do-ams3.shards.staging node.

I only added some parameters, commented, that will be useful for us
to debug the database. To find those new parameters just look
for the 'waku' word within the postgresql.conf file.
 2024-06-20 21:15:04 +02:00
Alexis Pentori 5650471d72
init: adding additional script 
Signed-off-by: Alexis Pentori <alexis@status.im>
 2024-06-12 12:09:22 +02:00
Anton Iakimov 8d8b9fbbae
databases: add locale and template parameters to DB creation 
https://github.com/status-im/infra-office/issues/24
 2024-05-30 17:30:46 +02:00
Anton Iakimov c1d16dce0b
docker: switch compose to v2 2024-05-30 16:29:14 +02:00
Jakub Sokołowski 9fbe3851b9
init: script to modify settings using alter system 
Necessary for waku fleets to limnit WAL growth size.
https://github.com/status-im/infra-role-postgres-ha/issues/3

Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2024-01-09 14:04:55 +01:00
Jakub Sokołowski de8022989d
reinit: run init scripts after setup 
This is done to avoid the implicit behavior of init scripts running only
at database creation time, causing confusion when forgotten.

Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2024-01-09 14:04:06 +01:00
Jakub Sokołowski c647a9f57d
backup: add option to disable the backup timer 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2023-12-06 11:48:36 +01:00
Jakub Sokołowski 90fe472bcb
backup: fix path of backup.sh script for timer 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2023-11-24 16:56:22 +01:00
Jakub Sokołowski cedacfca7a
consul: don't make health.sh use optional 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2023-11-23 13:41:50 +01:00
Jakub Sokołowski 6b296be196
consul: add handling DB without replica to health.sh 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2023-11-23 13:11:22 +01:00
Jakub Sokołowski 1ff92d5fc5
hba: make optional when there's no replica 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2023-11-23 12:56:09 +01:00
Jakub Sokołowski 1ee52deded
meta: add missing infra roles to dependencies 
Also use full names as God intended.

Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2023-11-23 12:50:00 +01:00
Jakub Sokołowski 97f525e905
consul: add health.sh to check replica status 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2023-11-22 13:15:45 +01:00
Jakub Sokołowski a96ac9034f
admin.sh: quote extra arguments to fix use of -e 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2023-11-22 12:32:22 +01:00
Jakub Sokołowski 8381b62304
backup.sh: move to scripts dir 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2023-11-22 12:32:21 +01:00
Jakub Sokołowski 716732b18b
hba: use docker_compose task to restart 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2023-11-22 12:09:05 +01:00
Jakub Sokołowski 35568e2e41
hba: wait for DB port to be available 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2023-11-21 16:35:05 +01:00
Jakub Sokołowski a38d2c707a
config: add admin.sh wrapper script 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2023-11-21 16:21:34 +01:00
Jakub Sokołowski bbdb294e3d
databases: use initdb folder to create DBs and users 
This way when the database is cleared the user is automatically created
without the need to run Ansible.

Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2023-11-21 16:14:28 +01:00
Jakub Sokołowski 8fcbe906fc
defaults: fix variable name for DB UID 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2023-11-21 15:57:33 +01:00
Alexis Pentori 085e30fd75
backup: adding condition before setting backup 
Signed-off-by: Alexis Pentori <alexis@status.im>
 2023-11-16 12:40:02 +01:00
Jakub Sokołowski 8c10ac4c08
backup: backup each database separately 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2022-12-08 13:01:52 +01:00
Jakub Sokołowski 9951f6a33d
config: create db backup directory 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2022-12-07 20:39:30 +01:00
Jakub Sokołowski 8a374cb4ea
start: specify compose file path 
Allows for renaming it.

Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2022-12-07 20:39:01 +01:00
Jakub Sokołowski dd12ecd90a
backup: fix location of backup directory 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2022-12-06 18:03:55 +01:00
Jakub Sokołowski d257729557
databases: create only on master host 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2022-12-05 14:01:52 +01:00
Jakub Sokołowski 86abe317e3
replica: fix format of pg_basebackup command 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2022-12-05 14:01:36 +01:00
Jakub Sokołowski 652ed466f8
databases: fix creation by going back to gexec 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2022-12-05 13:39:14 +01:00
Jakub Sokołowski 735634ed60
docker: fix path for backup files 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2022-12-05 13:07:57 +01:00
Jakub Sokołowski 9eeef53f79
database: use --comand to fix creation of DBs 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2022-12-05 12:52:58 +01:00
Jakub Sokołowski 0ea85fa043
backup: fix service name variable 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2022-12-05 12:52:41 +01:00
Jakub Sokołowski d619c91e04
backup: fix volume variable 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2022-11-24 21:42:45 +01:00
Jakub Sokołowski e3713bd9a5
add basic readme 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2022-11-24 20:55:26 +01:00
Jakub Sokołowski 6ed5ff3780
add db_dump backup timer 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2022-11-24 20:45:53 +01:00
Jakub Sokołowski bf8662b20f
add consul service definition 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2022-11-24 20:45:06 +01:00
Jakub Sokołowski 80e572044e
add first working version 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2022-11-24 16:43:35 +01:00
Jakub Sokołowski bab9faf31c
add ansible metadata 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2022-11-24 13:06:26 +01:00
Jakub Sokołowski 65f5da1c98
initial empty commit 
Signed-off-by: Jakub Sokołowski <jakub@status.im>
 2022-11-24 13:06:21 +01:00