Hi everybody,
this is my first post here, so I don't know if this has already be discussed
here.
I tried to use the new sspi authentication in PostgreSQL 8.3 to directly use a
Windows user for PostgreSQL authentication.
So for a test I changed the default "127.0.01/32" line in pg_hba.conf from "md5" to
"sspi" and tried to restart the service.
The restart of the service failed and I found the following lines (multiple
times) in my logs:
---------------------------------------------------------------------------------------------------------------------------------------
2008-02-21 21:17:21 CET LOG: loaded library
"$libdir/plugins/plugin_debugger.dll"
2008-02-21 21:17:21 CET FATAL: SSPI authentication failed for user "postgres"
---------------------------------------------------------------------------------------------------------------------------------------
Then I tried to additionally add the sspi line to the pg_hba.conf.
Now the services immediately fails to start and the only additional line in the
log is:
---------------------------------------------------------------------------------------------------------------------------------------
2008-02-21 21:19:17 CET LOG: loaded library
"$libdir/plugins/plugin_debugger.dll"
---------------------------------------------------------------------------------------------------------------------------------------
No failure, only one of the above line.
Am I doing something wrong or is this a (known) bug?
I'm using Windows XP Professional with SP2 and a lot of additional Microsoft
fixes.
I installed PostgreSQL with the Windows installer.
My computer is not part of any Domain or Active Directory...
Any suggestions (or helpful hints how I can find out, what's going wrong)?
with regards,
Matthias
---------------------------(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