gnucash: Any Gotchas Using Postgres RDBMS?

[Geert Janssens]

On Friday 21 August 2015 07:54:09 Dandridge, Charles wrote:
> Does this hold true for mysql as well?
> 
Yes.

GnuCash will assume it controls the complete DB. Mysql doesn't have a 
concept of schemas as far as I know, but other than that the behaviour 
is the same.

Geert

> On 8/21/2015 5:39 AM, Geert Janssens wrote:
> > On Friday 21 August 2015 09:56:38 John Ralls wrote:
> > >> 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
> > 
> > One more gotcha: gnucash doesn't support Postgresql's schema. The
> > gnucash db will always be created in the default (public) schema and
> > any other schemas still in the db will be destroyed. In other
> > words, gnucash claims the full db to itself. Don't attempt to add
> > additional schemas or tables in the same database.
> > 
> > This complete overwrite happens whenever you do a "save as" to the
> > postgresql database or whenever there's a change in the table
> > structures used by gnucash (which can happen at every gnucash
> > update).
> > 
> > Regards,
> > 
> > Geert
> > 
> > _______________________________________________
> > 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.