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 <jra...@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 <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> 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.
