Connect to the database yourself

Open psql in the container of the datastore, or connect from your machine through an SSH tunnel.

From your machine, the path goes through an SSH tunnel

From the server

Open psql in the container of the datastore.

Terminal

docker exec -it ferry-ds-notes-db psql -U notes_db notes_db

The name of the container is <prefix>-ds-<name>. With the default prefix, it is ferry-ds-notes-db.

Use the external URL that ferry db show notes-db prints. Its port is open only on 127.0.0.1 of the server. Thus make an SSH tunnel first.

Terminal

ssh -L 62975:127.0.0.1:62975 you@your-server
psql 'postgresql://notes_db:…@127.0.0.1:62975/notes_db'

Run migrations at each deploy

Ferry has no pre-deploy command. There are two ways to run a migration at each deploy.

Back up and restore

Ferry does not back up datastores. You dump the database to a file on a schedule.