Re: Fwd: Mail to be posted in PostgreSQL community

Hi Venkata,

Thanks for prompt reply.
OS user is administrator user. So, I don't know why there are issues. Can
anyone suggest me steps to do the same?
On 15-Nov-2016 2:26 pm, "Venkata B Nagothi" <nag1010(at)gmail(dot)com> wrote:

>
> On Tue, Nov 15, 2016 at 4:15 PM, kaustubh kelkar <ksquare16(at)gmail(dot)com>
> wrote:
>
>>
>> Hi,
>>
>>
>>
>> Trying to create multiple database instances of PostgreSQL 9.6
>> In this case , trying to create 2nd instance with port 5434/5435.
>>
>>
>>
>> *1st 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-i
>> nstances-of-postgresql-possible )
>>
>>
>>
>> *2nd attempt :*
>>
>>
>>
>> *Create new database cluster : *
>>
>> C:\Program Files\PostgreSQL\9.6\bin>initdb C:\PostgreSQL\9.6\data5435
>>
>> The files belonging to this database system will be owned by user
>> "Administrator
>>
>> ".
>>
>> This user must also own the server process.
>>
>>
>>
>> The database cluster will be initialized with locale "English_United
>> States.1252
>>
>> ".
>>
>> The default database encoding has accordingly been set to "WIN1252".
>>
>> The default text search configuration will be set to "english".
>>
>>
>>
>> Data page checksums are disabled.
>>
>>
>>
>> creating directory C:/PostgreSQL/9.6/data5435 ... ok
>>
>> creating subdirectories ... ok
>>
>> selecting default max_connections ... 100
>>
>> selecting default shared_buffers ... 128MB
>>
>> selecting dynamic shared memory implementation ... windows
>>
>> creating configuration files ... ok
>>
>> running bootstrap script ... ok
>>
>> performing post-bootstrap initialization ... ok
>>
>> syncing data to disk ... ok
>>
>>
>>
>> WARNING: enabling "trust" authentication for local connections
>>
>> You can change this by editing pg_hba.conf or using the option -A, or
>>
>> --auth-local and --auth-host, the next time you run initdb.
>>
>>
>>
>> Success. You can now start the database server using:
>>
>>
>>
>> "pg_ctl" -D "C:\PostgreSQL\9.6\data5435" -l logfile start
>>
>>
>> *Register as Windows Service: *
>>
>>
>> C:\Program Files\PostgreSQL\9.6\bin>pg_ctl register -N pgsql-9.6-5435 -U
>> administrator -P test(at)123 -D "C:\PostgreSQL\9.6\data5435" -o "-p 5435"
>>
>>
>>
>> C:\Program Files\PostgreSQL\9.6\bin>net start pgsql-9.6-5435
>>
>> The pgsql-9.6-5435 service is starting.
>>
>> The pgsql-9.6-5435 service was started successfully.
>>
>>
>>
>> (Reference: http://www.dbforums.com/showthread.php?1669767-How-to-create
>> -two-different-postgresql-services-for-configure-database )
>>
>>
>>
>> *After trying to login through SQL shell*
>>
>> Server [localhost]:
>>
>> Database [postgres]:
>>
>> Port [5433]: 5435
>>
>> Username [postgres]:
>>
>> psql: FATAL: role "postgres" does not exist
>>
>
> As which user (OS user account) you have created the postgresql instance ?
> which means, you need to login as "Administrator" user.
>
> Regards,
>
> Venkata B N
> Database Consultant
>
> Fujitsu Australia
>
>