If I am trying to change the max_page_count use the SEE.EXE program, 
how do I get the value to be updated in the database.  Every time I try 
changing this and then exit see.exe, the value has not changed.  Do I need the 
updated encryption extension first?

Andrew Stewart
Argus Control Systems Ltd.

-----Original Message-----
From: sqlite-users [] On 
Behalf Of Richard Hipp
Sent: Tuesday, November 14, 2017 11:33 AM
To: SQLite mailing list <>
Subject: Re: [sqlite] 1TB limit on encrypted database

On 11/14/17, Andrew Stewart <> wrote:
> Hi,
>                 I appear to have reached an issue with a 1TB limit on
> an encrypted database.  The page_size is 1024.  The max_page_count is
> 1073741823.  I don't appear to be able to change either of these numbers.
> Any assistance would be appreciated.

You can try:

   PRAGMA max_page_count=2000000000;

Probably you should also look into increasing the page size:

   PRAGMA page_size=8192;

For that last step, make sure you have upgraded to a recent version of the 
encryption extension as some of the older versions had issues.
Also, note that the VACUUM will take some time and will require a couple TB of 
temporary disk space while it is running.

D. Richard Hipp
sqlite-users mailing list
Notice: This electronic transmission contains confidential information, 
intended only for the person(s) named above. If you are not the intended 
recipient, you are hereby notified that any disclosure, copying, distribution, 
or any other use of this email is strictly prohibited. If you have received 
this transmission by error, please notify us immediately by return email and 
destroy the original transmission immediately and all copies thereof.
sqlite-users mailing list

Reply via email to