Recovery for PostgreSQL

The effective way to find out if a PostgreSQL database is recoverable is to try the demo version of Recovery for PostgreSQL on it. Visit the Demo page for a free copy of the demo.

Product specifications with lists of items recovered and not recovered is available at the Product Information page.

Note: Always backup your original corrupted PostgreSQL database before proceeding with any recovery activity!

No additional rows or tables or any other elements and features of the original database will be recovered by commercial version of Recovery for PostgreSQL if absent from demo output.

Evaluating the results of demo recovery can help in making the decision.

Details of current licensing scheme are described at the Licensing page.

If your license type is Enterprise or Service, you can run Recovery for PostgreSQL from command line and use these calls in your batch files. Standard version does not support command line. The format for command line call is:

pgr.exe <original filename with path> "<path to directory to store the recovered file(s)>"

Please note that the directory for recovered file(s) should be created before starting the recovery.

Command line mode supports patterns '*' (replaces group of symbols) and '?' (replaces one symbol).

To recreate database, process resulting sql scripts starting with schema.sql and following by dataNNNN.sql. The database will be recreated from scratch.

To make the import procedure more convenient for the end-user an appropriate batch file is automatically created and put in the same folder as sql script(s).