Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 1C7399FA565 for ; Thu, 23 Aug 2007 22:45:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 11060-02-2 for ; Thu, 23 Aug 2007 22:45:17 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 70B849FA471 for ; Thu, 23 Aug 2007 22:45:22 -0300 (ADT) Received: (qmail invoked by alias); 24 Aug 2007 01:45:20 -0000 Received: from i3ED6DBF0.versanet.de (EHLO [192.168.0.112]) [62.214.219.240] by mail.gmx.net (mp031) with SMTP; 24 Aug 2007 03:45:20 +0200 X-Authenticated: #14269776 X-Provags-ID: V01U2FsdGVkX1+Fe8oAzyGFl909zt+yJt+u9K4nF774jSxZeZ1kRd u939Nsa/Lg6t81 Message-ID: <46CE3837.3030803@gmx.net> Date: Fri, 24 Aug 2007 03:45:27 +0200 From: Andreas User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-AT; rv:1.8.1.6) Gecko/20070802 SeaMonkey/1.1.4 MIME-Version: 1.0 To: Yingqi Tang CC: pgsql-admin@postgresql.org Subject: Re: run postgres.exe as a Windows Administrative account References: <1e9ed6d30708231738m31efc9f5teddbc36d7cf995fe@mail.gmail.com> In-Reply-To: <1e9ed6d30708231738m31efc9f5teddbc36d7cf995fe@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/307 X-Sequence-Number: 26638 Hi, don't confuse the user who initiates the starting process of the DB (double click on the icon) with the one the DB runs under. As far as I know, there should be an unprivileged user e.g. "postgres". "administrator" starts postmaster in the unprivileged context of "postgres" when you start it manually while being logged in as "administrator" or when the service gets automatically started at boot time. At least this is how an PG 8.2.4 runs here. Yingqi Tang schrieb: > I am new to postgreSQL and the first time I tried to execute > postgres.exe I got an error saying the services must be started as a > non-administrative windows user. But I checked the doc and it says > after 8.2 it is possible to run postgres.exe as a windows > administrator. >