On Wed, Mar 08, 2006 at 03:03:22PM -0500, Louis Gonzales wrote:
> Two things come to mind:
> 1) do you have a defined postgresql user "joe" ?
> 2) 192.168.1.11/32 (without looking it up, I'm not sure if you can
> specify the subnetmask, as an alternative to the /DecimalNumber notation)
> This is certainly only an issue with the entry in pg_hba.conf, on the
> server to be contacted, just missing the correct configuration.
>
> Remember OS user "joe" != postgresql user "joe"
> postgresql user "joe" must have been granted access to the database
> instance you're attempting to connect to, then you can have an entry like:
>
> host all all 192.168.1.1/32 trust ( where postgresql user "joe"
> would be implied )
>
Thanks Louis!
Problem was in pg_hba.conf as error message suggested ;)
Servers are now in different subnets and my configuration was
out of date. Sorry.
--
-jussi
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
