[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [GNUe] Postgresql
From: |
James Thompson |
Subject: |
Re: [GNUe] Postgresql |
Date: |
Tue, 6 Apr 2004 08:45:34 -0500 |
User-agent: |
KMail/1.6.1 |
On Tuesday 06 April 2004 05:45 am, Stefan Elwesthal wrote:
> This is probaly not a GNUe error, it's probably me missing a lot of details
> in setting up this monstrous piece of code, but could anyone explain while
> it's totally ok to access through pgsql and not through GNUe?
Because by default postgresql doesn't allow remote connections even after the
-i is passed. You need to alter your pg_hba.conf file to tell postgresql
what type of connections to allow from which locations.
Recent pg_hba.conf files are very clean and give a detailed explanation of the
various options available. However you should be able to add a line like
host all all 172.16.0.0 255.255.0.0 password
To your pb_hba.conf file to get things working. This basically says.
Allow host based access
To all databases
To all users
From any machine with an IP address that starts with 172.16.
Use password based authentication
That last option allows cleartext passwords :( But, IIRC this was required as
the windows clients don't support the encrypted options.
Take Care,
James
--
->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<
James Thompson 138 Cardwell Hall Manhattan, Ks 66506 785-532-0561
Kansas State University Department of Mathematics
->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<