I run OpenACS and PostgreSQL on one box. PostgreSQL doesn't use passwords to
authenticate users - which I find cool.
I want to access this very PostgreSQL instance from a box that is
different. The desired authentication scheme is that the accessing user needs
to have an OS account on the database box, so I don't have to turn on
passwords for the databases, but still require a strong authentication. I
tried a bit with pg_hba.conf, but not yet successfully: authentication worked
with any password.
ident authentication is not possible because the accessing box is using
Windows.
The only half-secure way to do this: I restricted access to one particular ip
address.
Can I achieve this?