Thanks for all the feedback. I will share my learnings; The database must be created before you connect to it. The install process creates all the tables in the Public schema in that database once it connects successfully.
Geert Janssens referenced the code where he could tell that the appended port should work. Geert, can you tell me where to find that? I would like to see if I can modify it to connect to my chosen database and schema rather than using the public schema in a dedicated database. I mentioned in another post that Postgress creates multiple schemas in a single database. That is my preferred way of operating because I can read and write to other schemas without connecting across databases. I'm not even sure if PG supports cross database connections. Thanks for everyones help! On Thu, Feb 23, 2023 at 2:36 AM Peter West <p...@pbw.id.au> wrote: > The OP said that that was not working (see his attached image.) > > > — > Peter West > p...@pbw.id.au > “Blessed are the peacemakers, for they shall be called sons of God.” > > On 23 Feb 2023, at 6:30 pm, Geert Janssens <geert.gnuc...@kobaltwit.be> > wrote: > > From what I read in the code you should be able to pass a custom port by > adding it in the hostname field, like so: > > yourserver.xyz:6543 > > Regards, > > Geert > > Op donderdag 23 februari 2023 07:26:09 CET schreef Peter West: > > Are you on Windows, Mac or linux? How do you invoke GnuCash? There will > be > > some sort of environment in which the invocation occurs from your end. > > > > — > > Peter West > > p...@pbw.id.au > > “Blessed are the peacemakers, for they shall be called sons of God.” > > > > > On 23 Feb 2023, at 2:13 am, Bob Treumann <bobt...@gmail.com> wrote: > > > > > > > > > > > > I could set it since I control the server, but I don't know where I > would > > > set it so that it would take effect before the connection attempt is > > > made. > > > > > > On Tue, Feb 21, 2023 at 10:53 PM Peter West <p...@pbw.id.au > > > <mailto:p...@pbw.id.au <p...@pbw.id.au>>> wrote: Is it possible for you > to set the PGPORT > > > environment variable? > > > > > > > > > — > > > Peter West > > > p...@pbw.id.au <mailto:p...@pbw.id.au <p...@pbw.id.au>> > > > “Blessed are the peacemakers, for they shall be called sons of God.” > > > > > >> On 22 Feb 2023, at 11:01 am, Peter West <p...@pbw.id.au > > >> <mailto:p...@pbw.id.au <p...@pbw.id.au>>> wrote: > > >> > > >> I’m using the default port, so I can’t help there. > > >> > > >> “Database” refers to the database, in my case, gnucash. > > >> > > >> > > >> — > > >> Peter West > > >> p...@pbw.id.au <mailto:p...@pbw.id.au <p...@pbw.id.au>> > > >> “Blessed are the pure in heart, for they shall see God.” > > >> > > >>> On 22 Feb 2023, at 8:07 am, Bob Treumann <bobt...@gmail.com > > >>> <mailto:bobt...@gmail.com <bobt...@gmail.com>>> wrote: > > >>> > > >>> I am running PG on an amazon server on a non standard port (6543). > > >>> > > >>> The connection setup on gnucash does not have a filed to input the > port. > > >>> I added the port to the end of the hostname, a style that has worked > > >>> with > > >>> other applications. > > >>> > > >>> There is a field to enter the "database", which in PG contains > multiple > > >>> schemas. > > >>> The user is typically connected to a schema by a default path. > > >>> > > >>> My questions are: > > >>> How do I define the port? > > >>> Does "Database" refer to "Schema"? > > >>> > > >>> I would try every combination but the interface only gives me one > > >>> chance. > > >>> It gives a "cannot connect" message then closes. > > >>> > > >>> > > >>> [image: image.png] > > >>> <image.png>_______________________________________________ > > >>> gnucash-user mailing list > > >>> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org > <gnucash-user@gnucash.org>> > > >>> To update your subscription preferences or to unsubscribe: > > >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user > > >>> <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. > > >> > > >> _______________________________________________ > > >> gnucash-user mailing list > > >> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org > <gnucash-user@gnucash.org>> > > >> To update your subscription preferences or to unsubscribe: > > >> https://lists.gnucash.org/mailman/listinfo/gnucash-user > > >> <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. > > > > _______________________________________________ > > 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. > > > > _______________________________________________ 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.
