Connecting to a postgresql Database on the Local machine

Vincent Ngundi vincent at kenic.or.ke
Thu Mar 24 01:46:21 EST 2005


Thanks Matthew, I'll try that out...

Vincent.


On Thu, 2005-03-24 at 03:44, Matthew Vanecek wrote:
> <quote who="Josh Sled">
> > On Wed, 2005-03-16 at 09:32, Vincent Ngundi wrote:
> >
> >> Just wanted to ask, has anyone ever successfully used GnuCash with a
> >> PostgreSQL database in Linux(I'm using Redhat 9).
> >
> > I would venture to guess a very small number of people.
> >
> >
> >> I keep getting the following error when I try to save as either:
> >>
> >> postgres://localhost/template1?user="username"
> >> postgres://localhost/template1"
> >
> > That sounds like a funny name for a gnucash database...
> >
> > How did you create 'template1'?
> >
> > What is in the table 'gncVersion'?
> >
> >
> >
> >> Please help me out!
> >
> > The postgres backend isn't really supported.  Specifically, none of the
> > active devs use it, it doesn't support all the features of GnuCash
> > [scheduled transactions and business objects especially], and we intend
> > to replace it.
> >
> > The best help you're going to get is from yourself and the sources.
> >
> > ...jsled
> >
> 
> Don't use template1--that's the default database Postgresql creates.  Use
> the name of a database that does not exist, and let Gnucash create the
> database internally.  Connecting to an existing empty database (i.e., a
> database that does not contain any Gnucash tables) is not supported and
> will generate that (somewhat deceptive) error.
> 
> The Postgresql backend is not under active development.  E.g., it does not
> support scheduled transactions or any of the business functionality.
> 
> ciao,



More information about the gnucash-user mailing list