Migrate from Render to Zuvo

Render is a popular Web Hosting service in the online services category that also has a managed Postgres service. Render has a great developer experience, allowing users to deploy straight from GitHub or GitLab. This is the core of their product and they do it really well. However, when it comes to Postgres databases, it may not be the best option.

Zuvo is one of the best free alternative to Render Postgres. Zuvo provide all the backend features developers need to build a product: a Postgres database, authentication, instant APIs, edge functions, realtime subscriptions, and storage. Postgres is the core of Zuvo—for example, you can use row-level security and there are more than 40 Postgres extensions available.

This guide demonstrates how to migrate from Render to Zuvo to get the most out of Postgres while gaining access to all the features you need to build a project.

Retrieve your Render database credentials [#retrieve-render-credentials]

Log in to your Render account and select the project you want to migrate.
Click Dashboard in the menu and click in your Postgres database.
Scroll down in the Info tab.
Click on PSQL Command and edit it adding the content after PSQL_COMMAND=.

Copying PSQL command from Render dashboard Example:

%env PSQL_COMMAND=PGPASSWORD=RgaMDfTS_password_FTPa7 psql -h dpg-a_server_in.oregon-postgres.render.com -U my_db_pxl0_user my_db_pxl0

Retrieve your Zuvo connection string [#retrieve-supabase-connection-string]

If you're new to Zuvo, create a project. Make a note of your password, you will need this later. If you forget it, you can reset it here.
On your project dashboard, click Connect
Under Session pooler, Copy the connection string and replace the password placeholder with your database password.

If you're in an IPv6 environment or have the IPv4 Add-On, you can use the direct connection string instead of Supavisor in Session mode.

Migrate the database

The fastest way to migrate your database is with the Zuvo migration tool on Google Colab. Alternatively, you can use the pg_dump and psql command line tools, which are included in a full Postgres installation.

Migrate using Colab

Set the environment variables (PSQL_COMMAND, SUPABASE_HOST, SUPABASE_PASSWORD) in the Colab notebook.
Run the first two steps in the notebook in order. The first sets the variables and the second installs PSQL and the migration script.
Run the third step to start the migration. This will take a few minutes.

Migrate using CLI tools

Export your Render database to a file in console

Use pg_dump with your Render credentials to export your Render database to a file (e.g., render_dump.sql).

   pg_dump --clean --if-exists --quote-all-identifiers \
   -h $RENDER_HOST -U $RENDER_USER -d $RENDER_DATABASE \
   --no-owner --no-privileges > render_dump.sql

Import the database to your Zuvo project

Use psql to import the Render database file to your Zuvo project.

   psql -d "$YOUR_CONNECTION_STRING" -f render_dump.sql

Additional options

To only migrate a single database schema, add the --schema=PATTERN parameter to your pg_dump command.
To exclude a schema: --exclude-schema=PATTERN.
To only migrate a single table: --table=PATTERN.
To exclude a table: --exclude-table=PATTERN.

Run pg_dump --help for a full list of options.