From: Balaji Ganesan <bganesan@lsil.com>
To: pgsql-admin@postgresql.org
Subject: Windows Account Setup Issue - Mapped Network Drive
Date: Wed, 11 May 2005 14:09:15 -0700
Message-ID: <4282747B.90204@lsil.com> (raw)
When trying to run postgres in Windows with a non-admin account, we are
running into issues with network drives.
Currently we run the DB server as a separate user because that's
what postgres wants (it doesn't like to be admin).
But on Windows, the mapped drives letters (to network drives) are
unique to a user session. So when starting postgres as a different
user, it can't see the network drives. Since our application requires the data to
be residing in the network drive and not the local drive, we have the issue.
One option is to map the drives after startup of user process
(more code required to record and do this). But this user process
will most likely not have the required permissions to access the
file anyways. Since the user is a local user and not a domain user
they have not network wide id, so it can only access network resources
as world. It could potentially map drives as a different user (the
original), but then it needs that userid/password (which it doesn't
have).
Does anyone have a suggestion on how to resolve this issue. This looks like a common
problem and any suggestion will be appreciated.
Thanks
Balaji
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: bganesan@lsil.com
Subject: Re: Windows Account Setup Issue - Mapped Network Drive
In-Reply-To: <4282747B.90204@lsil.com>
References: <4282747B.90204@lsil.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox