X-Original-To: pgsql-cygwin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8093352A6A for ; Sun, 6 Mar 2005 12:26:51 +0000 (GMT) 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 33461-04 for ; Sun, 6 Mar 2005 12:26:48 +0000 (GMT) Received: from smartmx-04.inode.at (smartmx-04.inode.at [213.229.60.36]) by svr1.postgresql.org (Postfix) with ESMTP id 0353952A69 for ; Sun, 6 Mar 2005 12:26:45 +0000 (GMT) Received: from [62.99.252.218] (port=16994 helo=[192.168.1.2]) by smartmx-04.inode.at with esmtp (TLS-1.0:DHE_RSA_AES_128_CBC_SHA:16) (Exim 4.34) id 1D7uqN-0006Je-1T; Sun, 06 Mar 2005 13:26:48 +0100 Message-ID: <422AF71E.2070100@x-ray.at> Date: Sun, 06 Mar 2005 13:27:10 +0100 From: Reini Urban Reply-To: pgsql-general@postgresql.org User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; de-AT; rv:1.7.5) Gecko/20041217 X-Accept-Language: de, en MIME-Version: 1.0 To: "Hagop H." Cc: PGSQL-cygwin@postgresql.org Subject: Re: PostgreSQL installation problem on Windows XP Home References: <20050304210756.3DE4854F47@svr1.postgresql.org> In-Reply-To: <20050304210756.3DE4854F47@svr1.postgresql.org> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit 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: 200503/7 X-Sequence-Number: 4169 Please don't post to the cygwin list issues not related to cygwin. You installed the native win32 version. Installation problems should go to the general list only. See http://www.postgresql.org/community/lists/ Hagop H. schrieb: > I know that my problem is due to my carelessness and ignorance, but I > didn’t think that installing PostgreSQL would cause a state of affairs > not easily reversed. Please excuse the length of the following narrative. > > > > When installing PostgreSQL 8.0.1 on my laptop running Windows XP Home > (SP2), I let the installer create the postgres account and generate a > password. I didn’t write down the password. I figured that if the > installer was going to generate a random password, it would store it in > some configuration or log file and not ask me for it. I was wrong. > (Perhaps a warning for idiots like me would be appropriate in the MSI > installer file?) When I went to connect to the template1 database, > PGAdmin III asked me for the postgres account password, which I was > unable to provide. > > > > Normally this wouldn’t be a problem. I figured I’d just start up Control > Panel and change the postgres account password. Unfortunately, Windows > XP Home doesn’t provide any obvious tools to change a system account > password. I only know how to change user account passwords. Control > Panel’s User Accounts tool is useless for this problem. > > > > I uninstalled PostgreSQL, thinking that reinstalling it might help. I > tried removing the postgres account to no avail. My only indication that > the postgres account still exists is the Windows Services administration > utility. I know of no method to delete the account. Microsoft’s > Knowledge Base provided no help. Windows XP Professional contains a tool > called Local Users and Groups (lusrmgr.msc) that allows the > administrator to change any account’s password. Windows XP Home cannot > run that program. > > > > When I reinstall PostgreSQL, I am asked for the postgres account > password. I know I could rename the postgres account name to postgres1 > or something else, but I don’t know if that will create any further > issues for me. I could also upgrade the laptop’s OS to XP Pro in order > to change the postgres account password, but that feels like using a > sledgehammer to cut diamonds. > > > > I certainly bear most of the blame. It would be too easy to bash > Microsoft for this. I also wish that PostgreSQL’s installer did not > auto-generate passwords that cannot be changed. None of what I went > through was necessary. > > > > If someone could tell me either how to delete the postgres account or > change its password, I would appreciate the assistance. > > > > Regards, > > > > Hagop Hagopian > -- Reini Urban http://xarch.tu-graz.ac.at/home/rurban http://phpwiki.org