Setting up PostgreSQL back end?

[Klaus Dahlke]

On Thu, 12 Sep 2002 05:26:03 -0400
"Michael D. Crawford" <crawford@goingware.com> wrote:


> 
> But I don't see any instructions in the User's Guide for configuring
> GnuCash to use PostgreSQL.  Are there instructions online anywhere?
> 
> I've used PostgreSQL as well as MySQL some, so I'm a little familiar
> with SQL databases in general.
> 

Michael,

I can't remember in detail how I managed to get gnucash running with
postgres.

First have a look at the documentation in the source package:
src/engine/sql/README
it explains quite well how to use the postgres backend. And, if I am
right, if postgres is running you only need to do a SAVE AS:
postgres://localhost/dbname?mode=single-update

For me it works fine beside that deletion of an transaction doesn't
work. I can delete a transaction, it disappears from both accounts. But
after saving and quitting gnucash and starting gnucash again, the
transaction is there again. For me the only things that help is to
delete a few entries in the database tables. Workaround would be to
change the value of the transaction to 0. Update works, but deletion not.

Cheers,
Klaus