Re: [MASSMAIL]Re: Streaming replication issue

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.

Regards,
Malli.

On Thu, Sep 5, 2019 at 6:35 PM <gilberto(dot)castillo(at)etecsa(dot)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(at)gmail(dot)com>
> > wrote:
> >
> >> On Thu, Sep 5, 2019 at 1:54 PM mallikarjun t <mallit333(at)gmail(dot)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
>