gnucash: Any Gotchas Using Postgres RDBMS?

[John Ralls]

> On Aug 21, 2015, at 3:19 AM, Charles Sliger <chaz at bctonline.com> wrote:
> 
> Does GnuCash seem to play well with Postgres?
> Are any special libraries required?

There’s been a little traffic on this list over the years indicating that a few people are using it, so it would appear that there aren’t any major problems. More feedback would certainly be appreciated.

Note well that we can’t offer much support for administering a Postgresql database, so if you’re not an experienced DBA you’ll need to find other places to help you with that part.

In addition to having a running Postgresql server you’ll need the client libraries and libdbd-pgsql installed along with GnuCash on every system that will access the database.

Note as well that GnuCash does not support multiple simultaneous users in a database because it doesn’t reload data from the DB after the initial load and doesn’t use any of the database’s concurrency features.

Regards,
John Ralls