Backup User database and restore

this is a page about restoring users

In order to save and restore users between database reloads, execute the following script;

pg_dump --column-inserts -a -t "\"sysAuthIdentity\"" -t "\"sysAuthInfo\"" -t "\"sysAuthToken\"" -t "\"sysUser\"" -f users.sql -U artecams -h 127.0.0.1 -d artecams

This will place the file 'users.sql' in to the folder. It is then safe to~ drop the entire database and rebuild it. Before registering any new users in to the system then execute the following;

developer@rtmus2:~/projects/artecams$ ./psql.sh
psql (10.10 (Ubuntu 10.10-0ubuntu0.18.04.1))
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
Type "help" for help.

artecams=> \i users.sql

This will re-import the users from the previously saved sql file. All of the users should be able to log in like before.