pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL installation problem on Windows XP Home
9+ messages / 6 participants
[nested] [flat]
* PostgreSQL installation problem on Windows XP Home
@ 2005-03-04 21:07 Hagop H. <HagopH@hotpop.com>
2005-03-05 03:48 ` Re: PostgreSQL installation problem on Windows XP Home Afton & Ray Still <rastill@shaw.ca>
2005-03-06 12:27 ` Re: PostgreSQL installation problem on Windows XP Home Reini Urban <rurban@x-ray.at>
0 siblings, 2 replies; 9+ messages in thread
From: Hagop H. @ 2005-03-04 21:07 UTC (permalink / raw)
To: PGSQL-novice@postgresql.org; PGSQL-cygwin@postgresql.org; pgsql-admin; PGSQL-general@postgresql.org
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: PostgreSQL installation problem on Windows XP Home
2005-03-04 21:07 PostgreSQL installation problem on Windows XP Home Hagop H. <HagopH@hotpop.com>
@ 2005-03-05 03:48 ` Afton & Ray Still <rastill@shaw.ca>
1 sibling, 0 replies; 9+ messages in thread
From: Afton & Ray Still @ 2005-03-05 03:48 UTC (permalink / raw)
To: pgsql-novice@postgresql.org, "Hagop H." <HagopH@hotpop.com>
----- Original Message -----
From: Hagop H.
To: PGSQL-novice@postgresql.org ; PGSQL-cygwin@postgresql.org ; PGSQL-admin@postgresql.org ; PGSQL-general@postgresql.org
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.
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
Been there, Done That. Reinstall with a new account Is all I could figure out.
Ray
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: PostgreSQL installation problem on Windows XP Home
2005-03-04 21:07 PostgreSQL installation problem on Windows XP Home Hagop H. <HagopH@hotpop.com>
@ 2005-03-06 12:27 ` Reini Urban <rurban@x-ray.at>
2005-03-06 19:34 ` Re: [CYGWIN] PostgreSQL installation problem on Windows XP Home Hagop Hagopian <HagopH@hotpop.com>
1 sibling, 1 reply; 9+ messages in thread
From: Reini Urban @ 2005-03-06 12:27 UTC (permalink / raw)
To: Hagop H. <HagopH@hotpop.com>; +Cc: PGSQL-cygwin@postgresql.org
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [CYGWIN] PostgreSQL installation problem on Windows XP Home
2005-03-04 21:07 PostgreSQL installation problem on Windows XP Home Hagop H. <HagopH@hotpop.com>
2005-03-06 12:27 ` Re: PostgreSQL installation problem on Windows XP Home Reini Urban <rurban@x-ray.at>
@ 2005-03-06 19:34 ` Hagop Hagopian <HagopH@hotpop.com>
0 siblings, 0 replies; 9+ messages in thread
From: Hagop Hagopian @ 2005-03-06 19:34 UTC (permalink / raw)
To: pgsql-general@postgresql.org
Sorry.
I didn't know which list best served general installation questions for the
Windows version. My question has been answered. Thanks for your attention.
Regards,
Hagop
-----Original Message-----
From: Reini Urban [mailto:rurban@x-ray.at]
Sent: Sunday, March 06, 2005 7:27 AM
To: Hagop H.
Cc: PGSQL-cygwin@postgresql.org
Subject: Re: [CYGWIN] PostgreSQL installation problem on Windows XP Home
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: PostgreSQL installation problem on Windows XP Home
@ 2005-03-04 22:10 Bearden Barnes <BBarnes@sprich.com>
2005-03-08 07:07 ` Re: [ADMIN] PostgreSQL installation problem on Windows XP Home Afton & Ray Still <rastill@shaw.ca>
0 siblings, 1 reply; 9+ messages in thread
From: Bearden Barnes @ 2005-03-04 22:10 UTC (permalink / raw)
To: 'Hagop H.' <HagopH@hotpop.com>; +Cc: PGSQL-novice@postgresql.org; PGSQL-cygwin@postgresql.org; pgsql-admin; PGSQL-general@postgresql.org
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
http://support.microsoft.com/default.aspx?scid=kb;en-us;298252
<http://support.microsoft.com/default.aspx?scid=kb;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.
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [ADMIN] PostgreSQL installation problem on Windows XP Home
2005-03-04 22:10 Re: PostgreSQL installation problem on Windows XP Home Bearden Barnes <BBarnes@sprich.com>
@ 2005-03-08 07:07 ` Afton & Ray Still <rastill@shaw.ca>
0 siblings, 0 replies; 9+ messages in thread
From: Afton & Ray Still @ 2005-03-08 07:07 UTC (permalink / raw)
To: pgsql-novice@postgresql.org
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 -----
From: Bearden Barnes
To: 'Hagop H.'
Cc: PGSQL-novice@postgresql.org ; PGSQL-cygwin@postgresql.org ; PGSQL-admin@postgresql.org ; PGSQL-general@postgresql.org
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
http://support.microsoft.com/default.aspx?scid=kb;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.
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
------------------------------------------------------------------------------
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
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: PostgreSQL installation problem on Windows XP Home
@ 2005-03-05 05:06 Hagop Hagopian <HagopH@hotpop.com>
0 siblings, 0 replies; 9+ messages in thread
From: Hagop Hagopian @ 2005-03-05 05:06 UTC (permalink / raw)
To: 'Bearden Barnes' <BBarnes@sprich.com>; pgsql-admin
I did:
Start | Run | mmc | OK.
File | Add/Remove Snap-in | Add... | Local Users and Groups | Add | Local
computer. | Finish.
(A message reading, "This computer is running Windows XP Home Edition. This
snapin may not be used with that version of Windows. To manage user accounts
for this computer, use the User Accounts tool in the Control Panel," came
up.)
I couldn't get MMC to do what it does on my Windows XP Pro computer, no
matter what I tried. The more I think about this, the more I realize that
it's all Microsoft's fault. Changing a password on any type of account on my
PC should be something it lets me do.
Hagop
_____
From: Bearden Barnes [mailto:BBarnes@sprich.com]
Sent: Friday, March 04, 2005 5:31 PM
To: 'Hagop Hagopian'
Subject: RE: [ADMIN] PostgreSQL installation problem on Windows XP Home
I had to use the directions last week (on my computer at home, not with me
here now at work) I recall having to go through some extra steps to get the
Local Users and Groups plug-in. Once I figured out how to see the Local
Users and Groups plug-in (File | Add/Remove Snap-in | Add... | Local Users
and Groups | Add | OK) I was able to see the hidden accounts.
Are you just going to Start | Run then typing in mmc?
-----Original Message-----
From: Hagop Hagopian [mailto:HagopH@hotpop.com]
Sent: Friday, March 04, 2005 5:19 PM
To: Bearden Barnes
Subject: RE: [ADMIN] PostgreSQL installation problem on Windows XP Home
Scratch that previous message. This does not work on Windows XP Home. When I
open the Local Users and Groups snap-in, I get the following message:
This computer is running Windows XP Home Edition. This snapin may not be
used with that version of Windows. To manage user accounts for this
computer, use the User Accounts tool in the Control Panel.
_____
From: Bearden Barnes [mailto:BBarnes@sprich.com]
Sent: Friday, March 04, 2005 5:10 PM
To: 'Hagop H.'
Cc: PGSQL-novice@postgresql.org; PGSQL-cygwin@postgresql.org;
PGSQL-admin@postgresql.org; PGSQL-general@postgresql.org
Subject: RE: [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
http://support.microsoft.com/default.aspx?scid=kb;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.
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: PostgreSQL installation problem on Windows XP Home
@ 2005-03-05 13:41 Bearden Barnes <BBarnes@sprich.com>
0 siblings, 0 replies; 9+ messages in thread
From: Bearden Barnes @ 2005-03-05 13:41 UTC (permalink / raw)
To: Hagop Hagopian <HagopH@hotpop.com>; +Cc: pgsql-admin
Hagop,
You may have missed an earlier post from Jim McMaster in the general list to
someone else with a similar problem. Assuming you've uninstalled PostgreSQL
and want to reinstall, try the command "net user /delete postgres" to delete
the account and start over. I've copied Jim's email below.
--Bearden
-----Original Message-----
From: Jim McMaster [mailto:jim.mcmaster@comcast.net]
Sent: Friday, March 04, 2005 6:08 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] postgres service account
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I found this same problem. The uninstall really needs to remove this
account. Either that, or the next install process needs to be able
to get the random password somehow.
Open a command prompt, then use the command "net user /delete
postgres" to get rid of the account. "net user" shows all users.
- --
Jim McMaster
mailto:jim.mcmaster@comcast.net
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: PostgreSQL installation problem on Windows XP Home
@ 2005-03-06 20:08 Magnus Hagander <mha@sollentuna.net>
0 siblings, 0 replies; 9+ messages in thread
From: Magnus Hagander @ 2005-03-06 20:08 UTC (permalink / raw)
To: Hagop H. <HagopH@hotpop.com>; PGSQL-novice@postgresql.org; PGSQL-cygwin@postgresql.org; pgsql-admin; PGSQL-general@postgresql.org
A couple of comments:
pgadmin asked you for the postgres database account. NOT for the service
account. The postgres database account is never autogenerated, it is
always entered during the installation (on the initdb page).
To change a users password in any windows version, inculding XP Home,
run:
net user accountname newpassword
If it's a domain account, just add "/DOMAIN" at the end.
If you want to delete it, as others has pointed out already, just run
"net user accountname /delete".
I beleive there are also third-party tools available to do this in a
GUI, but I don't know of any specific tool I can point you at.
//Magnus
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Hagop H.
Sent: den 4 mars 2005 22:08
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.
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
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2005-03-08 07:07 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-03-04 21:07 PostgreSQL installation problem on Windows XP Home Hagop H. <HagopH@hotpop.com>
2005-03-05 03:48 ` Afton & Ray Still <rastill@shaw.ca>
2005-03-06 12:27 ` Reini Urban <rurban@x-ray.at>
2005-03-06 19:34 ` Hagop Hagopian <HagopH@hotpop.com>
2005-03-04 22:10 Re: PostgreSQL installation problem on Windows XP Home Bearden Barnes <BBarnes@sprich.com>
2005-03-08 07:07 ` Afton & Ray Still <rastill@shaw.ca>
2005-03-05 05:06 Re: PostgreSQL installation problem on Windows XP Home Hagop Hagopian <HagopH@hotpop.com>
2005-03-05 13:41 Re: PostgreSQL installation problem on Windows XP Home Bearden Barnes <BBarnes@sprich.com>
2005-03-06 20:08 Re: PostgreSQL installation problem on Windows XP Home Magnus Hagander <mha@sollentuna.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox