I need to know how to bring a database back from an export.

Question

After a reboot of the server Jira will not start. The postgresql error is PANIC:  could not locate a valid checkpoint record.

At this point I have spent hours trying to fix with no luck. Can someone tell me how to dump the current database data to I can get it online and then if the Application Data\export folder has what I need to bring it completly back up. The reason I am trying to do this is the server crashed and restarted and the backup drive wont let me do a restore. it is a usb drive and everytime i try to do a restore it is showing the files and locked. Really strange issue. At this point iff the export folder has what I need I would like the proess to start over and import.

Nic Brough -Adaptavist- · Answer

You'd need to be asking about repairs on a postgres forum I'm afraid, this is beyond what I've seen.

For the export files though, it is moderately easy.  Get a new Jira up and running (make sure it is the same version as the old one), with a single admin user, place the export file into <new jira home>/import and go to admin -> backup and restore -> restore from xml

Samuel Yontz · Answer

I made a backup of the files and then ran the -f version of the command and now I get this but it does not stay running.

2018-02-04 18:47:50 CST LOG: database system was shut down at 2018-02-04 18:47:40 CST
2018-02-04 18:47:50 CST FATAL: could not access status of transaction 44791227
2018-02-04 18:47:50 CST DETAIL: Could not open file "pg_clog/002A": No such file or directory.
2018-02-04 18:47:50 CST LOG: startup process (PID 7552) exited with exit code 1
2018-02-04 18:47:50 CST LOG: aborting startup due to startup process failure

Samuel Yontz · Answer

Here is what that command gives me

The database server was not shut down cleanly.
Resetting the transaction log might cause data to be lost.
If you want to proceed anyway, use -f to force reset.

I have the export zip files but do not know how to use them. Do you have instructions?