Hi @gaurang1745, I apologize for the late response; I somehow missed the notification.
pg_dump is recommended, even if you may encounter memory issues when dealing with a large number of user tables.
Because of that reason, we created 2 CLI commands a while ago to override that problem:
- backup_baserow: it uses pg_dump under the hood, but it exports tables in order and batches the user tables to avoid consuming all the available shared memory
- restore_baserow: it starts from the output of the previous command and restores all the tables correctly
They are somewhat outdated and unmaintained, so I cannot guarantee they will work 100% work, but you can take inspiration from the code to see how the operations are performed.