pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Hagop Hagopian <HagopH@hotpop.com>
To: pgsql-general@postgresql.org
Subject: Re: [CYGWIN] PostgreSQL installation problem on Windows XP Home
Date: Sun, 6 Mar 2005 14:34:01 -0500
Message-ID: <20050306193406.0BCA952AA7@svr1.postgresql.org> (raw)
In-Reply-To: <422AF71E.2070100@x-ray.at>

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





view thread (9+ messages)  latest in thread

Message-ID: <20050306193406.0BCA952AA7@svr1.postgresql.org>
Permalink:  ../20050306193406.0BCA952AA7@svr1.postgresql.org/
Also on:    postgresql.org/message-id/20050306193406.0BCA952AA7@svr1.postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: HagopH@hotpop.com, pgsql-general@postgresql.org
  Subject: Re: [CYGWIN] PostgreSQL installation problem on Windows XP Home
  In-Reply-To: <20050306193406.0BCA952AA7@svr1.postgresql.org>
  References: <422AF71E.2070100@x-ray.at> <20050306193406.0BCA952AA7@svr1.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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