Setting up gnucash to use postgesql back end - close but no cigar ...

[Wm]

Tue, 10 Mar 2015 08:31:02 
<C158DD85-CCE7-4D14-AE06-6AE421516C65 at ceridwen.us>  John Ralls 
<jralls at ceridwen.us>

>Only XML does the versioned backup, because the whole file must be 
>saved as one piece. SQLite3 is a real SQL database that happens to use 
>a local file instead of a server and therefore requires no admin of the 
>non-existant server. It saves each transaction as it happens and 
>therefore there is no previous file to use as a backup. Consequently 
>SQLite3 users are on their own when it comes to making backups. This is 
>a non-problem on MacOS X as long as TimeMachine is enabled, but on 
>other platforms it's up to the user to arrange for backups.
>
>Hinnerk, those pre-configured database servers on Linux are there 
>because someone with the requisite experience did the setup and 
>packaged it for the NAS provider. There are similar installations used 
>for various Linux services. All of the cases that I'm aware of are 
>nicely self-contained and not especially critical for the casual user. 
>I can't think of any that wouldn't have been better done with SQLite3 
>since there's no need for multiple users nor does the service generally 
>span machines, but that's a separate issue. Yes, it's possible on Linux 
>to tell the package manager to install MySQL or PostgresQL; one or the 
>other might already be installed for some other purpose. Those 
>installations make no allowances for setting up users, granting the 
>requisite permissions, arranging for logging and backups, etc. One has 
>the choice of either learning to do all of that stuff oneself or hiring 
>someone to do it, and those with the requisite skills are not cheap. 
>One can always hire so!
> meone without the requisite skills for substantially less money, but 
>that carries rather more risk than I'd be willing to advocate to the 
>general population.

I'd use XML for reliability and SQLite3 to play with.

OK, sometimes I want to do outre sql stuff and use postgres, so what? 
I'm an adult, if I screw up it is my fault.  If I kill half a planet 
using SQL it is all *mysql* fault.

Yeah, well, I got bored too

-- 
Wm...