[GNC] gnucash with postgresql 16
Frank Ciani
fciani at gmail.com
Sun Sep 17 12:40:38 EDT 2023
Let me clarify. I had used postgres 14 in the past. Not now. Currently, I
am only using 16 which works on the older gnucash (4.1), but not the later
and most importantly the current version (5.3)
Regards,
Frank
On Sun, Sep 17, 2023, 11:45 AM john <jralls at ceridwen.us> wrote:
> But pgsql-14 works with all three GnuCash versions? That's weird.
>
> Regards,
> John Ralls
>
>
> On Sep 17, 2023, at 08:23, Frank Ciani <fciani at gmail.com> wrote:
>
> Oh, if it was only that easy. Fixing the directory name was the first
> thing I tried. Didn't work.
>
> I used Postges 16 with all three gnucash versions. It only worked with
> 4.1 which had the correct directory name.
>
>
>
> On Sat, Sep 16, 2023, 9:25 PM john <jralls at ceridwen.us> wrote:
>
>> Maybe. What happens if you fix the directory name?
>>
>> You said that you'd been successfully connecting with pgsql14. Was that
>> with an older version of GnuCash too?
>>
>> Regards,
>> John Ralls
>>
>> On Sep 16, 2023, at 13:58, fciani at gmail.com wrote:
>>
>> Thanks for the fast response.
>>
>> I reloaded GNUCash 4.1. I could save and load my file as a Postgres 16
>> sql database. There was a folder created:
>>
>> Version 4.1: "C:\Program Files (x86)\gnucash\lib\postgre*sql*"
>>
>> I noticed in the program folder directory for 5.3 that postgres had a
>> missing āsā (postgreql). I also reloaded GNUCash 4.14. I could NOT save
>> as Postgres db either. It also had the missing āsā.
>>
>> Version 4.14 and 5.3: "C:\Program Files (x86)\gnucash\lib\postgre*ql*"
>>
>> Could this issue be a simple misspelling in the code path somewhere? I
>> think this is a bug?
>>
>> Thanks
>> Frank
>>
>> *From:* john <jralls at ceridwen.us>
>> *Sent:* Saturday, September 16, 2023 2:38 PM
>> *To:* fciani at gmail.com
>> *Cc:* gnucash-user at gnucash.org
>> *Subject:* Re: [GNC] gnucash with postgresql 16
>>
>>
>>
>>
>> On Sep 16, 2023, at 09:10, fciani at gmail.com wrote:
>>
>> Hi
>>
>> I'm running gnucash 5.3 on Windows 11. I also just installed Postgresql
>> 16.
>> I cannot save my file in the postgres format. I get the following error:
>>
>> The server at URL postgres://postgres@localhost/gnucash experienced and
>> error or encountered bad or corrupt data.
>>
>> I have successfully run a previous version of Postgres (14 I think)
>> successfully. Anyone with a clue as to what's wrong?
>>
>>
>> That's a catch-all error dialog, there will be more information in the
>> tracefile (https://www.gnucash.org/wiki/Tracefile) and maybe still more
>> in the Postgres server logs. For still more detail try again, running
>> GnuCash with `--log gnc.backend=debug`. The resulting tracefile will
>> include the text of all queries and responses and may expose your financial
>> data so be careful about sharing it.
>>
>> Regards,
>> John Ralls
>>
>>
>>
>
More information about the gnucash-user
mailing list