Installing PostgreSQL 8.1 on VISTA

[sebouh181]

I'm trying to install PostGres8.1 on VISTA but at the end of the installation it's saying that "can not create user postgres:Access denied" and roles back. Any Ideas how to fix this issue???
ANY HELP????!!!!!

[michaelb]

What kind of privileges you have with your user account?
I did not work with Vista, but I think you need to look at User Account Control , and perhaps run a quick test - see if you can manually create a new user on this PC.

[sebouh181]

I created a user called postgres but it didn't work either.

[michaelb]

Actually I meant "try to create some user", just to see if you have enough privileges for that. Postgres may not be able to complete installation if specified user already exists. I would delete this user before attempting another install.

What you experiencing is a compatibility issue with installation, (you can call it a bug; looks like it will be fixed in version 8.3)
This problem is documented here
along with some hints on how to work around it and make install work.

You may also find some practical help in this article

They make a couple of interesting comments relevant to your problem:

Prior to version 8.2, PostgreSQL refused to run with administrative privileges as a security precaution designed to limit the damage caused by a security incident involving this software.
... ... ... ...
Notes on Vista:
The install on Vista is similar to other Windows installs but to install on Vista, you must turn off User Account Control first.

[sebouh181]

My Vista is Home Basic. I can not disable UAC. Is there a way that I can disable the UAC?

[michaelb]

Disable User Account Control from prompting for credentials to install applications - read this section here
(actually, it may help to read the entire article)

Alternatively you can try a workaround described in the pgFoundry
I referred to in my previous post:

... run a Command Prompt as Administrator, then directly execute the postgresql-8.2.msi from that command prompt.

[Gerard H]

Enable your Administrator account. Login as the administrator and the install program will then be able to create the user.

Being logged in as an administrative user is NOT the same as being logged in as the Administrator.

[davidturner]

Simpler solution:

1. Start/All Programs/Accessories
2. Right-click on Command Prompt
3. Select "Run as Administrator"
4. Click OK on the dialog that appears
5. cd \[The directory where you put the install files]
6. Run the installer .msi from the command line.

This worked fine for me.

[varathasiva]

very very thanks.This way working fine for me.I am very happy about your posting.Because i am held up on last 15 days for instaling postgres in vista.

Kindly Regards
Siva

[salamnthaz]

Simpler solution:

1. Start/All Programs/Accessories
2. Right-click on Command Prompt
3. Select "Run as Administrator"
4. Click OK on the dialog that appears
5. cd \[The directory where you put the install files]
6. Run the installer .msi from the command line.

This worked fine for me.

Very Thanks....Yes! it worked for me.

Regards
A.Salam

[robintwos]

Thanks alot for Davidturner reply !!! Thanks Much

[actagbo]

Mr. Turner, I have tried to do what you have suggested but still I cannot finish the installation.

I got the message "The user account already exist.!"

Is there another way that Vista users can do this one easily?

Please help!

Thanks!