[GNC] Postgress connection string for nonstandard port

[Bob Treumann]

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 <pbw at pbw.id.au> wrote:

> The OP said that that was not working (see his attached image.)
>
>
> —
> Peter West
> pbw at 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.gnucash at 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
> > pbw at 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 <bobtreu at 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 <pbw at pbw.id.au
> > > <mailto:pbw at pbw.id.au <pbw at pbw.id.au>>> wrote: Is it possible for you
> to set the PGPORT
> > > environment variable?
> > >
> > >
> > > —
> > > Peter West
> > > pbw at pbw.id.au <mailto:pbw at pbw.id.au <pbw at 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 <pbw at pbw.id.au
> > >> <mailto:pbw at pbw.id.au <pbw at 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
> > >> pbw at pbw.id.au <mailto:pbw at pbw.id.au <pbw at pbw.id.au>>
> > >> “Blessed are the pure in heart, for they shall see God.”
> > >>
> > >>> On 22 Feb 2023, at 8:07 am, Bob Treumann <bobtreu at gmail.com
> > >>> <mailto:bobtreu at gmail.com <bobtreu at 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 at gnucash.org <mailto:gnucash-user at gnucash.org
> <gnucash-user at 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 at gnucash.org <mailto:gnucash-user at gnucash.org
> <gnucash-user at 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 at 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.
>
>
>
>