Backing Up and Restoring AtScale Database Instances

The following topic covers backing up and restoring embedded AtScale PostgreSQL database instances. You can back up instances of AtScale databases to .dump files and restore instances from those files.

info

note

Note: This section deals solely with backing up and restoring AtScale PostgreSQL database instances. To perform a full back up of AtScale see Backing up and Restoring AtScale.

Backing up AtScale database instances

This command creates a .dump file in the directory /opt/atscale/data/dump/. :

/opt/atscale/current/bin/database/postgres_backup [-f|--force]

-h|--help
Shows the options for the command.

-f|--force
Turns off interactive mode. This option is useful when you run this command via scripts.

Restoring AtScale database instances

This command restores instances from files that were output by AtScale's postgres_backup command. It outputs a log file with the name postgres_restore_<timestamp>.log to /opt/atscale/log/. Refer to this log file if the command fails.

info

note

Prerequisite: Before running this command, you must close any connections from other AtScale processes to the database instance:

To stop other AtScale processes

/opt/atscale/bin/atscale_stop_apps
/opt/atscale/bin/atscale_service_control stop egress

/opt/atscale/current/bin/database/postgres_restore -i <infile> [-n|--schema schema_name] [-f|--force]

-h|--help
Shows the options for the command.

-i|--infile
Specifies the path to the file that was output by the postgres_backup command.

-n|--schema
Restores only the objects that are in the specified schema.

-f|--force
Turns off interactive mode. This option is useful when you run this command via scripts.