Re: PostgreSQL 8.1.4 install failure on Win XP Home laptop

The service account is still available (PG 8.1.3 can be started), although the account doesn't show in the Control Panel, User Accounts. If I search the system for accounts (when changing the credentials of a service), I do find the account, but have no way of administering it.

Note: the PostgreSQL install created the accounts for me. I'm not sure if this is a bug or a known issue in the installer when run under XP Home that installer-created accounts are unmanageable by XP Home. On Windows 2000 (at work) installer-created accounts show in Computer Management, System Tools, Local Users and Groups, Users.

I will take your advice and attempt to uninstall 8.1.3 and do a clean 8.1.4 install. (I've already done a pg_dumpall before I attempted the initial upgrade.)

Thanks,

Gord

-----Original Message-----
From: Andy Shellam [mailto:andy(at)andycc(dot)net]
Sent: Thursday, July 13, 2006 10:53 AM
To: Hyatt, Gordon
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] PostgreSQL 8.1.4 install failure on Win XP Home
laptop

Hi Gordon,

No PG doesn't require the specific Administrator account - I've got
8.1.4 on this laptop and I'm logged in as "ashe." . One thing I'd
check is if the PostgreSQL service account still exists from your 8.1.3
install - PG may have assigned a random password to this account which
it now cannot log in to. Best thing to do is (after taking a backup of
your data), uninstall PG 8.1.3, remove the postgres service account,
then re-try a clean install of 8.1.4 and restore your data.

Andy

Hyatt, Gordon wrote:
> I've searched the archives and found no helpful info, so I'll ask here.
>
> I've successfully installed v8.1.3 on my laptop and was attempting to upgrade it to version 8.1.4 when I ran into the message indicating that the service could not be installed due to insufficient permissions to install services. The actual message was: Service "PostreSQL Database Server 8.1" (pgsql-8.1) could not be installed. Verify that you have sufficient privileges to install system services.
>
> After I received the message, I attempted to install (and remove) other services I've written. I was able to install and remove these services without issue.
>
> I just double-checked and the account I'm signed in under has administrator privileges (the only account on the laptop that has such). The only catch I can think of is that its name is not "Administrator". I've encountered other software that refused to install if the account name was not "administrator" (regardless of actual privileges). Is this now the case with postgresql?
>
> Any suggestions?
>
> Thanks, in advance,
>
> Gord
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
> !DSPAM:14,44b65d1434531267980985!
>
>
>