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.
