Re: Another XP Pro experience

Jason:

I don't know whether you prefer to be copied on these messages to the
list or not, so I've done it this time.

To the topic,

Jason Tishler wrote:

>>I have a privileged user (root) and an unprivileged user (me), in
>>addition to the postgres user. AFAICT, the second user to log on to
>>Windows cannot connect using psql (or seemingly by any other method).
>>So if a user logs into the system, then another user logs in, the
>>second can't connect.
>>
>>
>
>Does your postmaster accept TCP/IP connections (i.e., runs with the "-i"
>option)? If so, can the second user connect via?
>
> $ psql -h localhost
>
>I will repeat my plea for help:
>
> Note that I have no access to XP Home or Pro. So, I cannot update
> my README until those with access provide the needed information.
> Any help will be greatly appreciated.
>
>Thanks,
>Jason
>
Jason:

Good thinkin'. Yes, I do accept TCP/IP connections, and yes, they do
work even for the second user, at least this morning. But the "local"
connections don't (I made sure to check again this morning now that I'm
fully alert). As a caveat, I've been seeing failures with my JDBC
application also (which is what caused me to start digging in the first
place), which also (obviously) uses TCP/IP connections, so I will have
to investigate further. Right now I can't reproduce those failures, so
perhaps one of the 19 other changes/diagnostics I tried has fixed this
somehow.

And yes, I'd be happy to keep you (and everyone) updated on my
experiences with XP Pro and pgsql-cygwin. So far, that's my only
platform-specific issue (others have been the standard file permissions
issues on /var/log, /tmp/Multi*, /tmp/cygipc, etc.).

Speaking of permissions, for the real XP newbie (from whom Jason will
eventually receive E-mail if we don't take pre-emptive action, and
perhaps even if we do), it may be worth pointing out that file security
settings are disabled by default, even on XP Pro. XP Pro starts in
"simple file sharing" mode (turn it off in Windows Explorer | Tools |
Folder Options), which presumably chooses a simple set of defaults and
removes the "Security" tab from the file properties dialog. It took a
while to find, since most MS documentation assumes you've turned it off
in advance. (Quite jarring as it kept saying "click the 'Security'
tab," which didn't exist.) The Cygwin ntsec stuff (chown etc.) seems to
work fine though, regardless of "mode."

-- David.