Обсуждение: 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! > > >
On 7/13/06, Hyatt, Gordon <Gordon.Hyatt@joslin.harvard.edu> wrote:
If you are doing an upgrade then the postgres user should already be there. Did you enter the correct password for postgres during the install? You may want to check what privileges postgres has. Not sure if this will help but is worth a look at.
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
==================================================================
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?
If you are doing an upgrade then the postgres user should already be there. Did you enter the correct password for postgres during the install? You may want to check what privileges postgres has. Not sure if this will help but is worth a look at.
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com
==================================================================
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! > > >