X-Original-To: pgsql-novice-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 69D7352A7D for ; Sat, 5 Mar 2005 03:48:59 +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 03888-01 for ; Sat, 5 Mar 2005 03:48:50 +0000 (GMT) Received: from pd2mo3so.prod.shaw.ca (shawidc-mo1.cg.shawcable.net [24.71.223.10]) by svr1.postgresql.org (Postfix) with ESMTP id 82D6B52A55 for ; Sat, 5 Mar 2005 03:48:49 +0000 (GMT) Received: from pd4mr2so.prod.shaw.ca (pd4mr2so-qfe3.prod.shaw.ca [10.0.141.213]) by l-daemon (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with ESMTP id <0ICV00BP9199A460@l-daemon> for pgsql-novice@postgresql.org; Fri, 04 Mar 2005 20:48:45 -0700 (MST) Received: from pn2ml3so.prod.shaw.ca ([10.0.121.147]) by pd4mr2so.prod.shaw.ca (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with ESMTP id <0ICV00EVP199BS20@pd4mr2so.prod.shaw.ca> for pgsql-novice@postgresql.org; Fri, 04 Mar 2005 20:48:45 -0700 (MST) Received: from rayshome (S01060010b59cc72c.cg.shawcable.net [70.65.136.124]) by l-daemon (iPlanet Messaging Server 5.2 HotFix 1.18 (built Jul 28 2003)) with ESMTP id <0ICV00I1J1983H@l-daemon> for pgsql-novice@postgresql.org; Fri, 04 Mar 2005 20:48:45 -0700 (MST) Received: from 127.0.0.1 (AVG SMTP 7.0.308 [266.6.2]); Fri, 04 Mar 2005 20:48:53 -0700 Date: Fri, 04 Mar 2005 20:48:53 -0700 From: Afton & Ray Still Subject: Re: PostgreSQL installation problem on Windows XP Home To: pgsql-novice@postgresql.org, "Hagop H." Message-id: <006e01c52136$400ab000$7c884146@rayshome> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 X-Mailer: Microsoft Outlook Express 6.00.2900.2527 Content-type: multipart/mixed; boundary="=======AVGMAIL-42292C2515CB=======" X-Priority: 3 X-MSMail-priority: Normal References: <20050304210756.3DE4854F47@svr1.postgresql.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.411 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, FORGED_RCVD_HELO, HTML_60_70, HTML_MESSAGE X-Spam-Level: * X-Archive-Number: 200503/50 X-Sequence-Number: 12582 --=======AVGMAIL-42292C2515CB======= Content-Type: multipart/alternative; boundary="----=_NextPart_000_006B_01C520FB.937055A0" ------=_NextPart_000_006B_01C520FB.937055A0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable ----- Original Message -----=20 From: Hagop H.=20 To: PGSQL-novice@postgresql.org ; PGSQL-cygwin@postgresql.org ; = PGSQL-admin@postgresql.org ; PGSQL-general@postgresql.org=20 Sent: Friday, March 04, 2005 2:07 PM Subject: [NOVICE] PostgreSQL installation problem on Windows XP Home 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. =20 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. =20 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. =20 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.=20 =20 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. =20 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. =20 If someone could tell me either how to delete the postgres account or = change its password, I would appreciate the assistance. =20 Regards, =20 Hagop Hagopian Been there, Done That. Reinstall with a new account Is all I could = figure out. Ray ------=_NextPart_000_006B_01C520FB.937055A0 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
 
----- Original Message -----
From:=20 Hagop = H.
Sent: Friday, March 04, 2005 = 2:07=20 PM
Subject: [NOVICE] PostgreSQL = installation=20 problem on Windows XP Home

I know that my problem = is due to=20 my carelessness and ignorance, but I didn=92t think that installing = PostgreSQL=20 would cause a state of affairs not easily reversed. Please excuse the = length=20 of the following narrative.

 

When installing = PostgreSQL 8.0.1=20 on my laptop running Windows XP Home (SP2), I let the installer create = the=20 postgres account and generate a password. I didn=92t write down the = password. I=20 figured that if the installer was going to generate a random password, = it=20 would store it in some configuration or log file and not ask me for = it. I was=20 wrong. (Perhaps a warning for idiots like me would be appropriate in = the MSI=20 installer file?) When I went to connect to the template1 database, = PGAdmin III=20 asked me for the postgres account password, which I was unable to=20 provide.

 

Normally this wouldn=92t = be a=20 problem. I figured I=92d just start up Control Panel and change the = postgres=20 account password. Unfortunately, Windows XP Home doesn=92t provide any = obvious=20 tools to change a system account password. I only know how to change = user=20 account passwords. Control Panel=92s User Accounts tool is useless for = this=20 problem.

 

I uninstalled = PostgreSQL, thinking=20 that reinstalling it might help. I tried removing the postgres account = to no=20 avail. My only indication that the postgres account still exists is = the=20 Windows Services administration utility. I know of no method to delete = the=20 account. Microsoft=92s Knowledge Base provided no help. Windows XP = Professional=20 contains a tool called Local Users and Groups (lusrmgr.msc) that = allows the=20 administrator to change any account=92s password. Windows XP Home = cannot run=20 that program.

 

When I reinstall = PostgreSQL, I am=20 asked for the postgres account password. I know I could rename the = postgres=20 account name to postgres1 or something else, but I don=92t know if = that will=20 create any further issues for me. I could also upgrade the laptop=92s = OS to XP=20 Pro in order to change the postgres account password, but that feels = like=20 using a sledgehammer to cut diamonds.

 

I certainly bear most of = the=20 blame. It would be too easy to bash Microsoft for this. I also wish = that=20 PostgreSQL=92s installer did not auto-generate passwords that cannot = be changed.=20 None of what I went through was = necessary.

 

If someone could tell me = either=20 how to delete the postgres account or change its password, I would = appreciate=20 the assistance.

 

Regards,

 

Hagop=20 Hagopian

Been there, Done That. Reinstall with a = new account=20 Is all I could figure out.

Ray

------=_NextPart_000_006B_01C520FB.937055A0-- --=======AVGMAIL-42292C2515CB======= Content-Type: text/plain; x-avg=cert; charset=us-ascii Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Content-Description: "AVG certification" No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.6.2 - Release Date: 3/4/2005 --=======AVGMAIL-42292C2515CB=======--