OS 10.1 27575 connecting to Postrgesql 13

[Andy Hilton]

Graeme

Thank you for sending me your files (offline)

In your postgresql.conf file, you have a line :

#listen_addresses = 'localhost'		# what IP address(es) to listen on;

This - if uncommented - would restrict access to localhost address only, I’m not sure what the effect is with no line to replace it, but I suspect it is to leave it restricted to localhost access only (which you other apps are probably connecting as)

So if you change that line and substitute :

listen_addresses = ‘*'		# what IP address(es) to listen on;

(remove the hash comment at the start and change ‘localhost’ to ‘*’  in other words listen to any address)

Then restart Postgres and it should work - I don’t think there is any other thing wrong here !

Kind regards

Andy Hilton
Totally Brilliant Software Inc
Phone (US) : (863) 409 4870 
Phone (UK) : 0207 193 8582
Web : www.totallybrilliant.com <http://www.totallybrilliant.com/> 
Helpdesk : http://totallybrilliant.kayako.com
Email : andyh at totallybrilliant.com

> On Oct 24, 2021, at 11:40 PM, Andy Hilton <andyh at totallybrilliant.com> wrote:
> 
> Graeme
> 
> For the sake of trying to help you further, can you always add to your responses *what* those changes ended up being, i.e. you mention ’the wording on the error message’ - if you can actually add exactly what that error message says now, it may help us to continue offering suggestions :)
> 
> I do believe (as Bas also said) that we are heading on the right track, so clearly its pretty critical to know exactly what messages you are getting !
> 
> Can you confirm that your ‘other’ apps (pgadmin, Valentina etc) actually can connect to the pg 13 instance ok ? It actually wasn’t fully clear to me that they can connect to pg 13 - only that they can connect (which may be to the earlier pg instances)
> 
> As a matter of interest, are you still running those earlier pg instances ? If so, are the different pg instances all set to operate on different ports ? I know I may be asking the obvious but always best to make sure we are not overlooking a rookie issue :)
> 
> Also can you post your pg_hba.conf file and your postgres.conf file (the ones for pg 13) - just so we have the full picture ?
> 
> And finally, post the lines showing your login setup initiating pg within your app……
> 
> Then I am sure the light will get clearer !!
> 
> Kind regards
> 
> 
> 
> Andy Hilton
> Totally Brilliant Software Inc
> Phone (US) : (863) 409 4870 
> Phone (UK) : 0207 193 8582
> Web : www.totallybrilliant.com <http://www.totallybrilliant.com/> 
> Helpdesk : http://totallybrilliant.kayako.com
> Email : andyh at totallybrilliant.com
> 
>> On Oct 24, 2021, at 7:22 PM, Graeme Harris <gfhwalkabout at fastmail.fm> wrote:
>> 
>> Thank you Andy and Doug,
>> 
>> I tried both your suggestion with no success. Andy switch hostname to IP address just changed the wording on the error message to the IP Address.
>> 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com