Hello, list!

I am currently using SQLite Databases (v3.5.8) stored on NAS servers and I
have to take snapshosts of these storage devices. The snapshots must be
accessible, and the database files can be found in well-named directories
whose content has read-only permissions.

My problem is that hot-journal files are snapshot'd too. When I try to open
a DB file having such a journal, the opening fails. The user has read
permissions (according to the file permissions) on the database file itself,
but that the FS that is read-only.

I tried several PRAGMA to ignore the -journal files but I didn't get
satisfaction. I still have the possibility to patch sqlite3 itself, but I
hope there will remain another possibility.

Can you please help me? Any URL, advice or code sniplet will be welcome.
Please let me know if you need more information.

Thanks,

-- 
JF Smigielski
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to