This guide shows how to restore schemas and table data in a Shuttle database. Dumping data is a planned feature.

If you encounter issues, feel free to contact us for help.

​
Prerequisites

To run the data upload against the database, you need a Postgres Client. In this guide, we will use psql. On Debian/Ubuntu, you can install it with:

sudo apt install postgresql-client

Shuttle Postgres databases run Postgres version 16, so psql versions older than 16 might not work.

​
Restore data from a SQL file

Use the following command to get the connection string for the new database:

shuttle resource list --show-secrets

Use psql to run the dump file against it:

psql -d <connection string> -f filename.sql

You might see various errors about tables, rows, or constraints already existing in the new database. In most cases this is fine, but you can verify that everything looks good by connecting to the database, and testing the app.

psql <connection string>