Comment on page

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: