Re: new instance of postgres on windows - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: new instance of postgres on windows
Date
Msg-id ksamhv$okh$1@ger.gmane.org
Whole thread Raw
In response to Re: new instance of postgres on windows  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
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" )




pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Hot Standby and Foreign Tables
Next
From: Raghavendra
Date:
Subject: Re: Reply: Reply: [GENERAL] 回复: [GENERAL] Can't create plpython language