sqadm restore(1)

sqadm restore - Restore Squore data from backup

sqadm restore [--with-pg-dump] [--plain-sql] [--no-analyze] [--jdbc-url url] [--jdbc-user user] [dir]

This command restores a Squore backup created with sqadm backup.

The sqadm restore command shall be executed on a stopped Squore server, but a running database.

--with-pg-dump

Use database backup of remote PostgreSQL cluster.

--plain-sql

Switch to PostgreSQL plain-text dump file format.

This option is used in conjunction with the same option name in the sqadm backup command.

--no-analyze

Do not collect statistics about PostgreSQL database.

Statistics allow the PostgreSQL optimizer to pick the right execution plan. So except for a few use cases, you should not use this option.

--jdbc-url url

Use alternate database connection, with url of the form jdbc:subprotocol:subname.

--jdbc-user user

Use alternate database username.

dir

Specify an alternate Squore backup directory.