How do I restore my data?
Assuming you have followed the How Do I Backup My Data instructions, you can restore your database as follows...
1) Restore the roles
$ psql -h [database host] -U [database admin user] < [roles backup file]
For example:
$ psql -h localhost -U lsmb_dbadmin < lsmb-roles.sqlc
2) Create a new database to restore into
$ psql -h [database host] -U [database admin user] -c 'CREATE DATABASE [new company name]'
For example:
- Read more about How do I restore my data?
- Log in or register to post comments