Installing GNU Cash with PostGreSQL

[Brian Amos]

attached is the trace file.
Brian

On Tue, Jul 14, 2009 at 11:34 AM, Phil Longstaff <plongstaff at rogers.com>wrote:

> 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
>>
>
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: gnucash.trace.8NLMWU
Type: application/octet-stream
Size: 205 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-devel/attachments/20090714/0a780f23/attachment.obj>