Re: [MASSMAIL]Re: Streaming replication issue

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