Skip to main content

volume_instance_backups

Creates, updates, deletes, gets or lists a volume_instance_backups resource.

Overview​

Namevolume_instance_backups
TypeResource
Idrailway.storage.volume_instance_backups

Fields​

The following fields are returned by SELECT queries:

One row per VolumeInstanceBackup.

NameDatatypeDescription
idstring
namestring
creator_idstring
external_idstring
schedule_idstring
created_atstring (date-time)
expires_atstring (date-time)
referenced_mbinteger
used_mbinteger
volume_instance_size_mbinteger

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectvolume_instance_idList backups of a volume instance. Backed by the Railway GraphQL query volumeInstanceBackupList.
createinsertvolume_instance_idCreate backup of a volume instance. Backed by the Railway GraphQL mutation volumeInstanceBackupCreate.
deletedeletevolume_instance_backup_id, volume_instance_idDeletes volume instance backup. Backed by the Railway GraphQL mutation volumeInstanceBackupDelete.
lockexecvolume_instance_backup_id, volume_instance_idRemoves backup expiration date. Backed by the Railway GraphQL mutation volumeInstanceBackupLock.
restoreexecvolume_instance_backup_id, volume_instance_idreplica_service_ids, wipe_service_idsRestore a volume instance from a backup. Backed by the Railway GraphQL mutation volumeInstanceBackupRestore.

Parameters​

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
volume_instance_idstringThe id of the volume instance to list the backups of.
replica_service_idsarrayOptional: for HA cluster restores, service IDs of replicas that should also receive the backup.
volume_instance_backup_idstringThe volume instance's backup id.
wipe_service_idsarrayService IDs whose volumes should be wiped (replaced with fresh empty volumes) as part of this restore.

SELECT examples​

List backups of a volume instance. Backed by the Railway GraphQL query volumeInstanceBackupList.

SELECT
id,
name,
creator_id,
external_id,
schedule_id,
created_at,
expires_at,
referenced_mb,
used_mb,
volume_instance_size_mb
FROM railway.storage.volume_instance_backups
WHERE volume_instance_id = '{{ volume_instance_id }}' -- required
;

INSERT examples​

Create backup of a volume instance. Backed by the Railway GraphQL mutation volumeInstanceBackupCreate.

INSERT INTO railway.storage.volume_instance_backups (
name,
volume_instance_id
)
SELECT
'{{ name }}',
'{{ volume_instance_id }}' /* required */
RETURNING
workflow_id,
archive_continuity_unverified_reason,
archive_continuity_verified
;

DELETE examples​

Deletes volume instance backup. Backed by the Railway GraphQL mutation volumeInstanceBackupDelete.

DELETE FROM railway.storage.volume_instance_backups
WHERE
volume_instance_backup_id = '{{ volume_instance_backup_id }}' --required
AND volume_instance_id = '{{ volume_instance_id }}' --required
;

Lifecycle Methods​

Removes backup expiration date. Backed by the Railway GraphQL mutation volumeInstanceBackupLock.

EXEC railway.storage.volume_instance_backups.lock
@volume_instance_backup_id='{{ volume_instance_backup_id }}', --required
@volume_instance_id='{{ volume_instance_id }}' --required
;