Porting Enrollment Database Cluster to Docker

This guide will show you how to backup data face enrollment.

Requirement Visionaire Cluster Version

Minimal versioniva-api for this guide is 2.6.1 and above.

Export data face known collection from psql table to CSV.

1. Access database with psqlcommand

Run this command in terminal psql -U <db-usename> -d <database-name>. Example :

psql -U nodeflux -d db_iva_security

2. Export table face_known_collection to CSV file

Run this command in terminal \copy (select nik as identity_number, name, status, foldername from face_known_collection) To <path-to-copy-csv> with CSV. Example :

\copy (select nik as identity_number, name, status, foldername from face_known_collection) To '~/face_enrollment.csv' with CSV

3. Update CSV file

• Open CSV file

• Add this data to the first column identity_number,name,status,foldername

• The CSV file will look like this

$ cat face_enrollment.csv 
identity_number,name,status,foldername 
3232,Berlian Putri,Data Nusantara Adhikarya,199@berlianputri 
6234,Nabila,Nodeflux,121@nabila 
43576879096857465,Bella Widyawati,FIF,203@bellawidyawati 
98917,Norman,Nodeflux,123@norman 
87879,Febrian,Nodeflux,5@febrian

Another guide :

• export data with PGAdmin - source

3. Backup image face enrollment

a. Locate folder dump image face enrollment

For this step you must know the path of dump image face enrollment usually the folder will be located at /data/ftp/target-data/rule-face-recognition/ but if you can't find the right path you can see config marathon service iva-web-api, see image below for example.

b. Copy folder face enrollment

After you locate the folder, copy the folder rule-face-recognition, for the subfolder will look like this :

Copy the folder to the desired location.

Then you can continue to the page below:

pageBatch Enrollment