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 databasepg_restore it on the scratch DB serverstellar 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?