Move your Postgres data

Write the Render database into a file with pg_dump, then load the file into the Ferry datastore.

pg_dump reads the Render database through its external URL.

1 / 3

Stop the writes while you copy, or plan a short maintenance period.

Terminal

docker run --rm postgres:16-alpine pg_dump --no-owner --no-acl "$RENDER_EXTERNAL_DATABASE_URL" > shop.sql

pg_dump runs from an image. Use an image that is as new as the Postgres version of the Render server, or newer.

Terminal

ferry db show shop-db    # prints the Database and User to load into

Terminal

docker exec -i ferry-ds-shop-db psql -U shop_db shop_db < shop.sql

psql runs in the container of the datastore. Replace shop_db with the User and the Database that ferry db show prints.

Set the values that Render did not sync

Ferry does not create a variable with sync false. Set its value with the CLI.

Point your domains to Ferry

Change the DNS records of your custom domains. They must point to the Ferry server.