Re: [sqlite] Increase page_size on existing db with data and WAL

[Richard Hipp]

On 1/16/15, Andy (KU7T)  wrote:
> Hi,
>
>
>
> When I read this: http://sqlite.org/pragma.html#pragma_page_size it seems
> to
> argue that I can never change the page_size on a non-empty db that is
> running in WAL mode.  Any tips how I can still do this?
>
>

Change out of WAL mode, convert the page size, then change back to WAL mode.

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Increase page_size on existing db with data and WAL

[Andy (KU7T)]

Hi,

 

When I read this: http://sqlite.org/pragma.html#pragma_page_size it seems to
argue that I can never change the page_size on a non-empty db that is
running in WAL mode.  Any tips how I can still do this?

 

Thanks

Andy

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users