MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8;
 format=flowed
Content-Transfer-Encoding: 8bit
Date: Thu, 05 Sep 2019 09:47:08 -0400
From: gilberto.castillo@etecsa.cu
To: mallikarjun t <mallit333@gmail.com>
Cc: Luca Ferrari <fluca1978@gmail.com>, soumitra bhandary
 <soumitra.bhandary@hotmail.com>, Pgsql-admin
 <pgsql-admin@lists.postgresql.org>
Subject: Re: [MASSMAIL]Re: Streaming replication issue
In-Reply-To: 
 <CAOA8XiVUHgeu-NUNar1xdskg_9-0UgYtGL6v3teMqUxmagHHKw@mail.gmail.com>
References: 
 <CAOA8XiVtkOXOEXQzq0B7Cg-zFwwqa6+-BfyaiLgn9CiWL_-_pw@mail.gmail.com>
 <CAKoxK+6egeUv-zzMBXfHuFAZtr=X5ZgRZsvnhk_O821ndsrv+A@mail.gmail.com>
 <CAOA8XiWAcatiS7EDLcmO5frkwj9AncC+JB_DBXfrBWowrajN+w@mail.gmail.com>
 <BMXPR01MB36398157DAFCFBC93CA89C7DE0BB0@BMXPR01MB3639.INDPRD01.PROD.OUTLOOK.COM>
 <CAOA8XiU+MYk2JCjTdTvUzApDM2hz_5m700=MTDLkcOUZp99bBw@mail.gmail.com>
 <CAKoxK+6OR4qN4LH9yhJd2mYzEfGpQXcLhKFSjv2FMNEY4CE0eg@mail.gmail.com>
 <CAOA8XiUOnd-0qYjNdkuG6Y+UdB4jV+ExTpfhQy6nfSjKR1ui-A@mail.gmail.com>
 <CAKoxK+6RTkuQ5qE-_Fh1_q0Qy0oyc+JKwE3iyOoDaLHCUWtA4g@mail.gmail.com>
 <CAOA8XiUp1DaEC4VFeE-G3N2=Ck4goM-VZvr9oEM--YQeG_QUKQ@mail.gmail.com>
 <348e59259ebb469677de80c8b4864a07@etecsa.cu>
 <CAOA8XiVUHgeu-NUNar1xdskg_9-0UgYtGL6v3teMqUxmagHHKw@mail.gmail.com>
Message-ID: <f1097a8d141d9a2ef141516dcd218873@etecsa.cu>
User-Agent: Roundcube Webmail/1.2.5
Precedence: bulk

El 2019-09-05 09:39, mallikarjun t escribió:
> Dear Gilberto,
> 
> ./psql  -p 5444 -d edb -U enterprisedb this one is accessing the EDB
> Advanced Server by using this command.
> Iam already checked the logs role "postgres" is not a login permission
> error message is there.

Do you check it?
/opt/edb/as9.6/bin/pg_ctl -p 5444   -D    /home/postgres/data_96  start

> 
> Regards,
> Malli.
> 
> On Thu, Sep 5, 2019 at 6:35 PM <gilberto.castillo@etecsa.cu> wrote:
> 
>> Hello,
>> 
>> Please, you could check postgresql.log
>> or What is this : ./psql  -p 5444 -d edb -U enterprisedb.?
>> 
>> El 2019-09-05 08:45, mallikarjun t escribió:
>>> Dear  All,
>>> 
>>> Before streaming replication I will access EDB Advanced  Server
>> below
>>> command by using psql
>>> 
>>> ./psql  -p 5444 -d edb -U enterprisedb.
>>> 
>>> I am happily working.
>>> 
>>> When I am starting replication process stop the server and take
>> the
>>> basebackup of PostgreSQL Community version and start the new
>> cluster.
>>> 
>>> for example
>>> 
>>> /opt/edb/as9.6/bin/pg_basebackup  -D  /home/postgres/data_96  -h
>>> <master ip address>  -p 5432  -X stream -R
>>> 
>>> I am  taking basebackup then  after recovery.conf file I include
>>> trigger_file ='/tmp/primary_down',
>>> 
>>> If my master is down unexpectedly, I will promote my Slave to
>> Master.
>>> 
>>> the after I start the server by using following commnad
>>> 
>>> /opt/edb/as9.6/bin/pg_ctl    -D    /home/postgres/data_96  start
>>> 
>>> server started and wal receiver is working properly, but  real
>> problem
>>> is happens here only,
>>> 
>>> I want connect to sever by using following command
>>> /opt/edb/as9.6/bin/psql
>>> 
>>> role "postgres" not a log in permission error message  I am
>> getting ,
>>> I am try to put port number along with that
>>> error: could not connect to the server, locally running this port
>>> number 5432.
>>> 
>>> this is the error message I am getting.
>>> 
>>> Regards,
>>> Malli.
>>> 
>>> On Thu, Sep 5, 2019 at 5:58 PM Luca Ferrari <fluca1978@gmail.com>
>>> wrote:
>>> 
>>>> On Thu, Sep 5, 2019 at 1:54 PM mallikarjun t
>> <mallit333@gmail.com>
>>>> wrote:
>>>>> I tried these two compatibilities I will get the same issue.
>>>> 
>>>> According to the installation guide available at
>>>> 
>>> 
>> 
> <https://www.enterprisedb.com/edb-docs/static/docs/epas/11/EDB_Postgres_Advanced_Server_Installation_Guide_Linux_v11.pdf>
>>>> the database to connect to is 'edb' with user 'enterprisedb'.
>>>> So does
>>>> psql -U enterprisedb edb
>>>> allow you to connect to your cluster?
>>>> 
>>>> Luca