[GNC] Postgress connection string for nonstandard port

[Bob Treumann]

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> wrote:

> Is it possible for you to set the PGPORT environment variable?
>
>
> —
> Peter West
> 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> 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
> “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> 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
> 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 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.
>
>
>