[GNC] gnucash with postgresql 16

[john]

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 <mailto: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 <mailto: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\postgresql"
>>>  
>>> 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\postgreql"
>>>  
>>> 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 <mailto:jralls at ceridwen.us>> 
>>> Sent: Saturday, September 16, 2023 2:38 PM
>>> To: fciani at gmail.com <mailto:fciani at gmail.com>
>>> Cc: gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>
>>> Subject: Re: [GNC] gnucash with postgresql 16
>>>  
>>>  
>>> 
>>> 
>>>> On Sep 16, 2023, at 09:10, fciani at gmail.com <mailto: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
>>