1. Home
  2. Docs
  3. Aveditor
  4. Private: Pro version
  5. Installation
  6. Create the aveditor database

Create the aveditor database

This posgres aveditor database stores all the vehicles recorded by the ANPR engine. The database is necessary for the pro version but not for the free version.

Open psql

psql is a terminal-based front-end to PostgreSQL. It enables you to type in queries interactively, issue them to PostgreSQL, and see the query results.



Open a cmd prompt.

This image has an empty alt attribute; its file name is 650x288xWindows_07.jpg

Change directory to Appdata/lpreditor/aveditor :

This image has an empty alt attribute; its file name is image-1.png

To run psql, you need to use a login (by default you can use “postgres”). You will be asked for a password (type the one chosen when you installed Postgresql).

Then hit :

psql -U postgres
This image has an empty alt attribute; its file name is image-2.png

Run the aveditor_create.sql script

\i aveditor_create.sql
This image has an empty alt attribute; its file name is image-3.png
This image has an empty alt attribute; its file name is image-4.png

Check the aveditor database

Check that the aveditor database is created on postgresql server.

Open the application pgAdmin4. Normally, it has been installed with postgreSQL.

This image has an empty alt attribute; its file name is image-5.png
You can see the aveditor database with its tables created.
Was this article helpful to you? Yes No

How can we help?