Re: [GNUe] Postgresql

[James Thompson]

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
->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<