Andrea Peri wrote: > After some searches, I found the trouble is due to the vacuum command > that is going to use > the /var/tmp folder for temporary files. > > I like to say to the sqlite to use instead the /tmp. > [...] > Unfortunatelly I do not found in the documentation no one alternative > to the deprecated temp_store_directory.
This is OS dependent. In your case, SQLite's temporary directory is 1. whatever is set with the PRAGMA temp_store_directory command; or 2. whatever is set with the SQLITE_TMPDIR environment variable; or 3. whatever is set with the TMPDIR environment variable; or 4. /var/tmp; or 5. /usr/tmp; or 6. /tmp. Regards, Clemens