X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id AD8E153D73 for ; Wed, 11 May 2005 18:09:37 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 90158-05 for ; Wed, 11 May 2005 21:09:20 +0000 (GMT) Received: from mail0.lsil.com (mail0.lsil.com [147.145.40.20]) by svr1.postgresql.org (Postfix) with ESMTP id 24A4753406 for ; Wed, 11 May 2005 18:09:17 -0300 (ADT) Received: from milmhbs0.lsil.com (mhbs.lsil.com [147.145.1.30]) by mail0.lsil.com (8.12.8/8.12.8) with ESMTP id j4BL69o7026336 for ; Wed, 11 May 2005 14:06:09 -0700 (PDT) Received: from pop-gresham.gresham.lsil.com (pop-gresham.gresham.lsil.com [172.16.28.1]) by milmhbs0.lsil.com (8.12.11/8.12.11) with ESMTP id j4BL9H8v005527 for ; Wed, 11 May 2005 14:09:17 -0700 Received: from [127.0.0.1] (gr194p177.gresham.lsil.com [172.16.194.177]) by pop-gresham.gresham.lsil.com (8.12.11/8.12.11) with ESMTP id j4BL9FTA006672 for ; Wed, 11 May 2005 14:09:16 -0700 (PDT) Message-ID: <4282747B.90204@lsil.com> Date: Wed, 11 May 2005 14:09:15 -0700 From: Balaji Ganesan Organization: LSI Logic Corporation User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Windows Account Setup Issue - Mapped Network Drive Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Scanned-By: MIMEDefang 2.39 X-Scanned-By: MIMEDefang 2.41 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200505/132 X-Sequence-Number: 17561 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