Trigger, download, delete and restore DBHost database backups from the dashboard, and see which environments get a daily logical backup.
How backups work
DBHost uses pg_dump piped through gzip to create compressed SQL backups and
stores them off-host in AWS S3 eu-north-1 as timestamped .sql.gz files.Whether a database gets a daily scheduled backup depends on its environment:
production always does, staging does by default, development and other
databases use the choice made at creation, and previews have none unless you
choose daily. Logical backups are kept for 30 days. See
Backups and retention for the full policy.Scheduled jobs run throughout the UTC day with no single guaranteed backup
time. The dashboard shows a backup as complete only after the file has been
verified.
Triggering a backup
Go to your database detail page and open the Backups tab
Click Back up now. The same button is on the All backups page
The backup is queued as an operation. The dashboard polls its status and updates
the list without requiring a page refresh. On-demand backups work on every
plan, including when the scheduled backup choice is none.
Viewing backup history
The backups page shows all available backups with:
Actions — download, delete and restore, depending on your role
Developers can view and download backups. Owners and admins can trigger,
delete and restore backups. Restoring a database with managed or additional
roles, and cloning a backup, is limited to the database owner.
Restoring from a backup
Choose Restore on a verified backup to replace the database’s current
contents with that backup. DBHost restores into an isolated copy, verifies it,
takes a fresh backup of the current database and then switches over. Open
connections are dropped during the cutover.Databases with managed SQL roles and databases that opted in to additional
roles restore from the same Restore action, available to the database
owner on DBHost-produced verified backups. The dashboard reserves the restore
and advances it until it finishes; keep the page open. Role usernames and
passwords stay the same. If the restore stops, press Restore again to
continue the same operation. The
managed restore API does the same
from your own tooling. See
Restore from a DBHost backup for every path.
Cloning a backup
On a database with managed SQL roles, the owner can choose Clone to new
database on a verified backup. DBHost creates a separate database from that
backup with its own credentials and leaves the original untouched. The clone
counts toward your plan’s database limit.
Restore your own file
DBHost does not restore uploaded .sql, .sql.gz, .dump, or .backup
files. The upload endpoints return 409 CUSTOM_RESTORE_UPLOAD_DISABLED.Import your own dump with psql or pg_restore using the owner role over
verify-full TLS:
Use Download to fetch the exact .sql.gz file. The file may be served
directly from S3 through a short-lived link.
Use Delete to remove a backup file from the available backup list. Older
S3 versions may remain until storage retention expires.
Deleting a backup cannot be undone from the dashboard or API.
Deleted databases
When a database is deleted, its verified deletion backup stays downloadable
from Recently deleted for seven days. After that, the database and the
deletion backup are deleted permanently and automatically.
{"docsConfig":{"theme":"palm","$schema":"https://mintlify.com/docs.json","name":"DBHost","description":"Managed PostgreSQL hosting for developers: PgBouncer pooling, verify-full TLS, separate SQL roles, backups with 30-day retention, and API and CLI automation on paid plans.","colors":{"primary":"#6366f1","light":"#818cf8","dark":"#4f46e5"},"logo":{"light":"https://mintcdn.com/stianlarsen-ef7289da/SvPvaAf6yywKnLbd/images/logo-light.svg?fit=max\u0026auto=format\u0026n=SvPvaAf6yywKnLbd\u0026q=85\u0026s=04b5e34c4fa58314f697056f22b10346","dark":"https://mintcdn.com/stianlarsen-ef7289da/SvPvaAf6yywKnLbd/images/logo-dark.svg?fit=max\u0026auto=format\u0026n=SvPvaAf6yywKnLbd\u0026q=85\u0026s=05b305d5fbc0371088ab5477fc5bcc6e"},"favicon":"https://mintcdn.com/stianlarsen-ef7289da/SvPvaAf6yywKnLbd/images/favicon.svg?fit=max\u0026auto=format\u0026n=SvPvaAf6yywKnLbd\u0026q=85\u0026s=a3559c65dd709716d3a5acfaeffe09cc","appearance":{"default":"system"},"background":{"color":{"light":"#ffffff","dark":"#09090b"}},"seo":{"metatags":{"og:image":"https://dbhost.app/media/og/dbhost-managed-core-1200x630.png","og:image:width":"1200","og:image:height":"630","og:image:type":"image/png","og:image:alt":"DBHost — Postgres. Handled. Managed PostgreSQL hosting.","twitter:card":"summary_large_image","twitter:image":"https://dbhost.app/media/og/dbhost-managed-core-1200x630.png","twitter:image:width":"1200","twitter:image:height":"630","twitter:image:alt":"DBHost — Postgres. Handled. Managed PostgreSQL hosting."}},"styling":{"latex":false},"navigation":{"pages":[]}},"deployment":{"deploymentMetadataValue":{"subdomain":"stianlarsen-ef7289da","hasAudioNarration":false,"actualSubdomain":"stianlarsen-ef7289da","customDomains":["docs.dbhost.app"],"gitSource":{"type":"github","owner":"stianlars1","repo":"dbhost","deployBranch":"main","contentDirectory":"docs","isPrivate":true,"mountPath":"","label":""},"entitlements":{},"buildId":"6af31afd1661757f0de2775c","clientVersion":"0.0.4167","searchFilterCounts":[{"language":"default","tag":"API Reference","count":35},{"language":"default","tag":"Documentation","count":29},{"language":"default","tag":"Databases","count":21},{"language":"default","tag":"Operate your database","count":9},{"language":"default","tag":"Backups","count":7},{"language":"default","tag":"Dashboard","count":7},{"language":"default","tag":"Connect your app","count":6},{"language":"default","tag":"Getting Started","count":5},{"language":"default","tag":"Overview","count":2},{"language":"default","tag":"Collaboration","count":2}]},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":false,"enableContextualStarterQuestions":false,"enableAskAiSearchBar":true},"basePath":"","hasChatPermissions":false,"hasWebMcpPermissions":false,"toggles":[{"name":"kill-isr","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-rbac-roles","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-mintlify-slack","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"agent-integrations-settings","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"rbac-expansion","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-pr-grouping","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"custom-prefix","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"analytics-v7","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"user-flows-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"no-publish-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-onboarding","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving-live","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"stripTemperatureMiddleware","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"support-platform-pylon-zendesk","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"snapshot-serving","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"instant-rollback","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications-server","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"granular-notifications","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automations-fable","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fixed-ai-action-pricing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"automation-resolve-merge-conflict","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"scoped-publishing","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"mintql","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"page-level-analytics","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-version-history-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"billing-page-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"full-page-search","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workspace-projects","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"assistant-v5","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"fork-pr-previews","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"revalidation-jwt","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-sso-scim","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"hobby-abuse-scan","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"dashboard-inbox","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-signup","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-dual-write","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"workos-enabled","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"approve-review-flow","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"editor-metadata","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"sso-setup-deadline-banner","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"turbopuffer-serve","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"live-agents","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false},{"name":"llms-txt-v2","enabled":true,"variant":{"name":"disabled","enabled":false,"feature_enabled":true},"impressionData":false}],"googleFontsInlined":false},"customCss":[],"page":{"pagePath":"dashboard/backups","slug":"/dashboard/backups","pageMetadata":{"title":"Database backups in the DBHost dashboard","sidebarTitle":"Backups","description":"Trigger, download, delete and restore DBHost database backups from the dashboard, and see which environments get a daily logical backup.","href":"/dashboard/backups"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Trigger, download, delete and restore DBHost database backups from the dashboard, and see which environments get a daily logical backup.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={a:`a`,code:`code`,li:`li`,ol:`ol`,p:`p`,pre:`pre`,span:`span`,strong:`strong`,ul:`ul`,..._provideComponents(),...props.components},{CodeBlock,Heading,Warning}=_components;if(!CodeBlock)_missingMdxReference(`CodeBlock`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!Warning)_missingMdxReference(`Warning`,true);return _jsxs(_Fragment,{children:[_jsx(Heading,{level:`2`,id:`how-backups-work`,children:`How backups work`}),`\n`,_jsxs(_components.p,{children:[`DBHost uses `,_jsx(_components.code,{children:`pg_dump`}),` piped through `,_jsx(_components.code,{children:`gzip`}),` to create compressed SQL backups and\nstores them off-host in AWS S3 `,_jsx(_components.code,{children:`eu-north-1`}),` as timestamped `,_jsx(_components.code,{children:`.sql.gz`}),` files.`]}),`\n`,_jsxs(_components.p,{children:[`Whether a database gets a daily scheduled backup depends on its environment:\nproduction always does, staging does by default, development and other\ndatabases use the choice made at creation, and previews have none unless you\nchoose daily. Logical backups are kept for 30 days. See\n`,_jsx(_components.a,{href:`/backups-and-retention`,children:`Backups and retention`}),` for the full policy.`]}),`\n`,_jsx(_components.p,{children:`Scheduled jobs run throughout the UTC day with no single guaranteed backup\ntime. The dashboard shows a backup as complete only after the file has been\nverified.`}),`\n`,_jsx(Heading,{level:`2`,id:`triggering-a-backup`,children:`Triggering a backup`}),`\n`,_jsxs(_components.ol,{children:[`\n`,_jsxs(_components.li,{children:[`Go to your database detail page and open the `,_jsx(_components.strong,{children:`Backups`}),` tab`]}),`\n`,_jsxs(_components.li,{children:[`Click `,_jsx(_components.strong,{children:`Back up now`}),`. The same button is on the `,_jsx(_components.strong,{children:`All backups`}),` page`]}),`\n`]}),`\n`,_jsxs(_components.p,{children:[`The backup is queued as an operation. The dashboard polls its status and updates\nthe list without requiring a page refresh. On-demand backups work on every\nplan, including when the scheduled backup choice is `,_jsx(_components.code,{children:`none`}),`.`]}),`\n`,_jsx(Heading,{level:`2`,id:`viewing-backup-history`,children:`Viewing backup history`}),`\n`,_jsx(_components.p,{children:`The backups page shows all available backups with:`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Filename`}),` (timestamp-based: `,_jsx(_components.code,{children:`YYYYMMDD_HHMMSS.sql.gz`}),`)`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Size`}),` (compressed)`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Created at`}),` (UTC)`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Actions`}),` — download, delete and restore, depending on your role`]}),`\n`]}),`\n`,_jsx(_components.p,{children:`Developers can view and download backups. Owners and admins can trigger,\ndelete and restore backups. Restoring a database with managed or additional\nroles, and cloning a backup, is limited to the database owner.`}),`\n`,_jsx(Heading,{level:`2`,id:`restoring-from-a-backup`,children:`Restoring from a backup`}),`\n`,_jsxs(_components.p,{children:[`Choose `,_jsx(_components.strong,{children:`Restore`}),` on a verified backup to replace the database’s current\ncontents with that backup. DBHost restores into an isolated copy, verifies it,\ntakes a fresh backup of the current database and then switches over. Open\nconnections are dropped during the cutover.`]}),`\n`,_jsxs(_components.p,{children:[`Databases with managed SQL roles and databases that opted in to additional\nroles restore from the same `,_jsx(_components.strong,{children:`Restore`}),` action, available to the database\nowner on DBHost-produced verified backups. The dashboard reserves the restore\nand advances it until it finishes; keep the page open. Role usernames and\npasswords stay the same. If the restore stops, press `,_jsx(_components.strong,{children:`Restore`}),` again to\ncontinue the same operation. The\n`,_jsx(_components.a,{href:`/api-reference/databases/managed-restores`,children:`managed restore API`}),` does the same\nfrom your own tooling. See\n`,_jsx(_components.a,{href:`/guides/restore-from-backup`,children:`Restore from a DBHost backup`}),` for every path.`]}),`\n`,_jsx(Heading,{level:`2`,id:`cloning-a-backup`,children:`Cloning a backup`}),`\n`,_jsxs(_components.p,{children:[`On a database with managed SQL roles, the owner can choose `,_jsx(_components.strong,{children:`Clone to new\ndatabase`}),` on a verified backup. DBHost creates a separate database from that\nbackup with its own credentials and leaves the original untouched. The clone\ncounts toward your plan’s database limit.`]}),`\n`,_jsx(Heading,{level:`2`,id:`restore-your-own-file`,children:`Restore your own file`}),`\n`,_jsxs(_components.p,{children:[`DBHost does not restore uploaded `,_jsx(_components.code,{children:`.sql`}),`, `,_jsx(_components.code,{children:`.sql.gz`}),`, `,_jsx(_components.code,{children:`.dump`}),`, or `,_jsx(_components.code,{children:`.backup`}),`\nfiles. The upload endpoints return `,_jsx(_components.code,{children:`409 CUSTOM_RESTORE_UPLOAD_DISABLED`}),`.`]}),`\n`,_jsxs(_components.p,{children:[`Import your own dump with `,_jsx(_components.code,{children:`psql`}),` or `,_jsx(_components.code,{children:`pg_restore`}),` using the `,_jsx(_components.strong,{children:`owner`}),` role over\nverify-full TLS:`]}),`\n`,_jsx(CodeBlock,{filename:``,numberOfLines:`5`,language:`shellscript`,children:_jsx(_components.pre,{className:`shiki shiki-themes github-light-default dark-plus`,style:{backgroundColor:`#ffffff`,\"--shiki-dark-bg\":`#0B0C0E`,color:`#1f2328`,\"--shiki-dark\":`#D4D4D4`},language:`shellscript`,children:_jsxs(_components.code,{language:`shellscript`,numberOfLines:`5`,children:[_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#9CDCFE`},children:`PGSSLMODE`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`verify-full`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#9CDCFE`},children:` PGSSLROOTCERT`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`system`}),_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:` psql`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` -h`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` YOUR_HOST`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` -p`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` YOUR_PORT`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D7BA7D`},children:` \\\\`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` -U`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` YOUR_OWNER_ROLE`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` -d`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` YOUR_DATABASE`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` -v`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` ON_ERROR_STOP=`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#B5CEA8`},children:`1`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` -f`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` backup.sql`})]}),`\n`,_jsx(_components.span,{className:`line`}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#9CDCFE`},children:`PGSSLMODE`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`verify-full`}),_jsx(_components.span,{style:{color:`#1F2328`,\"--shiki-dark\":`#9CDCFE`},children:` PGSSLROOTCERT`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D4D4D4`},children:`=`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:`system`}),_jsx(_components.span,{style:{color:`#953800`,\"--shiki-dark\":`#DCDCAA`},children:` pg_restore`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` --no-owner`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` --exit-on-error`}),_jsx(_components.span,{style:{color:`#CF222E`,\"--shiki-dark\":`#D7BA7D`},children:` \\\\`})]}),`\n`,_jsxs(_components.span,{className:`line`,children:[_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` -h`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` YOUR_HOST`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` -p`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` YOUR_PORT`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` -U`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` YOUR_OWNER_ROLE`}),_jsx(_components.span,{style:{color:`#0550AE`,\"--shiki-dark\":`#569CD6`},children:` -d`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` YOUR_DATABASE`}),_jsx(_components.span,{style:{color:`#0A3069`,\"--shiki-dark\":`#CE9178`},children:` backup.dump`})]}),`\n`]})})}),`\n`,_jsxs(_components.p,{children:[_jsx(_components.a,{href:`/guides/restore-your-own-dump`,children:`Restore your own dump`}),` covers `,_jsx(_components.code,{children:`.sql.gz`}),` files,\ngrants and ownership repair.`]}),`\n`,_jsx(Heading,{level:`2`,id:`downloading-and-deleting-backups`,children:`Downloading and deleting backups`}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[`Use `,_jsx(_components.strong,{children:`Download`}),` to fetch the exact `,_jsx(_components.code,{children:`.sql.gz`}),` file. The file may be served\ndirectly from S3 through a short-lived link.`]}),`\n`,_jsxs(_components.li,{children:[`Use `,_jsx(_components.strong,{children:`Delete`}),` to remove a backup file from the available backup list. Older\nS3 versions may remain until storage retention expires.`]}),`\n`]}),`\n`,_jsx(Warning,{children:`Deleting a backup cannot be undone from the dashboard or API.`}),`\n`,_jsx(Heading,{level:`2`,id:`deleted-databases`,children:`Deleted databases`}),`\n`,_jsxs(_components.p,{children:[`When a database is deleted, its verified deletion backup stays downloadable\nfrom `,_jsx(_components.strong,{children:`Recently deleted`}),` for seven days. After that, the database and the\ndeletion backup are deleted permanently and automatically.`]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"Database backups in the DBHost dashboard","sidebarTitle":"Backups","description":"Trigger, download, delete and restore DBHost database backups from the dashboard, and see which environments get a daily logical backup.","href":"/dashboard/backups"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"How backups work","slug":"how-backups-work","depth":2,"children":[]},{"title":"Triggering a backup","slug":"triggering-a-backup","depth":2,"children":[]},{"title":"Viewing backup history","slug":"viewing-backup-history","depth":2,"children":[]},{"title":"Restoring from a backup","slug":"restoring-from-a-backup","depth":2,"children":[]},{"title":"Cloning a backup","slug":"cloning-a-backup","depth":2,"children":[]},{"title":"Restore your own file","slug":"restore-your-own-file","depth":2,"children":[]},{"title":"Downloading and deleting backups","slug":"downloading-and-deleting-backups","depth":2,"children":[]},{"title":"Deleted databases","slug":"deleted-databases","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":["/_mintlify/custom/stianlarsen-ef7289da/58171d9ca8b5b73b/marketing-tracking.js"],"subdomain":"stianlarsen-ef7289da","siteName":"DBHost","title":"Database backups in the DBHost dashboard - DBHost","navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{}},"lastModified":"2026-10-15T12:02:01.339Z","originalFileLocation":"dashboard/backups.mdx"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"system\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Trigger, download, delete and restore DBHost database backups from the dashboard, and see which environments get a daily logical backup.\">\u003cmeta data-mint-head name=\"application-name\" content=\"DBHost\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/stianlarsen-ef7289da/ivJJevrtmwvlIcQ2/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/mintlify-assets/_mintlify/favicons/stianlarsen-ef7289da/ivJJevrtmwvlIcQ2/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/stianlarsen-ef7289da/ivJJevrtmwvlIcQ2/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/stianlarsen-ef7289da/ivJJevrtmwvlIcQ2/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/stianlarsen-ef7289da/ivJJevrtmwvlIcQ2/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/mintlify-assets/_mintlify/favicons/stianlarsen-ef7289da/ivJJevrtmwvlIcQ2/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/mintlify-assets/_mintlify/favicons/stianlarsen-ef7289da/ivJJevrtmwvlIcQ2/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/mintlify-assets/_mintlify/favicons/stianlarsen-ef7289da/ivJJevrtmwvlIcQ2/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/mintlify-assets/_mintlify/favicons/stianlarsen-ef7289da/ivJJevrtmwvlIcQ2/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"Database backups in the DBHost dashboard - DBHost\">\u003cmeta data-mint-head property=\"og:description\" content=\"Trigger, download, delete and restore DBHost database backups from the dashboard, and see which environments get a daily logical backup.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"DBHost\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://docs.dbhost.app/dashboard/backups\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://dbhost.app/media/og/dbhost-managed-core-1200x630.png\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"Database backups in the DBHost dashboard - DBHost\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Trigger, download, delete and restore DBHost database backups from the dashboard, and see which environments get a daily logical backup.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://dbhost.app/media/og/dbhost-managed-core-1200x630.png\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/mintlify-assets/_mintlify/favicons/stianlarsen-ef7289da/ivJJevrtmwvlIcQ2/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"DBHost\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#6366f1\">\u003cmeta data-mint-head name=\"og:image:type\" content=\"image/png\">\u003cmeta data-mint-head name=\"og:image:alt\" content=\"DBHost — Postgres. Handled. Managed PostgreSQL hosting.\">\u003cmeta data-mint-head name=\"twitter:image:alt\" content=\"DBHost — Postgres. Handled. Managed PostgreSQL hosting.\">\u003clink data-mint-head rel=\"canonical\" href=\"https://docs.dbhost.app/dashboard/backups\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/dashboard/backups.md\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://docs.dbhost.app/#organization\",\"name\":\"DBHost\",\"url\":\"https://docs.dbhost.app\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/stianlarsen-ef7289da/SvPvaAf6yywKnLbd/images/logo-light.svg?fit=max\u0026auto=format\u0026n=SvPvaAf6yywKnLbd\u0026q=85\u0026s=04b5e34c4fa58314f697056f22b10346\"}},{\"@type\":\"WebSite\",\"@id\":\"https://docs.dbhost.app#website\",\"name\":\"DBHost\",\"url\":\"https://docs.dbhost.app\",\"publisher\":{\"@id\":\"https://docs.dbhost.app/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://docs.dbhost.app/dashboard/backups#webpage\",\"url\":\"https://docs.dbhost.app/dashboard/backups\",\"name\":\"Database backups in the DBHost dashboard\",\"description\":\"Trigger, download, delete and restore DBHost database backups from the dashboard, and see which environments get a daily logical backup.\",\"dateModified\":\"2026-10-15T12:02:01.339Z\",\"isPartOf\":{\"@id\":\"https://docs.dbhost.app#website\"},\"breadcrumb\":{\"@id\":\"https://docs.dbhost.app/dashboard/backups#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://docs.dbhost.app/dashboard/backups#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Dashboard\",\"item\":\"https://docs.dbhost.app/dashboard/databases\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database backups in the DBHost dashboard\",\"item\":\"https://docs.dbhost.app/dashboard/backups\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://docs.dbhost.app/dashboard/backups#article\",\"headline\":\"Database backups in the DBHost dashboard\",\"name\":\"Database backups in the DBHost dashboard\",\"description\":\"Trigger, download, delete and restore DBHost database backups from the dashboard, and see which environments get a daily logical backup.\",\"url\":\"https://docs.dbhost.app/dashboard/backups\",\"mainEntityOfPage\":{\"@id\":\"https://docs.dbhost.app/dashboard/backups#webpage\"},\"image\":\"https://dbhost.app/media/og/dbhost-managed-core-1200x630.png\",\"dateModified\":\"2026-10-15T12:02:01.339Z\",\"publisher\":{\"@id\":\"https://docs.dbhost.app/#organization\"},\"isPartOf\":{\"@id\":\"https://docs.dbhost.app#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"DBHost\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"DBHost\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/dashboard/backups.md","siteName":"DBHost","nav":{"global":null,"tabs":[{"tab":"Documentation","groups":[{"group":"Getting Started","public":true,"pages":[{"title":"Introduction","href":"/introduction"},{"title":"DBHost quickstart: your first PostgreSQL database","sidebarTitle":"Quickstart","href":"/quickstart"},{"title":"DBHost CLI reference","sidebarTitle":"CLI","href":"/cli"},{"title":"DBHost core concepts: databases, pooling, backups, roles","sidebarTitle":"Core concepts","href":"/concepts"},{"title":"Limits and what DBHost does not offer","sidebarTitle":"Limits","href":"/limits"}]},{"group":"Trust \u0026 Security","public":true,"pages":[{"title":"DBHost security model and honest limits","sidebarTitle":"Security","href":"/security"},{"title":"Backups, retention and deletion","sidebarTitle":"Backups and retention","href":"/backups-and-retention"}]},{"group":"Connect your app","public":true,"pages":[{"title":"Connect to DBHost with verify-full TLS","sidebarTitle":"TLS connections","href":"/guides/tls-connections"},{"title":"Next.js and PostgreSQL: Prisma, Drizzle or pg","sidebarTitle":"Next.js + PostgreSQL","href":"/guides/nextjs-postgres"},{"title":"Next.js and Prisma with DBHost PostgreSQL","sidebarTitle":"Next.js + Prisma","href":"/guides/nextjs-prisma"},{"title":"Next.js and Drizzle ORM with DBHost PostgreSQL","sidebarTitle":"Next.js + Drizzle","href":"/guides/nextjs-drizzle"},{"title":"Next.js and node-postgres (pg) with DBHost","sidebarTitle":"Next.js + pg","href":"/guides/nextjs-pg"},{"title":"Run schema migrations over a direct connection","sidebarTitle":"Direct migrations","href":"/guides/direct-migrations"}]},{"group":"Operate your database","public":true,"pages":[{"title":"Database roles: owner, runtime and additional roles","sidebarTitle":"Database roles","href":"/guides/database-roles"},{"title":"Connection limits and query timeouts","sidebarTitle":"Connection limits and timeouts","href":"/guides/connection-limits-and-timeouts"},{"title":"Inactive databases","sidebarTitle":"Inactive databases","href":"/guides/inactive-databases"},{"title":"Supported PostgreSQL extensions: citext, pg_trgm, pgcrypto","sidebarTitle":"PostgreSQL extensions","href":"/guides/postgres-extensions"},{"title":"Restore a database from a DBHost backup","sidebarTitle":"Restore from a backup","href":"/guides/restore-from-backup"},{"title":"Import your own SQL dump with psql or pg_restore","sidebarTitle":"Restore your own dump","href":"/guides/restore-your-own-dump"},{"title":"Preview databases for CI and pull requests","sidebarTitle":"Preview databases","href":"/guides/preview-databases"},{"title":"Automate DBHost with the CLI and REST API","sidebarTitle":"CLI + API automation","href":"/guides/cli-api-automation"},{"title":"Self-Hosted Postgres vs DBHost for Small SaaS Teams","sidebarTitle":"Self-hosted vs DBHost","href":"/guides/self-hosted-postgres-vs-dbhost"}]},{"group":"Dashboard","public":true,"pages":[{"title":"Manage PostgreSQL databases in the DBHost dashboard","sidebarTitle":"Databases","href":"/dashboard/databases"},{"title":"Connection history and access audit","sidebarTitle":"Connection history","href":"/dashboard/connection-history"},{"title":"Account and database activity log","sidebarTitle":"Activity","href":"/dashboard/activity"},{"title":"Data Explorer: read-only SQL in the dashboard","sidebarTitle":"Data Explorer","description":"Browse public tables and run guarded read-only SELECT and EXPLAIN queries on your DBHost database from the dashboard, with saved queries.","href":"/dashboard/explorer"},{"title":"Database backups in the DBHost dashboard","sidebarTitle":"Backups","href":"/dashboard/backups"},{"title":"Create and manage DBHost API keys","sidebarTitle":"API keys","description":"Create, scope, replace and revoke DBHost API keys on Pro and Business. Use selected-database keys for least privilege in CI and scripts.","href":"/dashboard/api-keys"},{"title":"Account, billing and plan settings","sidebarTitle":"Settings","href":"/dashboard/settings"}]}]},{"tab":"API Reference","pages":[{"title":"API Reference","href":"/api-reference/introduction"}]}]},"basePath":"","title":"Database backups in the DBHost dashboard - DBHost","buildId":"dpl_9RFrWkXdFTJCytfx6jAofvAaEXr6","deploymentId":"dpl_9RFrWkXdFTJCytfx6jAofvAaEXr6","dynamics":[],"chunks":[]}