[GNC] Postgress connection string for nonstandard port

[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.
>>> 
>>> 
>>> [image: image.png]
>>> <image.png>_______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at gnucash.org <mailto: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>
>> 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.
>