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 933E856583 for ; Tue, 8 Mar 2005 07:07:14 +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 66327-09 for ; Tue, 8 Mar 2005 07:07:07 +0000 (GMT) Received: from pd3mo3so.prod.shaw.ca (shawidc-mo1.cg.shawcable.net [24.71.223.10]) by svr1.postgresql.org (Postfix) with ESMTP id B0A945654E for ; Tue, 8 Mar 2005 07:07:06 +0000 (GMT) Received: from pd4mr3so.prod.shaw.ca (pd4mr3so-qfe3.prod.shaw.ca [10.0.141.214]) by l-daemon (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with ESMTP id <0ID00004ZUFUDP50@l-daemon> for pgsql-novice@postgresql.org; Tue, 08 Mar 2005 00:07:06 -0700 (MST) Received: from pn2ml3so.prod.shaw.ca ([10.0.121.147]) by pd4mr3so.prod.shaw.ca (Sun ONE Messaging Server 6.0 HotFix 1.01 (built Mar 15 2004)) with ESMTP id <0ID000AZ6UFUJ270@pd4mr3so.prod.shaw.ca> for pgsql-novice@postgresql.org; Tue, 08 Mar 2005 00:07:06 -0700 (MST) Received: from [70.65.136.124] (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 <0ID00062JUFSV2@l-daemon> for pgsql-novice@postgresql.org; Tue, 08 Mar 2005 00:07:06 -0700 (MST) Received: from 127.0.0.1 (AVG SMTP 7.0.308 [266.6.3]); Tue, 08 Mar 2005 00:07:11 -0700 Date: Tue, 08 Mar 2005 00:07:11 -0700 From: Afton & Ray Still Subject: Re: [ADMIN] PostgreSQL installation problem on Windows XP Home To: pgsql-novice@postgresql.org Message-id: <009f01c523ad$730af720$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-422D4F1F1CE2=======" X-Priority: 3 X-MSMail-priority: Normal References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.529 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, FORGED_RCVD_HELO, HTML_60_70, HTML_MESSAGE, HTML_TAG_EXIST_TBODY X-Spam-Level: * X-Archive-Number: 200503/85 X-Sequence-Number: 12617 --=======AVGMAIL-422D4F1F1CE2======= Content-Type: multipart/alternative; boundary="----=_NextPart_000_009C_01C52372.C676B740" ------=_NextPart_000_009C_01C52372.C676B740 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hello, I was very interested to see this as I have had simmiler problems. = However this again seems to be a xp pro only thing. Thanks Ray (Link provides 7 steps, step 3 doesn't work with home version) (gotta love ms.) (yeah, right.) ----- Original Message -----=20 From: Bearden Barnes=20 To: 'Hagop H.'=20 Cc: PGSQL-novice@postgresql.org ; PGSQL-cygwin@postgresql.org ; = PGSQL-admin@postgresql.org ; PGSQL-general@postgresql.org=20 Sent: Friday, March 04, 2005 3:10 PM Subject: Re: [NOVICE] [ADMIN] PostgreSQL installation problem on = Windows XP Home See the following article in Microsoft's Knowledgebase which describes = how to get to the system accounts in Windows XP Home. It specifically = addresses changing the Windows administrator password, but as long as = you follow the directions you should see the postgres account along with = administrator and other system accounts. Cannot Change the Password for the Administrator Account in User = Accounts in Control Panel Article ID : 298252=20 http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;298252 --Bearden Barnes -----Original Message----- From: Hagop H. [mailto:HagopH@hotpop.com] Sent: Friday, March 04, 2005 4:08 PM To: PGSQL-novice@postgresql.org; PGSQL-cygwin@postgresql.org; = PGSQL-admin@postgresql.org; PGSQL-general@postgresql.org Subject: [ADMIN] 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 -------------------------------------------------------------------------= ----- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.6.3 - Release Date: 3/7/2005 ------=_NextPart_000_009C_01C52372.C676B740 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hello,
I was very interested to see this as I = have had=20 simmiler problems. However this again seems to be a xp pro only=20 thing.
Thanks
Ray
(Link provides 7 steps, step 3 doesn't = work with=20 home version)
(gotta love ms.) (yeah, = right.)
----- Original Message -----
From:=20 Bearden=20 Barnes
Sent: Friday, March 04, 2005 = 3:10=20 PM
Subject: Re: [NOVICE] [ADMIN] = PostgreSQL=20 installation problem on Windows XP Home

See=20 the following article in Microsoft's Knowledgebase which = describes how to=20 get to the system accounts in Windows XP Home.  It specifically = addresses=20 changing the Windows administrator password, but as long as you = follow=20 the directions you should see the postgres account along with = administrator=20 and other system accounts.
 
Cannot Change the=20 Password for the Administrator Account in User Accounts in Control=20 Panel
Article = ID : 298252
http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;298252
 
--Bearden Barnes
 
-----Original Message-----
From: Hagop H.=20 [mailto:HagopH@hotpop.com]
Sent: Friday, March 04, 2005 = 4:08=20 PM
To: PGSQL-novice@postgresql.org;=20 PGSQL-cygwin@postgresql.org;=20 PGSQL-admin@postgresql.org; = PGSQL-general@postgresql.org
Subject:=20 [ADMIN] PostgreSQL installation problem on Windows XP=20 Home

I know that my problem = is due to=20 my carelessness and ignorance, but I didn't 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't write down the = password.=20 I 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=20 was wrong. (Perhaps a warning for idiots like me would be = appropriate in the=20 MSI installer file?) When I went to connect to the template1 = database,=20 PGAdmin III asked me for the postgres account password, which I was = unable=20 to provide.

 

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

 

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

 

When I reinstall = PostgreSQL, I=20 am asked for the postgres account password. I know I could rename = the=20 postgres account name to postgres1 or something else, but I don't = know if=20 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=20 that feels like using a sledgehammer to cut=20 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's installer did not auto-generate passwords that cannot = be=20 changed. None of what I went through was=20 necessary.

 

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

 

Regards,

 

Hagop=20 Hagopian


No virus found in this incoming message.
Checked by AVG=20 Anti-Virus.
Version: 7.0.308 / Virus Database: 266.6.3 - Release = Date:=20 3/7/2005
------=_NextPart_000_009C_01C52372.C676B740-- --=======AVGMAIL-422D4F1F1CE2======= 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.3 - Release Date: 3/7/2005 --=======AVGMAIL-422D4F1F1CE2=======--