Database Recovery

There is a db recovery script installed during Galaxy deployment at /var/lib/postgresql/backups/bin/restore_postgress.sh

The source file is here.

One has to specify a folder to recover from (one from /db_backups/, usually current) and optionally a timepoint in a format 2024-01-18 10:00:00 (New York time).

So

/var/lib/postgresql/backups/bin/restore_postgress.sh current

should do the job in most of the cases.