Does ElephantSQL take backups of the database?

Automated backups are performed every day on all plans (pg_dump). These are stored in a cloud file storage so they are always accessible to you (same cloud as your instance). The backup is saved for 30 days. The last month backup files can be found and downloaded in the ElephanSQL Control Panel.

The backups are compressed with lzop, to restore the data you can usually use the following: lzop -cd "$FILE_NAME" | psql "$DATABASE_NAME"

Full server backups (base backup) are performed once a week, rolling WAL backups are performed every second minute.

More information can be found here: https://www.elephantsql.com/docs/backups.html