pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Hagop H. <HagopH@hotpop.com>
To: PGSQL-novice@postgresql.org
To: PGSQL-cygwin@postgresql.org
To: PGSQL-admin@postgresql.org
To: PGSQL-general@postgresql.org
Subject: PostgreSQL installation problem on Windows XP Home
Date: Fri, 4 Mar 2005 16:07:52 -0500
Message-ID: <20050304210756.3DE4854F47@svr1.postgresql.org> (raw)

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

view thread (9+ messages)  latest in thread

Message-ID: <20050304210756.3DE4854F47@svr1.postgresql.org>
Permalink:  ../20050304210756.3DE4854F47@svr1.postgresql.org/
Also on:    postgresql.org/message-id/20050304210756.3DE4854F47@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-novice@postgresql.org, PGSQL-cygwin@postgresql.org, PGSQL-general@postgresql.org
  Subject: Re: PostgreSQL installation problem on Windows XP Home
  In-Reply-To: <20050304210756.3DE4854F47@svr1.postgresql.org>
  References: <20050304210756.3DE4854F47@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