PostgreSQL - session recovery?

Question

I have just had a power outage while working on some complex queries using PostgreSQL and pgAdmin 4. Is there any way I can restore the session and get the queries the same way other systems do?

Answer 1

If your

• log level is high enough they'll be in the log

• Or, if using PgAdmin,

  History file path - The History file path specifies the path to the Query tool’s history file. The default file name is pgadmin_histoqueries.xml; you can use the Browse button to open a file browser and modify the location of the file.

Shy of that no. And, that's not really session recovery. It's just seeing the last executed commands.