But pgsql-14 works with all three GnuCash versions? That's weird. Regards, John Ralls
> On Sep 17, 2023, at 08:23, Frank Ciani <fci...@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 <jra...@ceridwen.us > <mailto:jra...@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, fci...@gmail.com <mailto:fci...@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 <jra...@ceridwen.us <mailto:jra...@ceridwen.us>> >>> Sent: Saturday, September 16, 2023 2:38 PM >>> To: fci...@gmail.com <mailto:fci...@gmail.com> >>> Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> >>> Subject: Re: [GNC] gnucash with postgresql 16 >>> >>> >>> >>> >>>> On Sep 16, 2023, at 09:10, fci...@gmail.com <mailto:fci...@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 >> _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
