Load the snapshot to a "pristine" local database that you never modify. Whenever... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		mdavidn 8 months ago \| parent \| context \| favorite \| on: Pgactive: Postgres active-active replication exten... Load the snapshot to a "pristine" local database that you never modify. Whenever you need a "reset" of your dev database, drop it, then copy the pristine database using `createdb --template`. This copies prebuilt indexes rather than rebuild them, which is much faster.

nico 8 months ago [–]

But when loading that pristine local db from the original source, it would still create the indices and thus take a long time?

The goal is not necessarily having an easy way to reset, but rather an easy/quick way to load real data

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact