UAO database backup & restore

To backup the UAO database please follow the steps:
1. sudo -u postgres pg_dump -Fc uao > ~/uao-dump.sql
2. Copy the 'uao-dump.sql' file to your PC / external drive

Once system is reinstalled & you want to restore the database, please follow the steps:
1. Upload the 'uao-dump.sql' file back to the server into '~/' location
2. sudo -u postgres pg_restore -d uao --clean --single-transaction ~/uao-dump.sql
 

Did you find this article helpful?