X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id BCA859DD700 for ; Fri, 13 Jan 2006 09:21:32 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 01371-09 for ; Fri, 13 Jan 2006 09:21:35 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from smtp.nildram.co.uk (smtp.nildram.co.uk [195.112.4.54]) by postgresql.org (Postfix) with ESMTP id 62C599DD6FC for ; Fri, 13 Jan 2006 09:21:29 -0400 (AST) Received: from demolish1 (unknown [84.12.188.208]) by smtp.nildram.co.uk (Postfix) with SMTP id 492AB254C1D for ; Fri, 13 Jan 2006 13:20:42 +0000 (GMT) Message-ID: <004f01c61844$34c77f10$0264a8c0@demolish1> From: "Donald Fraser" To: "[ADMIN]" References: <20060113113300.56539.qmail@web31014.mail.mud.yahoo.com> Subject: Re: support for using runas for pg Date: Fri, 13 Jan 2006 13:20:33 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200601/157 X-Sequence-Number: 20245 >I am able to start and stop database after logging as user postgres in NT. It is clear that you can start and stop postgreSQL using the postgres user. Therefore access to pg_ctl.exe is working as expected! The fact that the problem only exists when you introduce a thrid party tool to perform the same tasks you are able to do when logged on as the postgres user strongly suggests that the problem is with your thrid party tool. That is your third party tool is emulating the command shell environment but not 100%. What happens when you try and run some other application using the postgres user when logged on as the postgres user? For example: 1) log on as postgres and run the program ipconfig.exe (this system program uses the kernel32.dll). 2) When you have established that the previous step works ok, run the same command from a batch/script file using the "runasv" program. Regards Donald Fraser Ps. Please do not include email addresses in your reply - they become public domian and allow spam engines to find them!