Sign in
Postgres

Trigger point-in-time recovery

Trigger point-in-time recovery on the Postgres instance with the provided ID.

post/postgres/{postgresId}/recovery

Path parameters

postgresIdstring required

Request body

restoreNamestring

Name of the new database.

restoreTimestring date-time required

The point in time to restore the database to. See /recovery-info for restore availability

datadogApiKeystring

Datadog API key to use for monitoring the new database. Defaults to the API key of the original database. Use an empty string to prevent copying of the API key to the new database.

datadogSitestring

Datadog region code to use for monitoring the new database. Defaults to the region code of the original database. Use an empty string to prevent copying of the region code to the new database.

planstring

The plan to use for the new database. Defaults to the same plan as the original database. Cannot be a lower tier plan than the original database.

environmentIdstring

The environment to create the new database in. Defaults to the environment of the original database.

Response

Recovery initiated

idstring required
createdAtstring date-time required
updatedAtstring date-time required
expiresAtstring date-time

The time at which the database will be expire. Applies to free tier databases only.

dashboardUrlstring required

The URL to view the Postgres instance in the Render Dashboard

databaseNamestring required
databaseUserstring required
environmentIdstring
highAvailabilityEnabledboolean required
maintenanceMaintenance — unresolved $ref
namestring required
planPlan required— unresolved $ref
diskSizeGBinteger
parameterOverridesPostgresParameterOverrides
primaryPostgresIDstring
region'frankfurt' | 'oregon' | 'ohio' | 'singapore' | 'virginia' required

Defaults to "oregon"

role'primary' | 'replica' required
status'creating' | 'available' | 'unavailable' | 'config_restart' | 'suspended' | 'maintenance_scheduled' | 'maintenance_in_progress' | 'recovery_failed' | 'recovery_in_progress' | 'unknown' | 'updating_instance' required
version'11' | '12' | '13' | '14' | '15' | '16' | '17' | '18' required

The PostgreSQL version

suspended'suspended' | 'not_suspended' required
suspendersSuspenderType[] required
diskAutoscalingEnabledboolean required
connectionPoolstring required

What connection pool to use (if any) out of 'pgbouncer' and 'none'

Changes