Move / migrate nocodb to coolify

Self-Host
1

Hey NocoDB Community!

We’ve been running NocoDB on a server set up with auto-install, but now we’re switching to Coolify and want to get NocoDB running on it too. Anyone know the best way to move all our data over to the new server/installation?

Coolify has a NocoDB package, but we could also go the Docker Compose route if that’s easier.

Recreating everything manually would be a big task since we’ve got 30 tables with a lot of columns, and most of them are linked to each other. The scheme is in an own postgres database I created and connected during the initial setup.

Any help or advice would be awesome!

Cheers!

2

First up, we are not familiar with coolify.

Auto-upstall is just docker-compose behind the scenes. If you can take pg_dump from installed NocoDB postgres to coolify postgres with rest of the environment variables. It should work out of the box.

Below is answer from AI

Reasoned about migrating NocoDB to Coolify for 16 seconds

You can avoid having to rebuild your entire project manually by migrating your existing Postgres database. Since NocoDB stores its schema, tables, relationships, and other settings in the database you connected during setup, the easiest approach is to back up that database and then point your new NocoDB instance (whether running via Coolify’s package or a Docker Compose setup) to it.

Recommended Steps

  • Backup Your Current Database:
    Use a tool like pg_dump to export your Postgres database. This gives you a complete snapshot of your 30 tables, their columns, and the relationships between them.
  • Restore on the New Server:
    Set up a new Postgres instance (if needed) and restore your backup using psql or another restore tool. This ensures all your data and schema definitions are carried over intact.
  • Configure the New NocoDB Instance:
    In your new NocoDB installation, update the environment variables or configuration settings to point to the restored Postgres database. Make sure the NocoDB version is compatible with your previous one to avoid any potential issues.
  • Test Thoroughly:
    Before fully switching over, run the new setup in a staging environment to verify that all data, links, and relationships work as expected.