Re: "1-Click" installer problems

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: "1-Click" installer problems
Date: 2010-04-01 07:47:50
Message-ID: hp1j37$ufh$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Craig Ringer, 01.04.2010 09:24:
>> I do not like the installer's suggestion to put the data directory into
>> c:\Program Files either, I think this should default to %APPDATA%
>
> That seems fairly sensible *IF* it checks very carefully to make sure
> the postgresql user does not have a roaming profile, ie they're a local
> user not a domain user.

I think the installer should simply not "suggest" any directory, but force the user to select one manually (maybe even activley prevent c:\Program Files). I don't know if this is possible (or how hard it would be) but I think a very useful feature for the installer would be to try to check the permissions that the service account has on the chosen data directory.

> If the datadir was put in an account with roaming profiles enabled,
> Windows would try to sync the datadir to and from the profile share on
> the server at every user login/logout.

Ah, didn't think of that one.

>such as a virus scanner or some funky option.

True.
In the german Postgres forum there are several posts regarding that topic.

It seems that especially Norton and the Windows built-in Antivirus do not work well with Postgres.
Personally I have no problems with Sophos and Avira

Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message dipti shah 2010-04-01 07:52:36 Re: Prevent users to drop triggers applied on table
Previous Message John R Pierce 2010-04-01 07:28:16 Re: Prevent users to drop triggers applied on table