Skip site navigation (1) Skip section navigation (2)

Θέμα: Re: possible Bug in windows version ?

From: gpio Oxxce <gp_io_07(at)yahoo(dot)gr>
To: Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Θέμα: Re: possible Bug in windows version ?
Date: 2007-02-14 08:53:20
Message-ID: 20070214085320.74069.qmail@web27908.mail.ukl.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi Paul, All,

My host   pg_hba.conf:
host     all         all         127.0.0.1/32                 md5
host    all         all          192.168.1.1/32          trust
host    all         all          192.168.1.2/32          trust

and postgresql.conf:
listen_addresses = '*'        
port = 5432                
max_connections = 100    

the 192.168.1.1 is also the server IP, and I am tryning to connect from the 192.168.1.2 with pgExlorer and pgAdmin  but I get a message :
"Cannot connect to Server. Connection timeout . Chech if the server is running and accepting TCP connections on 5432"

I will try to setup the database and see if this happens also the binary distribution without  the installer.

Thx
George 


Paul Lambert <paul(dot)lambert(at)autoledgers(dot)com(dot)au> έγραψε: gpio Oxxce wrote:
> Hi all,
> 
> After downloading and installing the latest Postgresql server 
> (postgresql-8.2.3-1.zip 
> )
> I can not make it accept local IP connections!
> I edit the |pg_hba.conf |file with
> 
> host   all all 192.168.100.1/32   trust
> 
> but still I can't connect from 192.168.100.1 to the DB.
> Also during the installation I checked the option "Accept TCP 
> connections.." (or something like that)
> 
> Am I missing something or it is a possible bug ?
> 
> Thanks
> George
> 

In putting in the above line did you replace the host line with address 
"127.0.0.1/32"? If so, that's probably your problem - it needs the 127* 
line. Is postmaster listening on the default port (5432) or did you 
change that during install? (Can check that in the postgresql.conf file 
in the same place as pg_hba.conf)

How are you trying to connect? (pgAdminIII, some other program using the 
ODBC driver?) What error are you getting?

NB: I get access denied if I put my servers IP address into the 
pg_hba.conf file and comment out the existing 127 address line. Local 
connections would not go out through the network and would thus not be 
seen by PG as coming from your 192/168 address.

P.

-- 
Paul Lambert
Database Administrator
AutoLedgers


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings


 		
---------------------------------
 Χρησιμοποιείτε Yahoo!
 Βαρεθήκατε τα ενοχλητικά μηνύ ματα (spam); Το Yahoo! Mail διαθέτει την καλύτερη δυνατή προστασία κατά των ενοχλητικών μηνυμάτων 
 http://login.yahoo.com/config/mail?.intl=gr 
 		
---------------------------------
 Χρησιμοποιείτε Yahoo!
 Βαρεθήκατε τα ενοχλητικά μηνύ ματα (spam); Το Yahoo! Mail διαθέτει την καλύτερη δυνατή προστασία κατά των ενοχλητικών μηνυμάτων 
 http://login.yahoo.com/config/mail?.intl=gr 

In response to

Responses

pgsql-admin by date

Next:From: gayathri jayapalDate: 2007-02-14 09:22:23
Subject: clarififcation
Previous:From: Tom LaneDate: 2007-02-14 08:13:55
Subject: Re: online tape backup

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group