diff options
Diffstat (limited to 'docs/meeting_notes/2023-08-01.md')
| -rw-r--r-- | docs/meeting_notes/2023-08-01.md | 65 |
1 files changed, 0 insertions, 65 deletions
diff --git a/docs/meeting_notes/2023-08-01.md b/docs/meeting_notes/2023-08-01.md deleted file mode 100644 index 30311f1..0000000 --- a/docs/meeting_notes/2023-08-01.md +++ /dev/null @@ -1,65 +0,0 @@ ---- -layout: default -title: "2023-08-01: Devops Meeting" -parent: Meeting notes -nav_order: ---- - -# DevOps Meeting Notes - -## Agenda - -### Infrastructure migration - -The vote is tied. Chris and Johannes decided that we should test out migrating -the PostgreSQL database at the very least. We then have more freedom about our -data. What we need to do: - -- Allow PostgreSQL connections from LKE's static IPs in the firewall -- Whitelist the static IPs from Linode via `pg_hba.conf` -- Schedule downtime for the PostgreSQL database -- **At downtime** - - Take writers offline - - Dump database from Linode into Netcup - - Update all the client's database URLs to point to netcup - - Restart writers - -We want to rely on the restore to create everything properly, but will need to -test run this beforehand. The following `pg_virtualenv` command has showcased -that it works properly: - -```sh -kubectl exec -it postgres-... -- pg_dumpall -U pythondiscord \ -| pg_virtualenv psql -v ON_ERROR_STOP=1 -``` - -Note however that the database extension `pg_repack` needs to be installed. - -Before we can get started, we need to allow the PostgreSQL role to configure -`pg_hba.conf` and `postgresql.conf` entries. - - -### Meeting notes - -We're using GitHub at the moment. Some are left in Notion. We should migrate -these to GitHub to have a uniform interface: Johannes will pick up -[python-discord/infra#108](https://github.com/python-discord/infra/issues/108) -to merge them together into Git, as its more open than Notion. - - -### Ansible lint failures in the infra repository - -Excluding the vault was found as the working solution here, as implemented by -Chris. - -### Kubernetes repository pull requests - -These were cleaned up thanks to Chris. - - -## Roadmap review & planning - -- Chris will prepare the PostgreSQL configuration mentioned above. - - -<!-- vim: set textwidth=80 sw=2 ts=2: --> |