What is the best way to implement data archiving?

Question

PostgreSQL

Hello!
I want to ask for advice. There is a DB in which new schemes with identical structure of tables constantly appear. There comes a time when the user temporarily does not need his scheme and there is a desire to temporarily "archive" such schemes.
Now, there is an idea to implement this through pg_dump and, if necessary, pg_restore is launched, which rolls everything back.
What do you think about this option?

Answer 1

Well, yes it will work, but the method itself is very brutal. It would be more flexible to transfer the archive tables to a remote server and if you need access to the archive or restore from the archive, access it through something like pl / proxy