pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
To: gpio Oxxce <gp_io_07@yahoo.gr>
Cc: pgsql-admin@postgresql.org
Subject: Re: ÈÝìá: Re: [ADMIN] possible Bug in windows version ?
Date: Wed, 14 Feb 2007 10:56:57 +0000
Message-ID: <45D2EAF9.4050301@mailnetwork.co.uk> (raw)
In-Reply-To: <20070214085320.74069.qmail@web27908.mail.ukl.yahoo.com>
References: <20070214085320.74069.qmail@web27908.mail.ukl.yahoo.com>

If you're running one of Windows XP SP2 or Windows Server 2003, the 
Windows Firewall will be blocking the connection.
If you have the "Windows Firewall" option in Control Panel, check it's 
disabled, then try again.

If that cures your problem, add an exception in for port 5432 before you 
turn the firewall back on.

Andy.


gpio Oxxce wrote:
> 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.lambert@autoledgers.com.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 
> !DSPAM:37,45d2ce7b18511494436004! 


-- 
Andy Shellam
NetServe Support Team

the Mail Network
"an alternative in a standardised world"

p: +44 (0) 121 288 0832/0839
m: +44 (0) 7818 000834

Message-ID: <45D2EAF9.4050301@mailnetwork.co.uk>
Permalink:  ../45D2EAF9.4050301@mailnetwork.co.uk/
Also on:    postgresql.org/message-id/45D2EAF9.4050301@mailnetwork.co.uk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: andy.shellam-lists@mailnetwork.co.uk, gp_io_07@yahoo.gr
  Subject: Re: ÈÝìá: Re: [ADMIN] possible Bug in windows version ?
  In-Reply-To: <45D2EAF9.4050301@mailnetwork.co.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox