It's rumoured that Robert J. Sanford, Jr. once said:
> i have set up my win2k box with postgres with 7.1.3 cygwin pre-built. i
> have opened a port in my firewall to allow postgres requests to go
> through. a remote user is attempting to hit the box but is getting an
> ident error. in the admin.pdf doc i find the following about ident
> authentication...
>
> "The ident server on the client host is asked
> for the identity of the connecting user.
> Postgres then verifies whether the so identified
> operating system user is allowed to connect as
> the database user that is requested. This is only
> available for TCP/IP connections. The
> authentication option following the ident keyword
> specifies the name of an ident map that specifies
> which operating system users equate with which
> database users. See below for details."
>
> does ident authentication work under win2k?
I don't believe it does.
> if so, does this mean that i need to add my remote user as a user on my
> win2k machine?
>
> if so, what rights do they need to have? and do i need to configure my
> firewall to allow a different port to be opened up?
>
> if i cannot use ident based authentication under cygwin, how do i allow
> remote users who are using the win32 ODBC driver to connect to the
> database? should i switch to kerberos? if so, which version?
>
> he'p me! he'p me! i been hyp-mo-tized!
The easiest option would be to use password authentication, and add the
user to your PostgreSQL system using CREATE USER xxx WITH PASSWORD 'yyy'.
Regards, Dave.