Installing GNU Cash with PostGreSQL

[Brian Amos]

i figured out the logging configuration. here is a more substantial file.
Brian

On Tue, Jul 14, 2009 at 11:58 AM, Brian Amos <bamos1 at gmail.com> wrote:

> 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.GR4XWU
Type: application/octet-stream
Size: 166692 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-devel/attachments/20090714/32cd196d/attachment-0001.obj>