From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | kaustubh kelkar <ksquare16(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Fwd: Mail to be posted in PostgreSQL community |
Date: | 2016-11-15 15:02:42 |
Message-ID: | cdf143a0-8286-1621-e570-f43cc70e9613@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 11/14/2016 09:15 PM, kaustubh kelkar wrote:
>
> Hi,
>
>
>
> Trying to create multiple database instances of PostgreSQL 9.6
> In this case , trying to create 2^nd instance with port 5434/5435.
>
>
>
> _1^st attempt:_
>
>
>
> *Create new database cluster :
> *
>
> C:\Program Files\PostgreSQL\9.6\installer\server>initcluster.vbs
> postgres postgr
>
> es 12345 "C:\Program Files\PostgreSQL\9.6" "C:\Program
> Files\PostgreSQL\9.6\data
>
> 5434" 5433 DEFAULT
>
>
>
> *Register as Windows Service: *
>
> C:\Program Files\PostgreSQL\9.6\installer\server>startupcfg.vbs 9.6
> postgres 123
>
> 45 "C:\Program Files\PostgreSQL\9.6" "C:\Program
> Files\PostgreSQL\9.6\data5434"
>
> postgresql-x64-9.6-5434
>
>
>
> But after this step, new service is supposed to be found in services.msc
> which is not successful.
>
> (Reference
> http://stackoverflow.com/questions/6241793/are-independent-instances-of-postgresql-possible
> <http://stackoverflow.com/questions/6241793/are-independent-instances-of-postgresql-possible>
Did you read the comments to the first answer?:
" perfect add true in the end of script in step 3. That's ACL check
added in newer postgres version. – Sachin Verma Nov 10 '14 at 12:19
2
After step 4 it doesn't show up for me in services list – Valentin Kuzub
Sep 2 '15 at 13:18
@ValentinKuzub: I had to use "NT Authority\NetworkService" as user name
(with empty password) in step 4, then the new instance did show up in
the list of services. – Martijn Jun 17 at 9:19
"
> )
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Arnaud L. | 2016-11-15 15:11:44 | pg_restore --clean failing due to dependancies |
Previous Message | Albe Laurenz | 2016-11-15 13:19:29 | Re: Converting a TimestampTz into a C# DateTime |