Re: [GNC] Postgress connection string for nonstandard port

2023-02-26 Thread Geert Janssens
Op donderdag 23 februari 2023 22:00:12 CET schreef 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

Re: [GNC] Postgress connection string for nonstandard port

2023-02-26 Thread Geert Janssens
The attached image only shows the connection parameters as entered by the OP. It doesn't indicate any errors in itself. But to be sure I have just verified this myself. I created a postgresql server listening on a non-standard port, and used the method I described below to successfully save a

Re: [GNC] Postgress connection string for nonstandard port

2023-02-23 Thread 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

Re: [GNC] Postgress connection string for nonstandard port

2023-02-23 Thread Peter West
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 wrote: > > From what I read in the code you should be able to pass a custom port by >

Re: [GNC] Postgress connection string for nonstandard port

2023-02-23 Thread 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 >

Re: [GNC] Postgress connection string for nonstandard port

2023-02-22 Thread 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 wrote: >

Re: [GNC] Postgress connection string for nonstandard port

2023-02-22 Thread 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 wrote: > Is it possible for you to set the PGPORT environment variable? > > > — > Peter West >

Re: [GNC] Postgress connection string for nonstandard port

2023-02-21 Thread Peter West
Is it possible for you to set the PGPORT environment variable? — Peter West 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 wrote: > > I’m using the default port, so I can’t help there. > > “Database” refers to the

Re: [GNC] Postgress connection string for nonstandard port

2023-02-21 Thread Peter West
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 “Blessed are the pure in heart, for they shall see God.” > On 22 Feb 2023, at 8:07 am, Bob Treumann wrote: > > I am running PG on an amazon server on a non

[GNC] Postgress connection string for nonstandard port

2023-02-21 Thread Bob Treumann
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