Hi,
Currently, I have a NocoDB instance hosted on Pikapods and I would like to migrate it to my Cloudron server.
Pikapods use PostgreSQL for NocoDB, which is the same DB as Cloudron. Based on their documentation, it is possible to have access to the database using this guide.
Does anyone already moved its NocoDB instance to Cloudron, and could share his process, or any guide/tutorial he followed? That would be greatly appreciated!
Also, I have a few automations already set up in Zapier using NocoDB webhooks, if I keep the same domain and same DB, will my automation still work after migrating?
I am not an expert and don't know much about PostgreSQL but the way I think I can do it (I may be totally wrong though) is that I can dump the SQL data from Pikapod in a single file (E.g. nocodb.sql), then rename it the same as Cloudron SQL (Let's say that after creating my instance of NocoDB in Cloudron, the SQL file that has been created is named "cloudron-nocodb.sql", then I can simply rename nocodb.sql to cloudron-nocodb.sql and replace it with the one on the server via ssh or file manager??), and then just update the PostgreSQL user and password in the ENV setting inside Cloudron.
Does my plan make sense? Thanks