From: | "Nick Fankhauser" <nickf(at)ontko(dot)com> |
---|---|
To: | "Gregory S(dot) Williamson" <gsw(at)globexplorer(dot)com>, "Paul Harrison" <pharrison(at)fame(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Host configuration |
Date: | 2003-08-16 17:31:25 |
Message-ID: | NEBBLAAHGLEEPCGOBHDGMEDKIAAA.nickf@ontko.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
In addition to making sure you do a reload to pick up the new values, make
sure that the pg_hba.conf file you are editing is in fact the one being read
by the postmaster. There have been a few situations where a symbolic link
pointing from the data directory to a conf file living somewhere else gets
lost or some other oddity in the way Postgres is set up on a machine causes
confusion.
It looks like you've made the correct entry in the pg_hba file, so I'd look
in the direction of a reason for the file not being read. (I remember a
situation where the postgresql.conf file wasn't available & we learned that
postmaster doesn't complain if it is missing- I suppose this might be the
case with pg_hba as well, but I've never tested it.)
-Nick
> -----Original Message-----
> From: pgsql-admin-owner(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Gregory S.
> Williamson
> Sent: Saturday, August 16, 2003 4:21 AM
> To: Paul Harrison; pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] Host configuration
>
>
> 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
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
From | Date | Subject | |
---|---|---|---|
Next Message | Deepak Malhotra | 2003-08-16 20:55:08 | Hello Testing |
Previous Message | Harald Fuchs | 2003-08-16 12:47:45 | Re: Time event |