• 4. How do I backup and restore databases?

    Consider the use of PostgreSQL. For other DBMSs, please refer to their respective help tools to obtain their backup&restore procedures.

    a. Backup

    When working with PostgreSQL, open pgAdmin, right-click on the database and select Backup. Type the file name and click Ok.

    b. Restore

    Open pgAdmin and create a new database. Right-click on it and select Restore. Search for the backup file and click Ok. After the restoration is finished, open the SQL window and run the following line replacing "name_of_your_DB" with the name of the DB you have previously created for the restoration:

    ALTER DATABASE "name_of_your_DB" SET search_path=public, sisprodes, terralib, raster;

    Created on 20/11/2013 in FAQ Terra Amazon - Site

    Was this helpful?