aboutsummaryrefslogtreecommitdiffstats
path: root/ansible/roles/postgres (follow)
Commit message (Collapse)AuthorAgeLines
* Add a weekly cron job to repack all databasesGravatar Chris Lovering2025-02-15-0/+12
|
* Install pg_repack to all databasesGravatar Chris Lovering2025-02-15-0/+24
|
* Add HBA rule for grafana -> pinnwandGravatar Joe Banks2024-08-27-2/+6
|
* Use postgres role for user setupGravatar Johannes Christ2024-08-22-56/+221
|
* Add postgres user for thalliumGravatar Chris Lovering2024-08-18-52/+68
|
* Add polonium db and user/passwordGravatar Chris Lovering2024-07-26-49/+70
|
* Add PostgreSQL user for KeycloakGravatar Joe Banks2024-06-27-45/+61
|
* use host issued certs for postgres server instead of snakeoil'sGravatar shtlrs2024-06-06-4/+4
|
* Add automatic HBA rules for all users to connect via mTLSGravatar Joe Banks2024-06-04-3/+9
|
* Add devops user accountGravatar Joe Banks2024-06-04-42/+69
|
* Add CA file to postgresql.confGravatar Joe Banks2024-06-04-0/+2
|
* Add pg_ident.conf fileGravatar Joe Banks2024-06-04-1/+18
|
* Install PostgreSQL documentation packageGravatar Johannes Christ2024-06-04-0/+1
|
* add pixels user and dbGravatar shtlrs2024-06-02-39/+60
|
* add metabase user and databaseGravatar shtlrs2024-06-02-0/+8
|
* add hba conf for metabase to connect to siteGravatar shtlrs2024-06-01-0/+11
|
* grant correct privileges to site and grafanaGravatar shtlrs2024-06-01-37/+75
|
* Make issuing pg grants configurable (#327)Gravatar Amrou Bellalouna2024-06-01-0/+53
| | | | | * add a task to issue pg grants for specific roles * document the postgres role
* Add new users for Grafana and MetabaseGravatar Joe Banks2024-05-28-34/+73
| | | | | | Adds the new roles necessary for grafana and metabase, grants them access to the metricity table as well as giving them the pg_read_all_data role for read-only access to the metricity database.
* Add new metricity PostgreSQL userGravatar Joe Banks2024-05-28-24/+40
|
* Enforce SSL for remote PostgreSQL connectionsGravatar Johannes Christ2024-05-19-5/+5
|
* craete codejam pg userGravatar shtlrs2024-05-18-21/+36
|
* add a blacknight pg userGravatar shtlrs2024-05-18-17/+32
|
* update bitwarden user's password to exclude ugly charsGravatar shtlrs2024-05-17-17/+17
|
* add bitwarden postgres user & db configGravatar shtlrs2024-05-17-14/+29
|
* configure hba rules separatelyGravatar shtlrs2024-05-16-3/+17
|
* Add a postgresql.conf file templateGravatar Chris Lovering2024-05-16-0/+63
|
* grant pg users their predefined rolesGravatar shtlrs2024-05-16-0/+14
|
* define the blackbox user and its db rolesGravatar shtlrs2024-05-16-11/+20
|
* Pleasure the style dictator (#291)Gravatar jchristgit2024-05-14-16/+25
| | | Fix warnings with argsplat in postgres role
* add the task that configures host based authenticationGravatar shtlrs2024-05-14-0/+16
|
* add the db_passwords secrets fileGravatar shtlrs2024-05-14-7/+24
| | | | | | This contains the encrypted passwords for all database users This also moves variables under the /vars/main folder to allow ansible to load all variable folders automatically
* add a handler to reload postgresGravatar shtlrs2024-05-14-1/+10
| | | | | | This also renames the handler that restarts it. You're welcome Johannes.
* Update vars to have the role name as a prefixGravatar Chris Lovering2024-04-15-12/+12
|
* Move all ansible files to their own folderGravatar Chris Lovering2023-08-13-0/+45