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.
1 continuous archivingUsing SSH, log in as root to your CTERA Portal server.
2 In the command line, enter the following command to view the oldest time possible to roll back to: ctera.sh db-rollback -p
3 Enter the following command to roll back to a point in time within the available backup range: ctera.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: ctera.sh db-rollback -r "2015-06-10 00:23:21"
4 When rolling back a Primary DB Server, Master DB or Catalog Node, from which a replication server is streaming, described in
Using PostgreSQL Streaming Replication, restart the CTERA Portal on the secondary DB server, the replicating server, by running:
ctera-portal-manage.sh restart