Table Of Contents |
 |
|
Questions And Answers
| Q: |
Can Recovery for PostgreSQL repair my PostgreSQL database? |
| A: |
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! |
| Q: |
What limitations does the demo version of Recovery for PostgreSQL have? |
| A: |
The demo version recovers limited number of rows from the corrupted database. The remaining rows will be blank. Full version of Recovery for PostgreSQL recovers demo-limited records as well.
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. |
| Q: |
I have tried the demo. How do I decide whether to purchase the full version of Recovery for PostgreSQL? |
| A: |
Evaluating the results of demo recovery can help in making the decision. |
| Q: |
What are the differences between product licenses? |
| A: |
Details of current licensing scheme are described at the Licensing page. |
| Q: |
Why do results of recovery contain less data than the original PostgreSQL database? |
| A: |
This is normal. The damaged parts of your PostgreSQL database will convert to zero size on output. The other common reason of file size decrease is when some of features of the original database are not supported and therefore absent from the recovered database.
Demo-recovered database is smaller because it mostly consists of demo placeholders than actual data. |
| Q: |
Running Recovery for PostgreSQL from command line (through Windows Start -> Run menu). |
| A: |
If your license type is Enterprise or Franchise, 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)>"
(without angle brackets).
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).
|
| Q: |
After running Recovery for PostgreSQL on the corrupted database, a folder with sql script(s) and batch file has been created. How could these files be transfigured into a new database? |
| A: |
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). |
Recovery for PostgreSQL Error Messages
| Q: |
Recovery for PostgreSQL Error: Internal Program Error message. |
| A: |
Run Recovery for PostgreSQL in a logged mode and contact our support team with detailed description of the problem and the log file.
To create log file, please hold the SHIFT key while clicking the Recover button on the toolbar of Recovery for PostgreSQL or selecting the Recover: item in the main menu. You can also press CTRL+SHIFT+R after launching Recovery for PostgreSQL. |
| Q: |
Recovery for PostgreSQL Error: Not enough disk space. |
| A: |
To fix this problem you need to set temporary directory to the drive with free space available (2-3 times of the original database size). Fix the Windows environment variable to use it. Do the following:
- Open System in Control Panel.
- On the Advanced tab, click Environment Variables, then click the name of the user variable (TEMP or TMP) you want to change.
- Click Edit to change value.
- Set path to the location where temporary data should be stored (e.g., e:\).
- Restart computer for changes to take in effect.
- Run the software again.
You can also use the special environment variable called OFFICERECOVERY_TMP to set the directory where Recovery for PostgreSQL should store its temporary files. Use the method shown above to add/edit environment variable. |
|
|
Product Guide |
|
|
|
