SpiceDB is an open source, Google Zanzibar-inspired, database system for creating and managing security-critical application permissions.

SpiceDB

Hi folks 👋 I'm evaluating SpiceDB for my company and had a question around backups. We'd be using AWS RDS Postgres as the datastore. Based on what I'm reading (e.g. https://authzed.com/docs/spicedb/ops/data/migrations), it seems like `pg_dump/restore` is not recommended and instead we should be using `zed backup` for backups.

For the same reasons, should RDS automated backups be avoided, or are they fine as those are physical snapshots of storage rather than logical backups produced by `pg_dump`?

RDS backups are fine because they're physical snapshots

the reason `pg_dump`/`pg_restore` don't work is because they don't preserve the state of the database as far as the transaction ID counter goes, and SpiceDB uses that transaction counter for its own MVCC on top of postgres

Got it, makes sense. Thanks <@247824634320257025>!