Thread: How to install Postgresql on MS Vista?
I tryied it but get errors on create user postgres. Is there some workaround? Thank you Domenico
dfx <dfx@dfx.it> schrieb: > I tryied it but get errors on create user postgres. > > Is there some workaround? I'm not familiar with this crappy OS, but maybe you should disable UAC. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknow) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
Andreas Kretschmer wrote:
> dfx <dfx@dfx.it> schrieb:
>
>> I tryied it but get errors on create user postgres.
>>
>> Is there some workaround?
>
> I'm not familiar with this crappy OS, but maybe you should disable UAC.
>
In your mind, it may be crappy but it is indeed an officially supported
operating system by this project. Let's keep our responses kind shall we.
Sincerely,
Joshua D. Drake
>
> Andreas
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
Joshua D. Drake <jd@commandprompt.com> schrieb: > >>I tryied it but get errors on create user postgres. > >>Is there some workaround? > >I'm not familiar with this crappy OS, but maybe you should disable UAC. > > In your mind, it may be crappy but it is indeed an officially supported > operating system by this project. Let's keep our responses kind shall we. Yes, of course, no problem. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknow) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
The first thing you have to do is disable the User Access Control. > -----Original Message----- > From: pgsql-general-owner@postgresql.org [mailto:pgsql-general- > owner@postgresql.org] On Behalf Of dfx > Sent: Thursday, June 21, 2007 12:58 PM > To: pgsql-general@postgresql.org > Subject: [GENERAL] How to install Postgresql on MS Vista? > > I tryied it but get errors on create user postgres. > > Is there some workaround? > > Thank you > > Domenico > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend This email and any files transmitted with it are confidential and intended solely for the use of the individual or entityto whom they are addressed. If you have received this email in error please notify the sender. This message containsconfidential information and is intended only for the individual named. If you are not the named addressee you shouldnot disseminate, distribute or copy this e-mail.
At 01:58 AM 6/22/2007, dfx wrote: >I tryied it but get errors on create user postgres. > >Is there some workaround? Upgrade to Windows XP SP2? Or Win2K? Regards, Link.
On 6/21/07, Lee Keel <lee.keel@uai.com> wrote: > The first thing you have to do is disable the User Access Control. > No you don't, actually. Just start the installer from an elevated command prompt (Right-click on Command Prompt in the start menu and choose Run As Administrator, change to the installer directory and 'start whatever.msi'). DJ
D.J. Heap wrote: > On 6/21/07, Lee Keel <lee.keel@uai.com> wrote: >> The first thing you have to do is disable the User Access Control. >> > > > No you don't, actually. Just start the installer from an elevated > command prompt (Right-click on Command Prompt in the start menu and > choose Run As Administrator, change to the installer directory and > 'start whatever.msi'). Except the administrator account is disabled by default on Vista. Regards, Dave
Dave Page wrote:
> D.J. Heap wrote:
>> On 6/21/07, Lee Keel <lee.keel@uai.com> wrote:
>>> The first thing you have to do is disable the User Access Control.
>>>
>>
>>
>> No you don't, actually. Just start the installer from an elevated
>> command prompt (Right-click on Command Prompt in the start menu and
>> choose Run As Administrator, change to the installer directory and
>> 'start whatever.msi').
>
> Except the administrator account is disabled by default on Vista.
Huh? What I am confused about, and I don't pretend in anyway to
understand Vista but I just bought my wife a new vista machine and the
default user (the one created during setup) was an Administrator.
Joshua D. Drake
>
> Regards, Dave
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
Joshua D. Drake wrote: > Dave Page wrote: >> Except the administrator account is disabled by default on Vista. > > Huh? What I am confused about, and I don't pretend in anyway to > understand Vista but I just bought my wife a new vista machine and the > default user (the one created during setup) was an Administrator. *An* administrator, not *the* administrator. Think of it in terms of root being disabled, with your wife having 'sudo <nearly anything>' access. Regards, Dave.
Dave Page wrote:
> Joshua D. Drake wrote:
>> Dave Page wrote:
>>> Except the administrator account is disabled by default on Vista.
>>
>> Huh? What I am confused about, and I don't pretend in anyway to
>> understand Vista but I just bought my wife a new vista machine and the
>> default user (the one created during setup) was an Administrator.
>
> *An* administrator, not *the* administrator. Think of it in terms of
> root being disabled, with your wife having 'sudo <nearly anything>' access.
O.k. that makes much more sense. Thanks.
BTW, and this is completely off topic but Vista really doesn't seem
nearly as bad as all the geeks would make it out to be. It seems a nice
evolutionary step ... although it seems a step toward MacOSX ;)
Joshua D. Drake
>
> Regards, Dave.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
Joshua D. Drake wrote: > BTW, and this is completely off topic but Vista really doesn't seem > nearly as bad as all the geeks would make it out to be. It seems a nice > evolutionary step ... although it seems a step toward MacOSX ;) Oh it's certainly got nice eye candy, and is quite easy for the newbie to use, but UAC is a pita (I refer you back to the ECPG update regression check hoohaa). Maybe it's because I use a Mac 50% of the time though... /D
On 6/22/07, Dave Page <dpage@postgresql.org> wrote: [snip] > > Except the administrator account is disabled by default on Vista. > What do you mean? If you logon as an administrator then by default Vista drops a lot of priviledges, but you can get them back to execute a program that requires them by using the 'Run as administrator' right-click menu item (which is on the right-click menu for most things you can run, but not .msi's which is why you have to run them from an elevated command prompt). AFAIK, all the 'Run as administrator' menu item does is give you back your full admin rights if you are an admin (or else it will ask you for an admin user and password) and then run the program in that context. In any case, using an elevated command prompt has worked fine for me with the postgres 8.2.4 installer on 2 different Vista machines and has worked for other msi's that otherwise fail as well. Does it not work for you? DJ
D.J. Heap wrote: > On 6/22/07, Dave Page <dpage@postgresql.org> wrote: > [snip] >> >> Except the administrator account is disabled by default on Vista. >> > What do you mean? Exactly what I wrote. By default, the .\Administrator account is disabled on Vista so you cannot login to it, or runas it. It's easy to re-enable from the Users and Groups MMC snapin of course. > If you logon as an administrator then by default Vista drops a lot of > priviledges, but you can get them back to execute a program that > requires them by using the 'Run as administrator' right-click menu > item (which is on the right-click menu for most things you can run, > but not .msi's which is why you have to run them from an elevated > command prompt). > > AFAIK, all the 'Run as administrator' menu item does is give you back > your full admin rights if you are an admin (or else it will ask you > for an admin user and password) and then run the program in that > context. > > In any case, using an elevated command prompt has worked fine for me > with the postgres 8.2.4 installer on 2 different Vista machines and > has worked for other msi's that otherwise fail as well. > > Does it not work for you? I'm not saying what you suggest won't work, only that you cannot do it on an out-of-the-box install. For the record, I've updated the installer for 8.3 to properly work with UAC. Regards, Dave.
On 6/22/07, Dave Page <dpage@postgresql.org> wrote: [snip] > > Exactly what I wrote. By default, the .\Administrator account is > disabled on Vista so you cannot login to it, or runas it. It's easy to > re-enable from the Users and Groups MMC snapin of course. > Ah yes, but I don't recall doing anything special during Vista installation and it still made my personal user an administrator so I have never needed to use 'the' administrator account. Perhaps I told it to make me an admin during installation, but I don't think so. [snip] > > I'm not saying what you suggest won't work, only that you cannot do it > on an out-of-the-box install. That has not been my experience, but as I said above, perhaps I told it to make me an admin during installation -- I don't recall for sure. > > For the record, I've updated the installer for 8.3 to properly work with > UAC. Great, thank you! DJ