pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Paul Lambert <paul.lambert@autoledgers.com.au>
To: gpio Oxxce <gp_io_07@yahoo.gr>
Cc: pgsql-admin@postgresql.org
Subject: Re: possible Bug in windows version ?
Date: Wed, 14 Feb 2007 07:04:29 +0900
Message-ID: <45D235ED.6020904@autoledgers.com.au> (raw)
In-Reply-To: <20070213171928.72969.qmail@web27908.mail.ukl.yahoo.com>
References: <20070213171928.72969.qmail@web27908.mail.ukl.yahoo.com>

gpio Oxxce wrote:
> Hi all,
> 
> After downloading and installing the latest Postgresql server 
> (postgresql-8.2.3-1.zip 
> <http://wwwmaster.postgresql.org/download/mirrors-ftp?file=binary%2Fv8.2.3%2Fwin32%2Fpostgresql-8.2.3...;)
> 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




view thread (3+ messages)  latest in thread

Message-ID: <45D235ED.6020904@autoledgers.com.au>
Permalink:  ../45D235ED.6020904@autoledgers.com.au/
Also on:    postgresql.org/message-id/45D235ED.6020904@autoledgers.com.au

 · 

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: paul.lambert@autoledgers.com.au, gp_io_07@yahoo.gr
  Subject: Re: possible Bug in windows version ?
  In-Reply-To: <45D235ED.6020904@autoledgers.com.au>

* 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