search

openoakland / OakCrime-Decommissioned

Code supporting citizen analysis of crime in Oakland, CA
22 stars 16 forks source link

Load production data into RDS #64

Closed adborden closed 5 years ago

adborden commented 5 years ago

We need to load the production RDS database with data.

adborden commented 5 years ago

@rbelew I'm not exactly sure what this entails. Do we just run a management task to load the data, or do we need to load a database dump from an existing database?

rbelew commented 5 years ago

@adborden we produce a pg_dump archive, move it to the RDS, run pg_restore on that server and (assuming harvesting is working for subsequent updates) we're done!

rbelew commented 5 years ago

i've produced a workable pg_dump file missing the (user, group) auth* tables using:

pg_dump -T*auth_* -Ft -f djdb10_190201-noAuth.tar djdb10

we've agreed NOT to include that in the (code) repo; contact me to get it.

adborden commented 5 years ago

Oops, this was done a while ago.