Setup GnuCash Postgresql

[Matthew Vanecek]

Please CC or send all replies to the gnucash-users list.

The missing README is a result of someone at RedHat botching the package
job.  If you use the RPMs from www.gnucash.org, then you will get the
readme.  Or, you could download the source tarball and get it from
there.  It hasn't changed much.  From the root source directory
(gnucash-1.8.x), it's in src/backend/postgres/README.  It's in CVS at
http://www.gnucash.org/lxr/gnucash/source/src/backend/postgres/README
You probably want to save that locally as README.postgress or
something.  It's a bit dated, but mostly should still be valid.  The
most important point to remember is, don't create your gnucash database
in advance--let gnucash create the database.

On Mon, 2003-09-01 at 09:28, HerSam wrote:
> Thank for Reply, Matthew
> I could not find the readme file, 
> I have double check with the installation, and botg gnucash and gnucash-backend-postgres are installed.
> I can find lib related -postgres in gnucash library,
> 
> Could I set-up the configuration manualy.
> 
> Rgds
> HerSam
> 
> Matthew Vanecek <mevanecek at yahoo.com> wrote ..
> > Presumably you also installed the gnucash-backend-postgres RPM, which
> > holds the Postgreql interface.  There is also a README in
> > /usr/share/doc/gnucash-backend-postgres after you install the RPM that
> > describes the process.  It's somewhat old but still relevant.
> > 
> > Be sure not to create the database--let Gnucash create the database. 
> > Basic syntax in the save dialog is
> > "postgres://host/dbname?user=user&password=pass&mode=single-update"
> > 
> > HTH
> > 
> > On Fri, 2003-08-29 at 08:42, HerSam wrote:
> > > Hi All,
> > > I am realy new user of GnuCash.
> > > Is any one can inform me to setup Gnucash link with Postgresql.
> > > I run RH9, with GnuCash (ver 1.8.1) and Gnucash-Backend-Postgres installed,
> > > and I have setup my Postgresql and it running (Postgres 7.3).
> > > 
> > > But when i running GnuCash, it just configured for store data in local
> > file
> > > not in Postgresql database.
> > > 
> > > I could not find any setup option in GnuCash to set any connection to
> > Postgresql.
> > > 
> > > Thanks for Help.
> > > 
> > > Rgds
> > > HerSam
> > > 
> > > ______________________________________________________________________
> > > _______________________________________________
> > > gnucash-user mailing list
> > > gnucash-user at lists.gnucash.org
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -- 
> > Matthew Vanecek
> > perl -e 'print $i=pack(c5,(41*2),sqrt(7056),(unpack(c,H)-2),oct(115),10);'
> > ********************************************************************************
> > For 93 million miles, there is nothing between the sun and my shadow except
> > me.
> > I'm always getting in the way of something...
-- 
Matthew Vanecek
perl -e 'print $i=pack(c5,(41*2),sqrt(7056),(unpack(c,H)-2),oct(115),10);'
********************************************************************************
For 93 million miles, there is nothing between the sun and my shadow except me.
I'm always getting in the way of something...