Win32 8.3.3 install fail (sufficient privileges to install system services).

On 12/06/2008 18:21, Terry Yapt wrote:

I did installed 8.3.1 on WinXP Prof. and all was ok. After that
successful install I have tried to install 8.2.x without success several
times on the same workstation.

Today I have tried to install 8.3.3 and I have stuck on the same error:

Did you uninstall the other version first? I seem to recall that using
the Windows Installer package you can only have one version installed at
a time.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

Raymond O'Donnell escribi�:

On 12/06/2008 18:21, Terry Yapt wrote:

I did installed 8.3.1 on WinXP Prof. and all was ok. After that
successful install I have tried to install 8.2.x without success
several times on the same workstation.

Today I have tried to install 8.3.3 and I have stuck on the same error:

Did you uninstall the other version first? I seem to recall that using
the Windows Installer package you can only have one version installed
at a time.

Ray.

Uninstall 8.3.1 (without delete data directory) and (fresh/new) install
8.3.3 does the trick.

8.3.3 maintain all data, users, passwords and so on from 8.3.1 install
telling us about that on installation.

And the last question: How to see what versi�n (minor version) is
running on that PostgreSQL DB ?

Greetings.

Raymond O'Donnell escribi�:

On 12/06/2008 18:21, Terry Yapt wrote:

I did installed 8.3.1 on WinXP Prof. and all was ok. After that
successful install I have tried to install 8.2.x without success
several times on the same workstation.

Today I have tried to install 8.3.3 and I have stuck on the same error:

Did you uninstall the other version first? I seem to recall that using
the Windows Installer package you can only have one version installed
at a time.

Ray.

Answering to myself:

Version of PostgreSQL Database:

SELECT VERSION();

Greetings and sorry.

On 12/06/2008 19:38, Terry Yapt wrote:

Answering to myself:

Version of PostgreSQL Database:

SELECT VERSION();

Heh - beat me to it. :-) Glad you're sorted.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

Terry Yapt wrote:

I did installed 8.3.1 on WinXP Prof. and all was ok. After that
successful install I have tried to install 8.2.x without
success several
times on the same workstation.

Today I have tried to install 8.3.3 and I have stuck on the
same error:

===============
Service 'PostgreSQL Database Server 8.3' (pgsql-8.3)
could not be installed. Verify that you have sufficient
privileges to install system services.
===============

After that, you can _only_ CANCEL install. Of course I have
sufficient
privileges because I am on Administrators group. Moreover I am
installing with the same user I have installed 8.3.1 only two
days ago.

Any idea ?

I've a similar problem on one development PC, but another one upgraded fine.

I think the cause is due to the user that gets created to run the service.

On the PC with the problem, I have both 8.2 and 8.3 installed.
8.2 using the user account "postgres" and 8.3 using the user account "postgres83".

To work around it, when the error message popped up, I left it there, and from memory went through a process a bit like this:
- went to services,
- tried to start it using various user accounts, which failed,
- went to my user accounts,
- set postgres83's password to something I could remember,
- accepted the huge warnings about no longer having access to stuff,
- used that password in the service,
- started the service,
- that worked,
- stopped the service,
- closed the services window,
- went back to the installer error message,
- clicked retry,
- which succeeded in starting the service, and completing the upgrade.

Regards,
Stephen Denne.
--
At the Datamail Group we value teamwork, respect, achievement, client focus, and courage.
This email with any attachments is confidential and may be subject to legal privilege.
If it is not intended for you please advise by replying immediately, destroy it and do not
copy, disclose or use it in any way.

The Datamail Group, through our GoGreen programme, is committed to environmental sustainability.
Help us in our efforts by not printing this email.
__________________________________________________________________
This email has been scanned by the DMZGlobal Business Quality
Electronic Messaging Suite.
Please see http://www.dmzglobal.com/dmzmessaging.htm for details.
__________________________________________________________________

I have found in most instances if you leave the services window open
the installer will fail to install (or upgrade) the postgres service.

I have the same problem. I use postgres83 as the login for the service.

The way I get around it is I delete the "InstallServices" row from the
MSI file using ORCA. This has always worked. I made the assumption the
service is just fine and needs no changes.

I am not sure if deleting the service would achieve the same result.
Never tried that.