Обсуждение: PostgreSQL 8.1.4 install failure on Win XP Home laptop

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
messageindicating that the service could not be installed due to insufficient permissions to install services.  The
actualmessage was: Service "PostreSQL Database Server 8.1" (pgsql-8.1) could not be installed.  Verify that you have
sufficientprivileges 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
andremove 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
thathas such).  The only catch I can think of is that its name is not "Administrator".  I've encountered other software
thatrefused to install if the account name was not "administrator" (regardless of actual privileges).  Is this now the
casewith postgresql?   

Any suggestions?

Thanks, in advance,

Gord

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
messageindicating that the service could not be installed due to insufficient permissions to install services.  The
actualmessage was: Service "PostreSQL Database Server 8.1" (pgsql-8.1) could not be installed.  Verify that you have
sufficientprivileges 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
andremove these services without issue. 
>
> I just double-checked and the account I'm signed in under has administrator privileges (the only account on the
laptopthat has such).  The only catch I can think of is that its name is not "Administrator".  I've encountered other
softwarethat refused to install if the account name was not "administrator" (regardless of actual privileges).  Is this
nowthe case with postgresql?   
>
> Any suggestions?
>
> Thanks, in advance,
>
> Gord
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
> !DSPAM:14,44b65d1434531267980985!
>
>
>

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
installerwhen run under XP Home that installer-created accounts are unmanageable by XP Home.  On Windows 2000 (at work)
installer-createdaccounts 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
beforeI attempted the initial upgrade.) 

Thanks,

Gord

-----Original Message-----
From: Andy Shellam [mailto:andy@andycc.net]
Sent: Thursday, July 13, 2006 10:53 AM
To: Hyatt, Gordon
Cc: pgsql-admin@postgresql.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
messageindicating that the service could not be installed due to insufficient permissions to install services.  The
actualmessage was: Service "PostreSQL Database Server 8.1" (pgsql-8.1) could not be installed.  Verify that you have
sufficientprivileges 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
andremove these services without issue. 
>
> I just double-checked and the account I'm signed in under has administrator privileges (the only account on the
laptopthat has such).  The only catch I can think of is that its name is not "Administrator".  I've encountered other
softwarethat refused to install if the account name was not "administrator" (regardless of actual privileges).  Is this
nowthe case with postgresql?   
>
> Any suggestions?
>
> Thanks, in advance,
>
> Gord
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
> !DSPAM:14,44b65d1434531267980985!
>
>
>