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