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.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
