Hi , we are migrating spicedb 1.16 to spicedb 1.28 with spicedb operator and we have migrated PG14 to PG16. after the pgdump/pgrestore the tables are not being recognized by SpiceDB. Its throwing "object definition not found" even though we have the schema in table. we came to know that we need to use SpiceDB repair, but couldn't able to find documentation for how to configure with SpiceDB operator. please help us with configuring it. thanks in advance.

pgdump/pgrestore operations are not supported for the SpiceDB Postgres Datastore due to design of Postgres MVCC internals which SpiceDB datastore lies upon. The team introduced the

spicedb datastore repair

command to fix clusters that end up in that state. The operator does not support

spicedb datastore repair

so you'd have to run a one off manually. Please run

spicedb datastore repair --help

to see the various options. Most likely all you need to set is

SPICEDB_DATASTORE_CONN_URI

and

SPICEDB_DATASTORE_ENGINE=postgres

Thank you for your detailed reply