capabilities.work

Postgres Backup and Restore

A 3-step recipe with Prisma. We can help you get access.

Recipe · 3 steps

Postgres Backup and Restore

with Prisma · Disaster Recovery & Resilience
Works with AI assistants

Create a manual backup, wait for completion, and restore the database from it.

  1. Trigger a manual backup of the database. The backup runs asynchronously and is accepted with a 202 status.
  2. List the backups for the database and confirm the most recent backup has reached the completed status before attempting a restore.
  3. Restore the database to the state captured in the completed backup. The restore runs asynchronously and is accepted with a 202 status.
What you'll need to have ready
  • apiToken: Service token or OAuth access token for the Management API, sent as a Bearer token.
  • databaseId: Identifier of the database to back up and restore.
  • backupLabel: Optional label for the manual backup.
For your developer

Arazzo workflow prisma:backup-and-restore-database, 3 operations: createDatabaseBackup → listDatabaseBackups → restoreDatabaseBackup. Specs on APIs.io.

More recipes with Prisma

Accelerate Cached Query then InvalidateClient List and Count RecordsClient Upsert a RecordOptimize Record and Analyze a SessionData Platform Bootstrap a Project EnvironmentData Platform Rotate an Environment API KeyPostgres Add a Database to a ProjectPostgres Find and Delete a ProjectPostgres Provision a ProjectPostgres Rotate a Database Connection String