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