Re: new instance of postgres on windows

John R Pierce, 18.07.2013 21:20:
>> If you want to install a completely new instance, just put it into
>> a different directory, and given the service a different name.
>>
>> Newer Postgres versions don't need a dedicated Windows user account
>> any more.
>>
>> I usually don't use the installer any more, but I simply unzip the
>> binary distribution, then run initdb with a directory of my choice
>> (making sure the privileges are correctly setup) and then use
>> pg_ctl to register the service. The only thing you need to make
>> sure is to change the port in postgresql.conf before starting the
>> service.
>
>
> service name and pick a alternate port number. Only challenge is
> where to put the data directory. I don't think these should be
> under C:\Program Files under ANY conditions

Absolutely.

> but they don't belong in the current user's %USERPROFILE%\AppData\Local either

Correct.

> I note newer Windows has a C:\ProgramData, so perhaps thats the 'right'
> default choice?

Sounds good to me. The best option is probably to ask the user during installation
(and disallow "c:\Program Files" )