PostgreSQL backups
Create PostgreSQL backups, configure automatic schedules and review backup history.
RDC Cloud can create and retain a backup of the managed PostgreSQL database. Backups use the existing instance and keep its connection information unchanged.
Availability and permissions
If backup creation is unavailable in Console, contact support.
Relational Database Viewer and General Viewer roles can read backup history. Relational Database Admin, General Admin and General Owner roles can create backups and manage automatic schedules. Eligible roles assigned at Workspace scope also apply to its Projects. The database must be active and have no other resource operation in progress.
Create a backup
- Select your workspace and project.
- Open Relational Database and select the PostgreSQL resource.
- Open Backups and select Create backup.
- The Console confirms that the request was accepted. Select Refresh to check its progress.
History distinguishes Manual and Automatic attempts and shows the requested, started and completed times, status, archive size and failure details. It does not refresh automatically. Use Previous and Next to browse older attempts.
A Queued or In progress attempt is not a completed backup. Completed means that the backup was created and stored successfully. Failed attempts do not have a completed archive.
Configure automatic backups
- Open the database's Backups page.
- Under Automatic backups, select Enable automatic backups.
- Choose Daily or Weekly. For a weekly schedule, choose a day of the week.
- Set the time and an IANA time zone, such as
Asia/SeoulorUTC. - Select Save schedule and review the next scheduled run.
Automatic scheduling stops if the user who configured the schedule becomes inactive, leaves the Workspace or loses backup creation permission. Assign the required role before enabling the schedule again.
Select Reload schedule to load the latest saved settings. To stop future automatic backups, clear Enable automatic backups and save. Operations already queued can still complete.
A stopped database or one with another operation in progress skips that scheduled run. After a scheduler outage, RDC creates at most one catch-up backup rather than replaying every missed run. Schedules follow the configured time zone, including daylight-saving changes.
The schedule uses the access of the user who last saved it. If that user loses the required access, automatic scheduling is disabled when checked. Another authorized member can save and enable the schedule again.
Retention
RDC keeps the latest seven successful automatic backups for each database. Failed attempts do not count toward this limit. Older automatic archives are removed from storage, and their history remains with an Expired status and expiration time.
Manual backups are retained and are not deleted by this policy. Disabling an automatic schedule does not remove its retained backups or change the seven-backup retention policy.
Contents and limits
The archive contains the selected database's schema and data. It does not include cluster-wide users and passwords, access grants, other databases, server configuration or transaction logs.
- The compressed archive is limited to 1 GiB.
- Creating the backup archive must finish within five minutes. A timed-out attempt is marked as failed.
- Resource operations, including stopping or deleting the database, cannot run concurrently with its backup.
- Restore, downloads, custom retention policies and point-in-time recovery are not available yet.
Failed attempts
For a timeout or interrupted backup, check that the database is available and request a new backup. If the archive exceeds the current size limit or failures continue, contact support. A failed attempt does not change your database connection information.