Version Migration

Thu Aug 31 18:57:57 EDT 2017

I do something similar, working between my office PC & my home PC but I 
use SpiderOakONE to backup & synchronize the two PC's. However, my 
GnuCash file is an SQLite database and I found that SOO did not play 
well with the GnuCash file, since GnuCash writes each transaction, one 
at a time to the file. SOO then was seeing each new transaction as a 
"new" file & trying to back it up resulting in a terrific number of 
historical files in the SOO archive.

One way around this problem is to program the SOO program only to backup 
files at certain times of the day, when you are not using GnuCash. What 
I did was to write a simple script that copies the .gnucash directory 
into a working directory which is not monitored by SOO & then when I 
closed the program copy the resulting .gnucash directory back to where 
SOO would see it.

Hope this helps!

CMR

On 08/31/2017 03:28 PM, Rui Dias Costa wrote:
> Hi,
>
> We use gnucash in two distinct computers running on windows. Both have the work files are in complete sync, including a copy of the gnucash database files.
> Since the computers function at different moments in time, never at the same time, they both run gnucash all right. No issues.
> For instance, we can turn it off in one machine, go to the other and continue were we left things.
>
> To sync them we use Resilio Sync. We had some troubles while back using dropbox to do this job. Always worked fine.
>
> Regards,
> Rui
>
>
>
>> On 31 Aug 2017, at 20:46, Robert Heller <heller at deepsoft.com> wrote:
>>
>> At Thu, 31 Aug 2017 14:29:10 -0400 james <garftd at verizon.net> wrote:
>>
>>> On 08/31/17 13:35, Matthew Pounsett wrote:
>>>> On 31 August 2017 at 13:33, Geert Janssens <geert.gnucash at kobaltwit.be>
>>>> wrote:
>>>>
>>>>> While these solutions will work most of the time they all have the same
>>>>> risk:
>>>>> if the snapshot is made while gnucash is updating the db, you end up with
>>>>> an
>>>>> inconsistent db file. I don't know how well sqlite3 handles this so the
>>>>> risk
>>>>> may be high or low.
>>>>>
>>>>> I've done a few spot-checks for consistency and never run into a problem.
>>>> I don't know this for certain, but it looks as if GnuCash is wrapping each
>>>> update in a transaction.  If it is doing that, it would ensure that the
>>>> data written to disk is never inconsistent.
>>>> _______________________________________________
>>>> gnucash-user mailing list
>>>> gnucash-user at gnucash.org
>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>> -----
>>>> Please remember to CC this list on all your replies.
>>>> You can do this by using Reply-To-List or Reply-All.
>>>>
>>>
>>> Since my company is small, I'm sticking with the legacy gnu system, for
>>> now. That's the permanently offline system I'm in the process of
>>> migrating too.
>>>
>>> Is anyone basically using a USB stick for all records? If so, can you
>>> just plug that USB stick into any of several different (but same version
>>> of gnucash), make changes and store all records on a usb 2 or 3 device?
>>> Then copy usb-stick  for backups?
>> Should be possible.  A USB stick is just another file system.  There is no
>> *set-in-stone* reason gnucash's data *has* to be the local system disk.
>> A given version of Gnucash should behave the same on any number of different
>> systems.  Generally, the *preferences* (including saved reports) would be
>> local to each system (since they live in $HOME).  You might need to use the
>> File->Open menu item to open the data file.
>>
>>> Like others, I am curious to track the database progress, as well as
>>> running gnucash on a cluster.
>>>
>>>
>>> Anyone running many instances of GNUcash on containers, alpine or just
>>> a bunch of VMs?  I'd be most interested in those experiences too.
>>> Projects of such  multiplicative offerings of gnucash I could follow?
>> I have a desktop Linux machine (CentOS 6, x86_64) and a laptop Linux machine
>> (also 6, x86_64).  Generally I run GnuCash (2.4.15-4.el6) on my desktop Linux
>> machine.  I do have a procedure (shell script) to rsync the GnuCash data &
>> prefs onto my laptop on occasion, I run GnuCash (also 2.4.15-4.el6) there and
>> then rsync the GnuCash data & prefs back to my desktop Linux machine.
>>
>> I don't know if this counts towards what you are asking.
>>
>>> James
>>>
>>>
>>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at gnucash.org
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -----
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>>
>>>
>> -- 
>> Robert Heller             -- 978-544-6933
>> Deepwoods Software        -- Custom Software Services
>> http://www.deepsoft.com/  -- Linux Administration Services
>> heller at deepsoft.com       -- Webhosting Services
>>
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-- 
"The right of citizens to bear arms is just one guarantee against arbitrary government, one more safeguard against the tyranny which now appears remote in America, but which historically has proved to be always possible.  And in his 1860 Presidential campaign the “Great Emancipator” himself, Abe Lincoln said: The people — the people — are the rightful masters of both Congresses, and courts — not to overthrow the Constitution, but to overthrow the men who pervert it." -- Huburt H. Humphrey
--------