Temporal Restoration or Backup

Community Support
, ,
1

Hi Team,
I had some questions regarding the backup options we have in temporal. I was wondering if my postgresql server was to crash or has it’s data lost due to some reason, and if I were to restore it from an old dump, will it work?
Also, I have a temporal installation running using docker-compose, now we’re going live, but still have workflows scheduled on the docker-compose installation. What would be best way to transfer those workflows, the cron scheduled ones to the new production installation?

I tried taking a dump of the postgresql db running using docker-compose and restored it in a separate environment and ran the Temporal-Server executable from here and ran the Web UI using docker image. I used my postgres dump connection information in the config for the executable, but I’m getting the following error logs:
http://jsonblob.com/1000988484445683712 .

2

I have a temporal installation running using docker-compose

Are you using the auto-setup image? Old and new clusters are same versions (which ones)?
How are you taking the db dump and restoring? When you say “and restored in in a separate environment” could you give some details? Whats the env diff if any?

What would be best way to transfer those workflows, the cron scheduled ones to the new production installation?

In these cron workflows do you define WorfklowExecution timeouts? If you do then you could let their executions time out on existing server and move to new (start them again). If not you could cancel them or terminate and start new executions on new cluster.

Temporal also supports multi-cluster replication for backup and state reconstruction which seems you could benefit from for your use case.