OS 5.2 Logon to Postgresql

[Andy Hilton]

Mats

Bas and Alain are right - it will be what you are putting in your edited files that will be the problem - can you post what you are changing your conf files to ? Then I am sure we could advise better....also tell us what the ip address range of the network is....

If this is a new install, then it is more than likely just the pg_hba.conf that needs editing in order to get access sorted out as the recent releases all have the postgres.conf set for listen = '*', or to listen to everything by default if I recall correctly....

Andy

On May 15, 2012, at 2:15 AM, ADJob wrote:

> Hi,
> 
> I cannot logon other than localhost:
> 
> It is OK to logon to localhost:
> ---------------------------------------------------------------------------
> Do pgsql.$database.$assign('postgres') Returns #F
> Do pgsql.$port.$assign(5432) Returns #F
> Do pgsql.$logon(127.0.0.1;'postgres';'postgres';'PGSQL') Returns #F
> 
> 
> But logon with other ip address = "no connect"
> ---------------------------------------------------------------------------
> Do pgsql.$database.$assign('postgres') Returns #F
> Do pgsql.$port.$assign(5432) Returns #F
> Do pgsql.$logon('192.168.10.5';'postgres';'postgres';'PGSQL') Returns #F
> 
> 
> All ports are wide open (port scan ok) and both configuration are
> "out-of-the-box". 
> 
> I have tried to edit "pg_hba.conf" and "postgresql.conf". But once edited,
> the service stops running. Does not matter if it is Mac or PC.
> 
> What am I doing wrong? Any clue?
> 
> TIA!
> 
> Mats Olsson, ADJob Nordic AB, Sweden
> 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com