ankane/production_rails

Syncing Production and Staging Database

ACPK opened this issue · 1 comments

ACPK commented

Thank you for your production tips! Do you have any recommendations on syncing the production and staging databases? We use your pgsync gem for development.

ankane commented

Hey @ACPK, I don't have any specific recommendations. Two approaches I've see are:

  1. Nightly dump + restore (pg_dump/pg_restore for Postgres)
  2. Nightly snapshot + restore