Rotation and Archival of Usage Data

debate-watch / issue-tracker

1 stars 1 forks source link

Rotation and Archival of Usage Data #6

Open s2t2 opened 8 years ago

s2t2 commented 8 years ago

To avoid unnecessary production database hosting costs, usage data (e.g. requests) should be archived (moved to storage on Amazon s3), and rotated (deleted from the production database).

s2t2 commented 8 years ago

attempting a pg_dump on production heroku machine...

Running `bundle exec rake backup:db:archive` attached to terminal... up, run.6784
Error: You must install at least one postgresql-client-<version> package.

hmm...

s2t2 commented 8 years ago

attempting a COPY on production heroku machine...

PG::InsufficientPrivilege: ERROR: must be superuser to COPY to or from a file

hmm...

s2t2 commented 8 years ago

a STDIN-based copy approach works around the COPY bug