Importing and exporting data

[michelkaeser]

Recently we tried to restore a database dump and figured out this is not working properly due to Permify using Postgres' internal transaction counter (pg_current_xact_id()) for certain columns (e.g. transaction ID).

Trying to write new relations after loading this dump into a new Postgres instance leads to duplicate key errors, as the internal transaction ID might be lower than the last written one/contained in the dump.

Is there a suggested approach to exporting data so it can be imported on a fresh instance?
Using regular database dumps are not an option due to the issue mentioned above.

A new service allowing to import and export would be great.
Ideally, its data is independent of the persistence technology.

How do others solve this?