We have a scheduled job to create a snapshot of our prod Postgres database on a scratch server, to allow devs to work with the prod data and quickly restore to a clean state:
pg_dump the prod database
pg_restore it on the scratch DB server
stellar snapshot the restored DB on the scratch server
Devs have their own DBs on the scratch server and can restore that snapshot to them
Steps 2 and 3 seem redundant: there's the restored copy and Stellar's copy, both of which take a long time to create (this database is pretty large). It doesn't seem like a stretch for Stellar to support creating a snapshot directly from a dump file. Do you think this is feasible?
We have a scheduled job to create a snapshot of our prod Postgres database on a scratch server, to allow devs to work with the prod data and quickly restore to a clean state:
pg_dumpthe prod databasepg_restoreit on the scratch DB serverstellar snapshotthe restored DB on the scratch serverSteps 2 and 3 seem redundant: there's the restored copy and Stellar's copy, both of which take a long time to create (this database is pretty large). It doesn't seem like a stretch for Stellar to support creating a snapshot directly from a dump file. Do you think this is feasible?