search

DalgoT4D / maintenance

maintenance scripts for our ec2 machines
0 stars 0 forks source link

delete old airbyte prod databases #20

Closed fatchat closed 5 months ago

fatchat commented 5 months ago

we gave airbyte its own rds in 2024-01 and its old databases still exist on ddp-production

the databases

they need to be deleted by the ddpairbyte user which is the owner, after which the role ddpairbyte should also be deleted

the airbyte2 database has open connections from ddpmon which is used by prometheus. these need to be killed somehow

fatchat commented 5 months ago

https://stackoverflow.com/questions/143756/postgresql-rename-database

fatchat commented 5 months ago

Ref: https://jayanthkumar777.hashnode.dev/comprehensive-guide-to-monitoring-infrastructure-databases-django-app-metrics-with-grafana-and-prometheus

created the ddp_mon user on the airbyte rds

on the grafana machine, pointed /etc/postgres_exporter/postgres_exporter.env at the airbyte RDs

fatchat commented 5 months ago

renamed airbyte2 to airbyte2_tobedeleted on the ddp-production rds