Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 9138C633155 for ; Thu, 12 Mar 2009 17:40:39 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 33212-08 for ; Thu, 12 Mar 2009 17:40:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from hogranch.com (hogranch.com [75.101.82.47]) by mail.postgresql.org (Postfix) with ESMTP id 89B77633661 for ; Thu, 12 Mar 2009 17:40:32 -0300 (ADT) Received: from [192.168.0.2] (porker [192.168.0.2]) by hogranch.com (8.11.6/8.11.6) with ESMTP id n2CKdxI03878 for ; Thu, 12 Mar 2009 13:39:59 -0700 Message-ID: <49B9731F.3070002@hogranch.com> Date: Thu, 12 Mar 2009 13:39:59 -0700 From: John R Pierce User-Agent: Thunderbird 2.0.0.19 (Windows/20081209) MIME-Version: 1.0 To: pgsql-general@postgresql.org Subject: Re: Postgresql References: <20090312194543.GA31198@tux> <49B96A4C.6090007@iol.ie> In-Reply-To: <49B96A4C.6090007@iol.ie> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-HawgScanner-Information: Please contact the ISP for more information X-HawgScanner: Found to be clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/484 X-Sequence-Number: 145070 Raymond O'Donnell wrote: > On 12/03/2009 19:56, Rich Shepard wrote: > > >> will allow this. If the machine runs Microsoft, I've no idea at all >> > > Start Menu > -> Administrative Tools > -> Computer Management > -> Local Users & Groups > -> Users > > ...then right-click on the user, and select "Set password". > or, at a Windows command line prompt, (of course, replacing newpassword with whatever random password you chose) C:\> net user postgres newpassword then make sure the pgsql-8.3 (or whatever) service descriptor is using this same password... C:\> net user postgres newpassword The command completed successfully. C:\> sc config pgsql-8.3 password= mumba$$ [SC] ChangeServiceConfig SUCCESS C:\> net start pgsql-8.3 The PostgreSQL Database Server 8.3 service is starting. The PostgreSQL Database Server 8.3 service was started successfully. (note on the SC CONFIG command, the spacing is critical on that password= ... there's no space before the = and there must be a space after it, quirky little thing)