Rolling Back PostgreSQL Continuous Archiving to a Previous Point-in-Time

After continuous archiving has been set up, you can roll back to an older version of the portal database.

To roll back PostgreSQL continuous archiving to a previous point in time:

1. Using SSH, log in as root to your CTERA Portal primary database server.
2. In the command line, enter the following command to view the oldest time possible to roll back to: portal.sh db-rollback -p
3. Enter the following command to roll back to a point in time within the available backup range: portal.sh db-rollback -r " point-in-time"
   Where point-in-time is the desired point in time, in the format YYYY-MM-DD hh:mm:ss.
   For example: portal.sh db-rollback -r "2020-06-10 00:23:21"
4. When rolling back a primary database server, from which a replication server is streaming, described in Using PostgreSQL Streaming Replication, restart the CTERA Portal on the secondary database server, the replicating server, by running: portal-manage.sh restart