Installing GNU Cash with PostGreSQL

[Phil Longstaff]

There is a bug with 2.3.2 which will crash in "Save As" if you do not have the sqlite3 dbd driver.  If you are running on winxp, I am surprised, because 2.3.2 is supposed to include that.  Can you send your gnucash.trace file (look in C:\Documents and Settings\<your username>\Local Settings\Temp for a file named gnucash.trace.XXXXXX where XXXXXX is some 6 character code).

Phil



________________________________
From: Brian Amos <bamos1 at gmail.com>
To: gnucash-devel at gnucash.org; plongstaff at rogers.com
Sent: Tuesday, July 14, 2009 2:26:17 PM
Subject: Re: Installing GNU Cash with PostGreSQL

I have PostgreSQL configured on a linux server.  when I do the save as dialog in gnucash on winXP pro to save on that server gnucash crashes.  Is this error related to https://lists.gnucash.org/pipermail/gnucash-devel/2009-July/025821.html?

using gnucash on winXPpro tablet edition.
postgres 8.2.5 on slackware 10.

Brian



On Tue, Jul 14, 2009 at 6:18 AM, Anders Johansson <anders_skane at yahoo.com> wrote:

Thanks for the instructions.  I was able to get to the dialog to save as a PostGreSQL database file.  Now I have to get PostGreSQL configured so I can use it.
>>
> 
>>Regards,
>>Anders
>
>>--- On Thu, 7/9/09, Phil Longstaff <plongstaff at rogers.com> wrote:
>
>
>>From: Phil Longstaff <plongstaff at rogers.com>
>>Subject: Re: Installing GNU Cash with PostGreSQL
>>To: gnucash-devel at gnucash.org
>>Cc: "Anders Johansson" <anders_skane at yahoo.com>, gnucash-devel at lists.gnucash.org
>>Date: Thursday, July 9, 2009, 9:04 PM
>
>
>
>>#yiv1025127545 p, #yiv1025127545 li {white-space:pre-wrap;}
>>On July 9, 2009 08:24:57 pm Anders Johansson wrote:
>>> How do I install GNU Cash to use PostGreSQL as the backend?  I am running
>>> Win XP Pro, service pack 3.  I currently have GNU Cash 2.2.9 and willing to
>>> experiment with 2.3.2, but would like to try it using the PostGreSQL
>>> backend.
>>>
>>> Thanks,
>>> Anders
>
>
>>The 2.3.2 win32 setup .exe is on sourceforge. Download it and install it. It should contain everything required to access a postgresql db.
>
>
>>The File -> Open and Save As menu entries are changed. In the past, they were simple file dialog boxes. Now, they are new dialog boxes. In the top left corner is a combo box indicating what type of file or connection to use. For Open, default is "file", other entries are "mysql" or "pgsql". For Save As, default is "sqlite3", other entries are "xml", "mysql" or "pgsql". If the setting is "file", "sqlite3" or "xml", the top right portion of the dialog will be disabled and the bottom section will be enabled. This section is a standard file access dialog. If the setting is "mysql" or "pgsql", the bottom section is disabled and the top right section is enabled. This section contains 4 text entry fields where you can enter hostname, db name, username and password.
>
>
>>Once you have your postgresql server setup, start gnucash. Open your existing gnucash file. Use Save As, switch to "pgsql", then enter hostname, dbname, username and password. The username must be for a user with authorization to create a database if it doesn't already exist.
>
>
>>With postgresql, you might get a popup dialog telling you that the db has contents which will be overwritten, even though this is a newly created db. This is a bug. Just press OK.
>
>
>>Good luck. After this, there should be very little difference, other than the fact that all changes (e.g. new transactions) are saved automatically, so you do not need to save on exit.
>
>
>>Phil
>
>
>
>>_______________________________________________
>>gnucash-devel mailing list
>gnucash-devel at gnucash.org
>https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>