<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><br></div><div>Hi Fernando,</div><div><br></div><div>I just read that you are actually running your accounts on psql. </div><div>After some trials I actually came to the conclusion that the whole database connectivity issue was fake:</div><div>- There is no problem in saving data into a database (both with mysql and postgresql).</div><div>- However, when trying to load data from the database, kmymoney either crashes or hangs, with one notable exception:</div><div>- If I save a virgin kmymoney-file (with only my name and one account created), then I actually can load these data from the database.</div><div>- This is not of much use either, as kmymoney then crashes as soon as I try to open a ledger.</div><div>So here are my questions: </div><div>Which version of postgresql do you use: 9.1, 9.0, 8.4 or even some older one?</div><div>Which operating system do you use (so far I tried it on a mac via macports)?</div><div>Do you have to make adjustments of the database?</div><div><br></div><div>Best wishes,</div><div>Stefan</div><div><br></div><div><br></div><br><div><div>Am 26.07.2011 um 12:00 schrieb <a href="mailto:kmymoney-request@kde.org">kmymoney-request@kde.org</a>:</div><br class="Apple-interchange-newline"><blockquote type="cite">Send KMyMoney mailing list submissions to<br><span class="Apple-tab-span" style="white-space:pre"> </span><a href="mailto:kmymoney@kde.org">kmymoney@kde.org</a><br><br>To subscribe or unsubscribe via the World Wide Web, visit<br><span class="Apple-tab-span" style="white-space:pre"> </span>https://mail.kde.org/mailman/listinfo/kmymoney<br>or, via email, send a message with subject or body 'help' to<br><span class="Apple-tab-span" style="white-space:pre"> </span>kmymoney-request@kde.org<br><br>You can reach the person managing the list at<br><span class="Apple-tab-span" style="white-space:pre"> </span>kmymoney-owner@kde.org<br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of KMyMoney digest..."<br>Today's Topics:<br><br> 1. Re: Using postgresql with KMyMoney (Fernando Vilas)<br><br><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;"><span style="font-family:'Helvetica'; font-size:medium; color:rgba(127, 127, 127, 1.0);"><b>Von: </b></span><span style="font-family:'Helvetica'; font-size:medium;">Fernando Vilas <fvilas@iname.com><br></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;"><span style="font-family:'Helvetica'; font-size:medium; color:rgba(127, 127, 127, 1.0);"><b>Datum: </b></span><span style="font-family:'Helvetica'; font-size:medium;">26. Juli 2011 04:15:33 MESZ<br></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;"><span style="font-family:'Helvetica'; font-size:medium; color:rgba(127, 127, 127, 1.0);"><b>An: </b></span><span style="font-family:'Helvetica'; font-size:medium;">KMyMoney Users' mailing list <kmymoney@kde.org><br></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;"><span style="font-family:'Helvetica'; font-size:medium; color:rgba(127, 127, 127, 1.0);"><b>Betreff: </b></span><span style="font-family:'Helvetica'; font-size:medium;"><b>[Kmymoney] Re: Using postgresql with KMyMoney</b><br></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px;"><span style="font-family:'Helvetica'; font-size:medium; color:rgba(127, 127, 127, 1.0);"><b>Antwort an: </b></span><span style="font-family:'Helvetica'; font-size:medium;">KMyMoney Users' mailing list <kmymoney@kde.org><br></span></div><br><br>On Saturday, July 16, 2011 19:10:35 Sara wrote:<br><blockquote type="cite">Hi,<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> Does anyone have any experience in getting Kmymoney to save as a postgresql<br></blockquote><blockquote type="cite">database?<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> The option to save as postgresql is not shown in the Database Type listbox<br></blockquote><blockquote type="cite">under the File -> Save as database... menu. I am using KMyMoney version<br></blockquote><blockquote type="cite">4.5.3 and have libqsqlpsql.so installed in /usr/lib/qt/plugins/sqldrivers.<br></blockquote><blockquote type="cite">Postgresql is also installed in my system.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"> On another note, only the SQLite Version 3 works (MySQL and Open Database<br></blockquote><blockquote type="cite">Connectivity does not).<br></blockquote><blockquote type="cite"><br></blockquote><br>Sara,<br><br><span class="Apple-tab-span" style="white-space:pre"> </span>I run my accounts on a PostgreSQL server without any trouble. If you are <br>on a 64 bit system, the driver may need to be in <br>/usr/lib64/qt/plugins/sqldrivers. The list of drivers on the menu is obtained <br>by asking Qt what drivers are available, so for some reason it is not finding <br>it.<br><br><span class="Apple-tab-span" style="white-space:pre"> </span>We also have people who use MySQL. I test the code against it sometimes, <br>but I do not use it for KMM regularly. However, I do not know if anyone has <br>tested ODBC at all.<br><br><span class="Apple-tab-span" style="white-space:pre"> </span>Sorry for the delay in the response. I was on vacation for a couple of <br>weeks.<br><br>-- <br>Thanks,<br>Fernando Vilas<br>fvilas@iname.com<br><br><br>_______________________________________________<br>KMyMoney mailing list<br>KMyMoney@kde.org<br>https://mail.kde.org/mailman/listinfo/kmymoney<br></blockquote></div><br></body></html>