[GNC] Postgress connection string for nonstandard port

[Geert Janssens]

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>> 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>
> > “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>> 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>
> >> “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>> 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.
> >>> 
> >>>