Skip to content

Instantly share code, notes, and snippets.

@brody192
Last active January 13, 2024 03:34
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save brody192/7689605241b25100135753029fc9484a to your computer and use it in GitHub Desktop.
Save brody192/7689605241b25100135753029fc9484a to your computer and use it in GitHub Desktop.

Deploy the new NocoDB template

  1. Go to the dashboard

  2. Click New Project

  3. Click Deploy a template

  4. Search for NocoDB

  5. Click the only result

  6. Click Deploy

  7. Wait for the deployed services to finish deploying

Gather the old and new database URLs

  1. Create a note in your notepad of choice

  2. Copy the DATABASE_URL variable from the Postgres database in your old NocoDB project into the note. making sure denote that it is the old database's URL

  3. Copy the DATABASE_PRIVATE_URL variable from the Postgres database in your new NocoDB project into the note. making sure denote that it is the new database's URL

Temporality stop the NocoDB services

Perform the following steps on both the old and new NocoDB projects

  1. Open the NocoDB service

  2. Click the 3 dot menu on the deployment

  3. Click Remove

  4. Complete the confirmation dialog

Wipe the Postgres database volume in the new NocoDB project

  1. Open the new NocoDB project

  2. Click on the postgres services volume

  3. Click Settings

  4. Scroll to the bottom

  5. Click Wipe Volume

  6. Complete the confirmation dialog

  7. Wait for postgres to redeploy

Perform the migration

  1. Open the new NocoDB project

  2. Click + New in the top right corner

  3. Click Template

  4. Search for Postgres Plugin Migration

  5. Click on the first result

  6. For PLUGIN_URL use the previously copied down database URL from the old NocoDB project's database

  7. For NEW_URL use the previously copied down database URL from the new NocoDB project's database

  8. Click Save Config

  9. Click Deploy

  10. Monitor the logs of the postgres migration service

Remove the postgres migration service

  1. Open the service settings

  2. Scroll to the bottom

  3. Click Delete Service from All Environments

  4. Complete the confirmation dialog

Restart the new NocoDB service

  1. While still in the new NocoDB project

  2. Open the NocoDB service

  3. Click the 3 dot menu on the Removed deployment

  4. Click Redeploy

  5. Complete the confirmation dialog

Confirm the new NocoDB works as expected

  1. While still in the new NocoDB project

  2. Open its url and verify that everything is in place and working as expected

Delete the old NocoDB project

  1. Open the old NocoDB project

  2. Click Settings

  3. Click Danger

  4. Click Delete Project

  5. Complete the confirmation dialog

@candidexmedia
Copy link

Hey @brody192! I added some headings and numbering to the guide: https://gist.github.com/candidexmedia/283d2f392282ef331ecfe187c41e4aa6

Thanks again!

@brody192
Copy link
Author

@candidexmedia Thank you, I've updated my gist to fit that style!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment