pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PostgreSQL 8.1.4 install failure on Win XP Home laptop
4+ messages / 3 participants
[nested] [flat]

* PostgreSQL 8.1.4 install failure on Win XP Home laptop
@ 2006-07-13 14:04 Hyatt, Gordon <Gordon.Hyatt@joslin.harvard.edu>
  2006-07-13 14:53 ` Re: PostgreSQL 8.1.4 install failure on Win XP Home laptop Andy Shellam <andy@andycc.net>
  2006-07-13 16:00 ` Re: PostgreSQL 8.1.4 install failure on Win XP Home laptop Aaron Bono <postgresql@aranya.com>
  0 siblings, 2 replies; 4+ messages in thread

From: Hyatt, Gordon @ 2006-07-13 14:04 UTC (permalink / raw)
  To: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: PostgreSQL 8.1.4 install failure on Win XP Home laptop
  2006-07-13 14:04 PostgreSQL 8.1.4 install failure on Win XP Home laptop Hyatt, Gordon <Gordon.Hyatt@joslin.harvard.edu>
@ 2006-07-13 14:53 ` Andy Shellam <andy@andycc.net>
  1 sibling, 0 replies; 4+ messages in thread

From: Andy Shellam @ 2006-07-13 14:53 UTC (permalink / raw)
  To: Hyatt, Gordon <Gordon.Hyatt@joslin.harvard.edu>; +Cc: pgsql-admin

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!
>
>
>   




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: PostgreSQL 8.1.4 install failure on Win XP Home laptop
  2006-07-13 14:04 PostgreSQL 8.1.4 install failure on Win XP Home laptop Hyatt, Gordon <Gordon.Hyatt@joslin.harvard.edu>
@ 2006-07-13 16:00 ` Aaron Bono <postgresql@aranya.com>
  1 sibling, 0 replies; 4+ messages in thread

From: Aaron Bono @ 2006-07-13 16:00 UTC (permalink / raw)
  To: Hyatt, Gordon <Gordon.Hyatt@joslin.harvard.edu>; +Cc: pgsql-admin

On 7/13/06, Hyatt, Gordon <Gordon.Hyatt@joslin.harvard.edu> 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?


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
==================================================================

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: PostgreSQL 8.1.4 install failure on Win XP Home laptop
@ 2006-07-13 15:22 Hyatt, Gordon <Gordon.Hyatt@joslin.harvard.edu>
  0 siblings, 0 replies; 4+ messages in thread

From: Hyatt, Gordon @ 2006-07-13 15:22 UTC (permalink / raw)
  To: pgsql-admin

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@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 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!
>
>
>   




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2006-07-13 16:00 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-07-13 14:04 PostgreSQL 8.1.4 install failure on Win XP Home laptop Hyatt, Gordon <Gordon.Hyatt@joslin.harvard.edu>
2006-07-13 14:53 ` Andy Shellam <andy@andycc.net>
2006-07-13 16:00 ` Aaron Bono <postgresql@aranya.com>
2006-07-13 15:22 Re: PostgreSQL 8.1.4 install failure on Win XP Home laptop Hyatt, Gordon <Gordon.Hyatt@joslin.harvard.edu>

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