Change storage format of existing data

[David T.]

Rich,

The information about the SQL back ends is somewhat hidden, mostly because the SQL back end is still considered in development and provides little immediate benefit to users. 

There are references to it on the wiki (https://wiki.gnucash.org/wiki/Dependencies <https://wiki.gnucash.org/wiki/Dependencies>, https://wiki.gnucash.org/wiki/Building#Ubuntu_14.04_LTS_.28Trusty_Tahr.29 <https://wiki.gnucash.org/wiki/Building#Ubuntu_14.04_LTS_.28Trusty_Tahr.29>), which appear to be the most documentation out there. I feel like there have been users over the years who have asked for (and received) guidance on this, but cannot locate the threads on the list at this time.

As others have mentioned, you need to have libdbd drivers installed for the database backend you plan to use, and I believe you have to build GnuCash yourself to have GnuCash aware of the drivers—a requirement that prevents most Windows and Mac users from ever using them. Since you’re on Slackware, take a look at those two wiki pages and see if they help you.

David

> On Jan 29, 2017, at 7:05 PM, Rich Shepard <rshepard at appl-ecosys.com> wrote:
> 
> On Sat, 28 Jan 2017, David Carlson wrote:
> 
>> I just checked a couple of my installations. My Windows install can save
>> in three database formats as well as XML but my Debian Linux installation
>> only saves in XML format. I cannot find instructions on the GnuCash
>> website to add that capability to Linux installations.
> 
> David,
> 
>  That's interesting. I'm running Slackware here. If GnuCash used psycopg2
> it would work with postgres.
> 
>> I was able to find the caveats about the limited functionality in the FAQ
>> page, but not how to implement it.
> 
>  I didn't look at the FAQ, but grep'd the two manuals looking for
> procedures.
> 
> Thanks,
> 
> Rich
> _______________________________________________
> 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.