1397531 - [ops infra socorro] working database in stage

Status: RESOLVED FIXED

(Socorro :: Infra, task)

Description

[Miles Crabill [:miles]]

I have dumped the webeng stage postgres RDS database using the following command:
pg_dump -h socorro-db.mocotoolsstaging.net -U breakpad_rw breakpad

and am now restoring it to the new stage postgres RDS database in ops stage. The database users are different (the root user of the new db is 'socorro' and not 'breakpad_rw'), so I did the following before restoring from the backup:

grant breakpad_rw to socorro
create database breakpad with owner socorro

So far, so good. It's chugging along, but the backup is >800gb large, so it'll take a while.

Comment 1

[Miles Crabill [:miles]]

As far as I can tell, the migrated database looks OK in ops stage.
There are probably pending migrations to run, but lacking (and automation around those migrations) we are in an OK state for now.