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 63E07528B7 for ; Sat, 18 Jun 2005 11:20:31 -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 70631-06 for ; Sat, 18 Jun 2005 14:20:30 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.197.194]) by svr1.postgresql.org (Postfix) with SMTP id 895CE528AA for ; Sat, 18 Jun 2005 11:20:28 -0300 (ADT) Received: (qmail 16503 invoked by uid 500); 18 Jun 2005 14:20:11 -0000 Date: Sat, 18 Jun 2005 09:20:11 -0500 From: Bruno Wolff III To: Stefan Bayer Cc: pgsql-admin@postgresql.org Subject: Re: WindowsXP setup user account problem Message-ID: <20050618142011.GC15547@wolff.to> Mail-Followup-To: Bruno Wolff III , Stefan Bayer , pgsql-admin@postgresql.org References: <20050616094058.D629E528A9@svr1.postgresql.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050616094058.D629E528A9@svr1.postgresql.org> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200506/151 X-Sequence-Number: 17906 On Thu, Jun 16, 2005 at 11:41:00 +0200, Stefan Bayer wrote: > I want to create the postgresql service user unattended (in a batch > process). How can I do that? Especially I couldn't create the right to logon > as service. > > What is the correct procedure to create a service user for postgresql and to > start the service in a batch (unattended) mode? The preferred method is ident authentication if your OS supports it for domain sockets and the batch job is running on the same server as postgres. Otherwise you can put the password in the pgpass file. See 27.12 of the 8.0 documentation.