Collapse AllExpand All

6.7. Download and Restore an xTuple Database on your new Database

Once you have followed the steps above, you are ready to restore an xTuple backup into the database you created. You can download the xTuple database backup files from the project site on GitHub, as follows:

  • empty.backup — Empty database with no data, but all tables and structures are created

  • quickstart.backup — Contains a basic chart of accounts and also the account assignments required to run the full range of transactions

  • demo.backup — Contains a suite of sample data built on top of the quickstart.backup database

To restore a backup file using pgAdmin, connect to the database you created. Right-click on the database object and select the option Restore. On the resulting screen, use the ellipses to navigate to the location of the backup file on your local machine. With the backup file selected, simply click OK. To learn more about the psql utility or the pgAdmin application, please consult the PostgreSQL documentation.