From: | "Gregory S(dot) Williamson" <gsw(at)globexplorer(dot)com> |
---|---|
To: | "Paul Harrison" <pharrison(at)fame(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Host configuration |
Date: | 2003-08-16 09:21:04 |
Message-ID: | 71E37EF6B7DCC1499CEA0316A256832801057095@loki.globexplorer.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I had a similar problem recently and in the end it seems to have been me not restarting the postmaster; changes to the pg_hba.conf file weren't seen until then (I am sure this is documented but I managed to overlook it; Informix' sqlhosts file is read at connection time so changes are immediate - I was conditioned by this, I think). This was on a linux box running postgres and a Windows app (pgadmin) trying to connect.
If this is not the case please forgive my banal suggestion ...
Greg Williamson
DBA GlobeXplorer LLC
-----Original Message-----
From: Paul Harrison [mailto:pharrison(at)fame(dot)com]
Sent: Fri 8/15/2003 8:54 AM
To: pgsql-admin(at)postgresql(dot)org
Cc:
Subject: [ADMIN] Host configuration
I am running postgress 7.2 on a solaris system and trying to connect from a
windows 2000 based laptop to a database on the solaris system using an
interactive sql program (from McKoi in fact).
I have altered the pg_hba.conf file by appending a line to said file:
TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE AUTH_ARGUMENT
host all 196.45.23.27 255.255.0.0 trust
This should let all other hosts connect to any database.
The server was started with the -i option to allow TCP/IP connections.
The logging from the server indicated a connection attempt was made but the
error message was along the lines of - "No pg_hba.conf entry for host
196.45.23.27, user fdm, database mmpoint."
A similar problem was found if an attempt was made to connect from another
UNIX system but the connection was successful when a connection was
attempeted on the local machine.
I searched for any other instance of pg_hba.conf on the UNIX box, in case it
was picking up a different one but there was just the single instance.
My connection string from my laptop was 'java -classpath
"famejdbc.jar;pgjdbc2.jar" com.datagenic.fusion.isql org.postgresql.Driver
jdbc:postgresql://mambar.fame.com/mmpoint fdm fdm2'
Does anyone have an idea of what I need to do?
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
From | Date | Subject | |
---|---|---|---|
Next Message | Harald Fuchs | 2003-08-16 12:47:45 | Re: Time event |
Previous Message | bognár, attila | 2003-08-16 08:46:07 | limit number of connections per database |