Jakub Sokołowski
0e166b76b4
docker: fix postgres_ha_share_memory variable name
...
Signed-off-by: Jakub Sokołowski <jakub@status.im>
2024-10-30 11:36:36 +01:00
e48e129d8b
metrics: add postgres-exporter and pg-agent
...
* postgres-exporter for basic database metrics
- pg-agent: optional, to identify query performence issues
Signed-off-by: Alexis Pentori <alexis@status.im>
2024-10-11 12:29:27 +02:00
Jakub Sokołowski
fbc3376e79
init: avoid errors when creating existing resources
...
Signed-off-by: Jakub Sokołowski <jakub@status.im>
2024-08-29 16:06:06 +02:00
Jakub Sokołowski
f7720f0d5a
init: grant permissions on public schema
...
Otherwise table creation fails with:
```
ERROR: permission denied for schema public
```
Signed-off-by: Jakub Sokołowski <jakub@status.im>
2024-08-29 16:01:51 +02:00
aa752f4062
docker: configuring share memory
...
Signed-off-by: Alexis Pentori <alexis@status.im>
2024-08-20 13:57:09 +02:00
Jakub Sokołowski
bf869e93a4
docker: add ability to configure custom network
...
Signed-off-by: Jakub Sokołowski <jakub@status.im>
2024-08-19 11:03:00 +02:00
Jakub Sokołowski
aa6b4fe577
init: add support for creating extra users
...
Signed-off-by: Jakub Sokołowski <jakub@status.im>
2024-08-08 09:15:09 +02:00
Jakub Sokołowski
9142511e51
backup: add port flag to handle changed ports
...
Signed-off-by: Jakub Sokołowski <jakub@status.im>
2024-07-17 22:56:24 +02:00
a65e614e5b
backup.sh: fix backup permissions
2024-07-16 11:54:19 +02:00
Jakub Sokołowski
4ac216d316
init: fix variable used in alter_system.sql
...
Signed-off-by: Jakub Sokołowski <jakub@status.im>
2024-07-09 17:39:06 +02:00
9c0e9e8a27
backup.sh: fix backup permissions
2024-07-01 15:41:49 +02:00
5650471d72
init: adding additional script
...
Signed-off-by: Alexis Pentori <alexis@status.im>
2024-06-12 12:09:22 +02:00
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
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
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
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
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
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
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
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
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
Alexis Pentori
Anton Iakimov